Excel is a commercial spreadsheet program created by Microsoft.

learn more… | top users | synonyms

0
votes
0answers
8 views

Add data series to highlight cases on a box plot (Excel, SPSS or R)

first time user of this forum - guidance on how to provide enough information is very appreciated. I am trying to replicate the presentation of data used in the Medical education field. This will help ...
1
vote
0answers
11 views

R function equal to excel CHIINV [migrated]

I'm looking for a function which do the same thing as excel's CHIINV. From Microsoft documentation, the definition of CHIINV is Returns the inverse of the right-tailed probability of the chi-squared ...
1
vote
0answers
10 views

Split Table by Column Value [closed]

I have a table that list responses to a survey by row. Each row (ID) is a complete questionnaire. Each column is a specific question and the responses to the question is in each cell. How can I split ...
0
votes
1answer
14 views

How to perform a conditional cross-tab in R or Excel? [closed]

I recently was given a project which consists of: pulling together words from ~500 small tweets and doing a matrix, which shows which words occur together in which tweets. I am wondering how I can ...
1
vote
1answer
35 views

Equation to get an ordered logit model from R into Excel

Original I have fitted an ordered logistic regression in R using the polr function, but I am having some trouble bringing the model coefficients into Excel and ...
1
vote
0answers
17 views

Transforming panel data in R/Excel [migrated]

I have following dataset, where WEEK specifies a week in a certain year (W03046 is week 46 in 2003) and MSBRAND stands for the marketshare of a specific brand in the corresponding week: ...
0
votes
0answers
45 views

Encouraging 'de-duplication' (ie: nullifying duplication) in an evolutionary optimization problem

I have a chronological production process with 24 cycles. Each production cycle has 5 of 8 conveyor belts in operation in each production cycle, whilst 3 of 8 belts are always at rest for ...
5
votes
1answer
151 views

Minimizing numbers along diagonal

Please forgive my ignorance if this isn't the appropriate place to ask this question, I'm by no means an expert in statistics. I'll omit most of the esoteric linguistic details here, but I've run up ...
0
votes
1answer
33 views

Excel: Computing a pvalue [closed]

An event has an expected probability of .4. After 100 trials, the event occurred 30 times. How can the pvalue be computed in Excel?
1
vote
1answer
57 views

What is the value of “X” in a regression equation when dealing with a time series?

I am using excel to add a polynomial trend line to a chart. The chart and the formula of the trend line are shown below. I want to add lines indicating different confidence intervals so I need to find ...
3
votes
1answer
30 views

Range of Most Common Values

I have a few numbers such as: 24 65 62 63 39 52 88 21 65 65 62 75 Using Excel, I am looking to identify a range of numbers whose maximum and minimum are not more than 10% ...
1
vote
1answer
59 views

Customizing a graph with gray regions

I'd like to do a graph similar to this one with the gray regions to point the recessions in my graph. I have R and Excel and Stata, I'm simply trying to make it easy to distinguish the recessions by ...
0
votes
0answers
62 views

Data Research Tool For Statistical Analysis and Data Exploration

I'm about to embark on a data analysis project that will involve the following activities: Build a database that includes approximately 5 to 6 tables (sql) or collections(nosql) Building queries for ...
0
votes
2answers
43 views

Log-linear analysis in Excel

Is it possible to conduct a log-linear analysis in Excel? Is a log-linear analysis (as defined in SPSS) the same as a log-linear regression?
0
votes
2answers
40 views

Plotting two graphs of unequal time length in 1 graph

Say I have the following data set. I need to plot both in one graph and when I tried to do so this is what I got. The data of A are not connected by a line so this is not what I want. How do I get ...
0
votes
1answer
232 views

Calculate P value for the correlation coefficient

I would like to understand how people add the P value on a figure for means (Y axis) by age, volume or any other variable (x axis). How did they calculate the P value here? Please check the following ...
2
votes
1answer
57 views

How to build a function with the result of auto.arima in R?

I use: fit = auto.arima(Y, xreg=X) in R to get ARIMA(1,0,0), result as follows: ...
0
votes
0answers
30 views

Bell curve for a table

I have a table in MS-Excel which has cost, product, quartile and Person-days as attributes among others. I have to represent that data in a "nice looking" bell curve or something similar. I haven't ...
1
vote
2answers
82 views

Why is the intersect negative and what does my regression show

I am trying to get my regression right. I want to see, if subs increase how much increase in revenue is seen. The dependent variable is Revenue while the independent variable is subscribers. Least ...
0
votes
0answers
64 views

Regression shows positive linear relationship. Then why this negative equation [duplicate]

I am trying to get my regression right. I want to see, if subs increase how much increase in revenue is seen. The dependent variable is Revenue while the independent variable is subscribers. Least ...
0
votes
0answers
49 views

creating a equation for non linear multiple regression to predict a value based on the inputs given in excel

I have data with 5 columns namely Botany,Zoology,Chemistry,Physics and Rank in a excel sheet . The data here is non linear . So I want to generate a equation in the form of y=a+bx1+cx2+dx3 In ...
1
vote
0answers
59 views

Excel: Data analysis for university rankings

I have some university rankings data where I am asked to analyze whether a higher %of one variable leads to a higher ranking in a particular area. What kind of statistical analysis should I use in ...
0
votes
0answers
28 views

Excel correlate nominal and quantitative

I have the following test data: How do I correlate the "believes" with "before" to determinate if it affects the "after"? When believes is set to 1 the "after" will be (randomly) higher than when ...
0
votes
1answer
122 views

Best optimization package for employee scheduling problem? [closed]

I am looking to solve the optimization problem described below. Which optimization software package would be best suited for this, considering the requirements specified below? Requirements: 1) Can ...
1
vote
2answers
108 views

Arima with xreg, rebuilding the fitted values by hand

I'm using R to do some time series estimation. I'm trying to rebuild the fitted values from an Arima model by hand to use in an Excel spreadsheet using the estimated coefficients and the input data. ...
2
votes
0answers
36 views

Monte Carlo simulation of investment account

I'm trying to estimate performance of an investment account over 20 years. The question is, have I set up the Monte Carlo simulation correctly? I've used Excel. I've assumed 8% average return and 13% ...
0
votes
0answers
43 views

How to figure out if there is a relationship between two datasets (nominal and metric)?

I'm working on winderosion and the question, if there is a relation between erosive winds and high PM10-concentration (fine dust) as a evidence to eroded dust particles. I have two different ...
0
votes
0answers
14 views

How to identify contributors in groups of people

I have a set of 120,000 people. These people are assigned to 10 million groups. Each of these groups have a target variable indicating the kind of output it made (A, B, C or D). I'd like to identify ...
6
votes
4answers
257 views

Help creating a chart to show categorical data over time

The scenario: Over a course of 10 minutes 2 security guards patrol a floor and have their movement tracked. They can either be on the left or the right side of the floor, and within each side of the ...
1
vote
0answers
21 views

How to fit two or more datasets with different occurence for regression

I want to run a regression in R with different datasets. The question is whether stock performance (daily log return) is influenced by factors like interest rates (the one set by fed or ECB), size of ...
0
votes
2answers
140 views

Excel: which products are most frequently ordered together? (clustering question)

I'd like to recruit your help in coming up with an Excel-based method to analyse a set of raw ordering data where each item is on its own row. So, in the data below, order 111 contains two part ...
3
votes
1answer
90 views

Analyzing change in categorical data with age

I have data in an excel spreadsheet of around 500 participants in a taste experiment. The data includes the age of the participant, in addition to one of five locations on their tongue in which they ...
0
votes
0answers
36 views

Please help me plug values into an MA(q) model

yt = u + 0et + 0et-1 + 0et-2 01= .5 02 = .25 My series of existing data is : 1,0,2,0,1,0 So I estimate the first forecast value will be : yt+ 1 = .66 + .5(-.66) + .25 * .34 yt = 1 = .4125 I ...
0
votes
0answers
31 views

Please help me with my MA(q) spreadsheet

Okay I have given this a go but I think it is totally wrong. Can someone please make this correct for me ? To understand the MA(q) model I really need to plug some numbers into it as I', finding these ...
3
votes
2answers
439 views

How to calculate Estimated Arithmetic Mean for a lognormal distribution

I have been tasked to program functions from some Excel sheet into a asp.net app so it can be shared to my colleagues via a web interface. However, I am stuck on one thing. I have a set of variables ...
8
votes
2answers
419 views

What is the best way to Reshape/Restructure Data?

I am a research assistant for a lab (volunteer). I and a small group have been tasked with the data analysis for a set of data pulled from a large study. Unfortunately the data were gathered with an ...
1
vote
1answer
124 views

Chi Square Analysis Percentages

I've used chi-square analysis in school, but was absent for the lesson, and I never quite got the hang of it. I've been successful with it in the past, but now I'm trying to use percentage values, and ...
0
votes
0answers
31 views

Discovering Values with Forecast

So, I have numbers that I know are going to be between 1.01 and 1000. Each value corresponds to 1 second. Is this is a time-series? I've been searching all over, but I can't figure out if these ...
1
vote
0answers
44 views

Reproduce a confidence interval of linear regression in Excel [duplicate]

After a series of tests and exploratory analysis, I have design a linear model in R, the model is the following: ...
3
votes
1answer
666 views

Truncate lognormal distribution with excel

I have a dataset where I extract the mean and the standard deviation, I want to generate a new synthetic dataset which is lognormal distributed based on the original dataset paramaters. Like a ...
2
votes
1answer
90 views

T-Distribution using Excel?

I was given this sample problem: Find the t-value such that the area under the t distribution to the right of the t-value is 0.2 assuming 10 degrees of freedom. So, I went poking around in ...
0
votes
1answer
91 views

Please help me understand white noise and MA(q) [closed]

I am reading the section about moving average models in Hyndman & Athanasopoulos Forecasting: principles and practice. I am trying to understand the MA(q) model in words. What is white noise? Is ...
0
votes
0answers
39 views

Testing whether or not a result is significantly different from another?

If I have a table with results (columns being different feature subsets and rows being different machine learning algorithms) how can I test whether or not some of the results (0-1 loss) is not ...
1
vote
2answers
88 views

Excel CHISQ.TEST

In Excel, if I get a value that is less than alpha (i.e. I get a value near zero) for the CHISQ.TEST function, does this mean that the my observed data follows the expected distribution or is it the ...
2
votes
1answer
34 views

How to minimize SSE with given slope of 1?

With given data, I need a line of slope 1 with minimized SSE. Anyone know how I could do this in R or Excel or another program? If you could tell me how to do it mathematically that might help. ...
1
vote
1answer
148 views

Excel T-Test “Set X is better than Set Y by ___%”

Coming from this post, but their question wasn't fully answered. I understand how the t-test works – if I have two sets of data and want to see if one is better (or worse) than the other, I would say ...
2
votes
1answer
64 views

Significance of $R^2$

I have set up a linear regression array in Excel and now want to test the significance of my $R^2$ value at a certain level of significance. I've only been able to find tables that give the critical ...
5
votes
3answers
2k views

Regression - How do I know if my residuals are normally distributed?

Performing a regression and need to find out if my residuals are normally distributed.
0
votes
2answers
251 views

How to digitize an image graph to excel data? [duplicate]

I'm trying to compare my model results with an experiment. I want to overlap the model curve with experiment curve from a paper. What are my options for digitizing the graph from an image in the pdf ...
0
votes
0answers
144 views

ARMA Model Output & Excel

I am using my Eviews Output of an ARMA Model, taking the coefficients in other to perform my Forecasts in Excel. However, I am not being able to match the residuals of the in-sample estimations ...