Excel is a commercial spreadsheet program created by Microsoft.

learn more… | top users | synonyms

0
votes
0answers
14 views

Excel - Generate n sample with a certain level of confidence [on hold]

I was wondering if it's possible to generate n samples that will show the right average/number (or above) with a certain level of confidence. Let's imagine that I have an average of 100 and I want to ...
0
votes
0answers
3 views

Excel range not increasing [migrated]

I have the following formula: =IF($L$12=3,$L3,IF($L$12>3,0,IF($L$12<3,B$3+$L15))) When I copy it over, I want the 3 in L3 and the 15 in L15 to increase, but they stay the same. They increase ...
0
votes
0answers
13 views

How to find range of values given a range of probability with Excel [on hold]

In excel, where i already have STDDEV.P calculation out of a range of numbers. I use NORMDIST(x, mean, stddev, cumulative) to find the probability of value X. however, how do i reverse this, and find ...
0
votes
1answer
23 views

Nonlinear forecasting

I'm working with time series data (which fluctuates constantly) and currently have 27 data points to forecast with. Would anyone be able to recommend a nonlinear forecasting method using formulas to ...
1
vote
1answer
20 views

Use CHIINV or CHISQ.INV to report Chi Square statistic?

I'm looking to report a chi-squared statistic for a chi-squared goodness of fit test using a 2x2 table. ...
0
votes
2answers
65 views

How do I forecast weekly sales using historical numbers? [on hold]

I want to predict the weekly sales forecast using 2 years of historical numbers using the history of weekly sales. Could you let me know what the preferred statistical approach is and what software ...
-1
votes
0answers
8 views

How can I do =INDEX(_,MATCH(_,_,0)) of Excel In Stata? [migrated]

I would like to use the same concept as =INDEX(,MATCH(,_,0)) of Excel in Stata 12, exclusively using Stata programming. Is there a way to match one value with a column (say variable A), and then give ...
0
votes
1answer
28 views

Weighted median of a portfolio

I need to calculate weighted median return for a portfolio (using MATLAB). There is information available online: MATLAB Central/rates&weights and Excel/note 4+4+4+7+7/5 logic How would you ...
0
votes
0answers
14 views

Matching data in excel based on certain words [migrated]

I am compiling a data base on Tennis players for a college project. I have two spreadsheets with lots of relevant information, one with performance related statistics for every ATP match played over ...
1
vote
0answers
34 views

Difference between RSQ function in Excel and Regression in the Excel Data Analysis Add-in?

When I use the RSQ function between one x variable and y variable, the resulting $R^2$ differs from the $R^2$ values given by running regression analysis from excel's Data Analysis. For example, ...
0
votes
0answers
48 views

Peak heavy data filter

I am trying to replicate the motion of a measurement needle with a set radius crossing over a rough surface in order to measure the surface texture. How can I create a filter to replicate this motion ...
1
vote
1answer
35 views

Visualizing the trend of monthly change in a times-series year-over-year

I am interested in a better way to plot monthly changes in a time-series. Especially I'd like to compare how the monthly change this year differs from the monthly change last year. Monthly change is ...
0
votes
0answers
6 views

One variable multiple treatments

I'm drawing a blank on how to analyze this data. I've got one drug/treatment type (variable) with multiple answer options (4 to be exact) and I'd like to compare the answer options for significance. ...
0
votes
0answers
9 views

Non-linear Variables in Excel [duplicate]

Regarding the following equation in excel regression: y = x + x^(-.5) + e I have made the equation nonlinear in the sense that I added to the data a new column which takes the values of x to the ...
1
vote
1answer
25 views

How to readibly visualize four related streams of network data?

I have network data coming from four different data streams simultaneously, and would like to visualize the data on some sort of concurrent timeline so I can identify potentially related events. I ...
0
votes
0answers
13 views

Interpreting results of Libreoffice Calc's TTEST function [duplicate]

I'm doing some data analysis on a small dataset (35 individuals) and I'm wondering whether my findings are statistically significant. Individuals are asked questions before and after a treatment, so ...
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
23 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
31 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
32 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
32 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
96 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
441 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
40 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
34 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
26 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
82 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
296 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
78 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
49 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
15 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
68 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
51 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
159 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
156 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
1k 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
24 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
2k 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
140 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
101 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
1k 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
122 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
95 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
2k 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
162 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
396 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
46 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 ...