Excel is a commercial spreadsheet program created by Microsoft.

learn more… | top users | synonyms

0
votes
0answers
11 views

Checking Friedman-Nemenyi Tests in Practice

Newbie here, unfortunately I don't seem to find a way to upload a .xls file so I'll describe what I did: 1) I want to verify whether there's a statistical realationship between the rankings of 52 ...
0
votes
1answer
50 views
+100

Regression multiple customers per month

I have a file with sales for one complete year. Multiple customers, month number and total sales (per customer): ...
10
votes
1answer
389 views

I have a line of best fit. I need data points that will not change my line of best fit

I'm giving a presentation about fitting lines. I have a simple linear function, $y=1x+b$. I'm trying to get scattered data points that I can put in a scatter plot that will keep my line of best fit ...
0
votes
0answers
29 views

Computing a single regression line with confidence intervals for multiple regression lines

I have multiple regression lines for individual groups (predicted values stored in a data set). I want to compute a single overall quadratic regression fit with confidence intervals for these ...
0
votes
0answers
20 views

Deriving a probability using a more fat tailed T distribution rather than the normal distribution in Excel

I have an estimate of the central limit and standard deviation (SD) of a physical phenomenon. The SD is specifically derived from a limited sample of 12 observations. Using the 'NORMDIST' function ...
1
vote
0answers
20 views

Data Smart Book Exercise [closed]

In the book, Data Smart, by John Foremann, at the end of chapter 4, the reader is asked to optimize a model where only 95 % of the sampled scenarios are met by the model constraints. The relevant ...
0
votes
0answers
41 views

How does one graph a 3 way interaction on excel? Also. how do you explain a 3 way interaction?

So my 3- way is between Prime x ethnicity x gender, not sure how to graph it and how to verbalize it. Any ideas are greatly appreciated. Thank you.
3
votes
1answer
267 views

How to generate a specific number of random binaries with probablities proportional to given values?

I have such a matrix in an excel sheet. It has 140 cells. I want to generate 20 binaries randomly. However, the probability of generating "1" in each cell is proportional to cell's value. Namely, ...
0
votes
1answer
69 views

How is the error calculated in ETS using R?

I'm trying to replicate the ETS algorithms from R in Excel using the formulas present in the link below. https://www.otexts.org/fpp/7/7 According to my research the error is supposed to be ...
1
vote
1answer
41 views

Time Series Comparison - Correlation and Regression Model

I am trying to see if and how the news for affects the financial markets. I have a time-series for both of them. Should I standardise the series? I have a monthly return on prices from the Dow and a ...
0
votes
0answers
10 views

How do you find out the number of intraday cycles for double seasonal exponential smoothing?

I have read about intracycle exponential smoothing in the paper Parsimonious Seasonal Exponential Smoothing. I am having trouble implementing the formula in Excel. It requires us to know the number of ...
3
votes
1answer
42 views

Getting an Excel file with many sheets into R [closed]

I am importing data from an Excel file that contains 15 sheets. Each sheets represent a year in which there are observations on the same variables. Here is what I would like to do (elgantly) from R: ...
0
votes
0answers
39 views

How do I visualize participants' rankings of options in order of preference?

I asked people to 'Rank in order which social media platforms you use most', using Google forms. (The ranking $1$ represented the most used.) There were 10 different social media platforms to choose, ...
0
votes
0answers
41 views

How do I check for seasonality at different time scales with Excel?

I have a table of e-commerce transactions. Sample data follows: ...
0
votes
0answers
78 views

Formula to compute factor scores (used for CFA in lavaan, to be applied in Excel)

I'm asked by my client to recreate cfa model in excel; with all the formulas in the cells. I used lavaan and R to fit the model. It's a simple step to get factor ...
0
votes
0answers
15 views

Data Collection

I was wondering if anyone knew of a survey site or program that collects survey data and presents it in a .txt, csv or other similar file that can easily be used with excel. I'd like to ask 30 survey ...
0
votes
2answers
93 views

Predictive Accuracy formula in Excel or R [duplicate]

I have posted this question, not sure how to move that question to this stats.stackexchange.com. ...
0
votes
1answer
379 views

SPSS - making percentage variables

I need to transform a fairly large data set in order to analyse a certain variable as a percentage. I have seconds that I want to convert to their percentage value but by grouping variables. ie. ...
1
vote
0answers
18 views

Question about relative percent error with widely varying expected values

I'm looking at a large collection of values. These values follow an exponential distribution. I have their probabilities and a pre-made Excel spreadsheet that will auto calculate expected values from ...
3
votes
1answer
738 views

How to find average and median age from an aggregated frequency table

I am using excel and I am trying to find both the average age and median age. I have two columns. 1 for the category and the other for the number of people in each category. ...
1
vote
1answer
88 views

How to change peak height in Excel

I have a normal distributed bell curve (created in excel). I want to change the data so that the peak of the curve is reduced and the edges of the curve are increased, without changing the overall ...
1
vote
0answers
68 views

How can I (numerically) approximate the quantile in a beta distribution in SQL?

I wrote some code in SAS that among other things, used the BETAINV function (or BETA.INV as it's called in Microsoft Excel) to calculate the quantile in a beta distribution corresponding to a random ...
6
votes
2answers
576 views

d prime with 100% hit rate probability and 0% false alarm probability

I would like to calculate d prime for a memory task that involves detecting old and new items. The problem I have is that some of the subjects have hit rate of 1 and/or false alarm rate of 0, which ...
0
votes
0answers
12 views

Do I have a correct understanding of Margin of Error/Accepted Error involved in sampling - Conflicting Previous Answers

I constructed a sample size calculator in Excel: Response Rate * (1 - Response Rate) * [Norm.Inv((1-alpha)/2) * (-1)/Accepted Error]^2 If post sampling I have: p ...
0
votes
1answer
89 views

Excel: Still have to use the normal approximation with GAMMA.INV for high values of alpha?

The GAMMAINV function from Excel 2003 had a propensity for generating NA error messages for high alpha values as the iterative process failed to reach convergence. It was therefore common to use a ...
1
vote
0answers
58 views

To BIN or not to BIN a continuous data to get a Fragment Size Distribution ?

I have a data set in excel of almost 6000 entries (quantitative and continuous => P(X=x)=0, I mean the possible values for my continuous random variable X are uncountably many). Each point will ...
1
vote
1answer
672 views

how to compare two percentages to prove for statistical significance

I have problem to compare the two percentages and to get the statistical significance for these two different percentage. I just want to approve whether these two percentages are significant or not ...
2
votes
2answers
112 views

Calculate data distribution formula from data points

I have 50.000 pieces of data in a list. 10 random samples: 4,877; 4,165; 6,152; 5,544; 6,942; 7,409; 6,415; 5,592; 6,947; 4,965; 4,688 I'm trying to do 2 ...
2
votes
1answer
268 views

Is it possible to get confusion matrices from AUC?

When I have one confusion matrix for each cutoff level (from 0.00 to 0.99), I can compute AUC coefficient. It looks like: ...
1
vote
0answers
34 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
51 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
63 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 ...
0
votes
0answers
46 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
168 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
38 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
102 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
43 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
85 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
79 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
239 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
70 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 ...
1
vote
1answer
5k 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 ...
3
votes
1answer
114 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
57 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
164 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
65 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
129 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
117 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
50 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
285 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 ...