Excel is a commercial spreadsheet program created by Microsoft.

learn more… | top users | synonyms

0
votes
0answers
14 views

Question on the calculated value of the mean in Excel [on hold]

Why isn't the value of the mean I calculate using descriptive statistics in Excel 2013 the same value shown in comparing two groups in the t-test in Excel 2013? Both using the analysis toolpak add-in. ...
1
vote
0answers
15 views

Simple Path to Route Algorithm [closed]

I'm currently conducting research into subway paths, but stand in front of a problem, with no programming knowledge and an extremely short time-limit. Probably the question I am asking is trivial, ...
2
votes
0answers
22 views

Where does SKEW Excel equation come from?

I need to quote Excel's skew equation in a paper but I couldn't find any information about this equation: $n$: size of the population $s$: standard deviation signed $x$: mean Does anyone know ...
1
vote
1answer
29 views

Dummy Data & Regression Analysis

I've been doing some analysis projects at work and I've been supplied with some dummy data regarding whether an applicant has applied on a weekday or weekend (I have set this as 0 for weekend and 1 ...
0
votes
0answers
21 views

Determine if huge data sets come from the same distribution (R or Excel help)

I am doing a work assignment where I need to determine if three data sets come from the same distribution. After plotting the histogram they seem to be some rendition of a lognormal. I currently ...
0
votes
0answers
26 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
2answers
92 views

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
419 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
36 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
25 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
21 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
60 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
285 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
77 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
46 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
14 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
45 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
56 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
47 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
116 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
18 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
117 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
733 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
21 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 ...
4
votes
1answer
1k 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
109 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
88 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
847 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
109 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
81 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
1k 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
143 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
341 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
39 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
65 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
75 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
49 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
176 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
41 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
125 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
56 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
86 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
84 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
271 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
79 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
6k 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
121 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
62 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
199 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 ...