Questions tagged [excel]
Microsoft Excel is a commercial spreadsheet program. Use this tag for any on-topic question that (a) involves Excel either as a critical part of the question or expected answer, & (b) is not just about how to use Excel.
441
questions
0
votes
0
answers
78
views
What data to include in Weibull fit
I have a set of inspection data that I want to fit to a weibull distribution to understand whether further inspection would provide much value.
For example, I have 2000 items of which we have ...
1
vote
1
answer
304
views
How would you graph fiscal year data together with calendar year data?
I have two datasets resembling the toy example below:
...
0
votes
0
answers
171
views
How to replicate the predict function from R in Excel given I have access to "summary" output from R
I have run a 3rd order polynomial regression in R and have run the "summary" function, but I need to be able to replicate the "predict" function in Excel. I have my current working code below. Thank ...
0
votes
0
answers
74
views
How can I obtain hourly readings from 24 hour moving average data? [duplicate]
I have an excel dataset of 24-hour moving averages for PM10 air pollution concentration levels, and need to obtain the individual hourly readings from them. The moving average data is updated every ...
4
votes
0
answers
1k
views
TOST equivalence test in excel
I had a prof once refer to doing science in excel as doing watch repair with oven mitts. Nevertheless, I'm trying...
I'm trying to do a TOST test using excel. I'm basing the equivalence of variances ...
0
votes
1
answer
71
views
When to use Excel versus R [closed]
I've realized the hard way that plotting things like dual y-axis plots is faster in Excel than in R but calculating means for spaghetti plots is easier to do in R than in Excel. In general, when's it ...
0
votes
1
answer
104
views
Statistics: what kind of test to use to test this hypothesis?
I am unsure what kind of a hypothesis test to use in my case:
So we are filling 500 ml bottles with water;
It's a known fact that before a max of 3% of all the bottles could be under-filled;
Now I ...
2
votes
1
answer
556
views
adjusted R squared for multiple exact same input variables
I was trying to understand how adjusted $R^2$ in a simple linear regression behaves when there exists multicolinearity. And realized I could not replicate the adjusted $R^2$ provided by excel data ...
3
votes
3
answers
3k
views
How to test for statistical difference for discrete data
I'm designing an experiment to evaluate reagents used to develop fingerprints. There will be a variety of objects with different surfaces, 2 different reagents, 3 different fingerprint donors (prints ...
0
votes
1
answer
3k
views
EXCEL 2016 Adding Extra Columns to file when Saved as a .csv File [closed]
I have this .csv file that I created from an EXCEL 2016 spreadsheet. This file does not work when I try and upload it to an online web service I use because there are extra columns at the end of the ...
0
votes
1
answer
557
views
Two sample T test frequency table
I am struggling with a data analysis. I have made a survey and got the following answers in the first turn, I put them in a frequency table
Don't agree at all: 8
Don't agree: 6
I don't know: 16
...
1
vote
2
answers
188
views
checking of correctness of excel program for F test
i would like to express my doubt about F test performed by Analysis toolpak , let us consider following link
F Test in excel
everything seems ok until calculation of one tail critical value, ...
1
vote
0
answers
193
views
Correlation between Likert scale question and binary question? [duplicate]
I am writing a report and I need to find correlation between question: how much do you trust banks (from 1-I dont trust them at all and 5-i trust them completely) and question: are you a member of ...
0
votes
1
answer
3k
views
Cross sectional regression in excel [closed]
Hi Can someone please let me know whether cross sectional regression is possible in Excel?
I'm trying to evaluate CAPM from MacBeth regression.
I need to run the cross sectional regression, but ...
0
votes
2
answers
2k
views
How can I determine standard deviation in excel given the probability that values will fall within a defined range?
Assuming a normal distribution with a mean of zero, if I am told that 68.2% of the population values are within +/- 4.7, I can conclude that the standard deviation is also 4.7.
But what if I am told ...
0
votes
1
answer
22
views
index and base year
I am creating a league table of a group of people with the aim to track their performance on 5 KPIs using indices. Base month value is set to 100. Out of 5 KPIs, an increase in 3 indices means good ...
0
votes
0
answers
662
views
Transforming raw scores to scaled scores using a proprietary scale
I'm working with questionaire answers from the Child Behavior Checklist (CBCL) for my master's thesis. The 113 items on the questionaire are organized into several subscales for different areas of ...
0
votes
0
answers
41
views
Testing forecast accuracy in Excel [duplicate]
I'm looking for some advice on how to determine how accurate a forecast is.
Basically, what I have is 23 years of competitive results for a particular sport (10000+ matches). The matches are broken ...
1
vote
0
answers
91
views
Interpretation of linear regression intercept
I am aware this is a very basic question. I just need clarification (for my sanity)
For this regression:
Is it true to say that:
The regression outturn records the intercept as significant. (If ...
0
votes
1
answer
74
views
Statistical analysis, repeated measures t test or anova? Trouble with input when running any test
I've tried using google sheets/excel, but I can't figure how to run a 2 factor without repetition ANOVA (if that's the appropriate test for this data set). I think it's the way I set the spreadsheet ...
0
votes
4
answers
15k
views
How to: Analysing 5-Point Likert Scale with ANOVA
I am very confused since I could not find an understandable answer for it:
I must analyse my Likert Scale data with ANOVA to get the significance (using the ANOVA is the requirement...).
I have to ...
3
votes
2
answers
234
views
How would you go about modelling a sport with a fixed maximum score line (e.g. volleyball or tennis?)
In short, I don't have a great maths background but have always mucked about with modelling sports and making predictions (as I enjoy it).
I have always used the Hal Stern "The Probability of Winning ...
0
votes
1
answer
1k
views
How does Excel interpolate / imputate missing values in time-series when fitting a line to a plot?
I have a scatter plot in Excel (upper part of the screenshot) of time-series data. In-between the values that I plot (to the left), are some missings. I fit a (linear) line to those values and display ...
0
votes
0
answers
49
views
Weighted Standard Deviation in Excel [duplicate]
I have a dataset in excel that looks like this:
...
3
votes
1
answer
3k
views
Different regression coefficients in R and Excel
Asking a separate question because whilst this has been answered for polynomial regression the solution doesn't work for me.
I'm performing a simple linear regression. Both R and Excel give the same ...
0
votes
1
answer
415
views
Monte Carlo simulation--Have I applied Bernoulli distribution properly? [closed]
I am trying to run a monte carlo simulation and I just wanted to make sure that I set it up properly.
A salesman visits 100 different homes. Someone answers the door 80% of the time. Of that ...
1
vote
0
answers
49
views
Find correlation between names and score
I'm new to data mining and hope you can help me with my task :)
First some details about my (input data)
I've got an excel table with the following structure:
...
2
votes
1
answer
220
views
Assessing pre-post survey data with change scores?
I have about 50 pre & post-surveys for an intervention. I am limited to using excel and was told to only calculate the change scores.
For example:
...
0
votes
1
answer
1k
views
read.csv() columns NULL [closed]
This is a very simple question I hope, but just can't seem to solve myself.
I'm trying to read a .csv file of integers into R using read.csv(), however for analysis reasons I need to convert all the ...
1
vote
1
answer
170
views
Terminology Question (ANOVA/t-test) - With and Without Replication?
Coming from a Psychology background, I have always been taught statistics terms as "within subjects" and "between subjects". Now using excel I see they are using the terms Anova - 2 Factor With ...
1
vote
1
answer
1k
views
Calculating regression weights from a covariance matrix [duplicate]
My starting point is a covariance matrix (Not raw data) and I want to calculate the regression weights. I may have as many as 6-8 independent variables and 1 dependent variable so looking for a ...
1
vote
0
answers
51
views
How to represent local significant differences between curves
I want to compare some curves to a 'normality corridor', and I would like to show in what regions (x values) the difference is significant.Take the example below, where I want to compare the dashed ...
0
votes
1
answer
151
views
ANOVA & Sums of Squares in Excel and R
In this simple dataset, I have bird populations from three watersheds. I am completing an ANOVA by hand and in R and comparing the outputs.
...
-1
votes
1
answer
105
views
A proper function for nonlinear regression with 3 predictors
There are three independent variables in my experimental work, namely flow rate (0.5 ≤ Q ≤ 9 where ΔQ = 0.5), particle size (a = {6, 10, 15}), and a geometric parameter (AR = {AR1, AR2, AR3, AR4}). ...
0
votes
1
answer
1k
views
How to calculate statistical significance of a difference between two groups?
I have two groups A and B. Each group involves some number of users. For example, let's imagine that the group A has 2000 unique users on Monday, while the group B has 2002 users on the same day.
For ...
1
vote
0
answers
22
views
Basic way to find out relationships and correlations / mediators
Currently I am looking for a very basic way to analyze relationships in a data set which contains nominal and ordinal data.
Mainly I want to investigate, whether two groups, defined by a dichotomous ...
0
votes
1
answer
5k
views
Excel Regression - Training and Test Data
I am curious about the Excel regression function and evaluation of training and test data. Unlike using a program like R or Python where you state the values for your test and training data, Excel ...
-1
votes
1
answer
1k
views
What is a good model to forecast a single variable?
Let's say I have the values of a variable x for a time period of 15 years. What is a good statistical model to find the values of this variable for the next 10 years?
How good is excel's forecast ...
86
votes
7
answers
19k
views
Line of best fit does not look like a good fit. Why?
Have a look at this Excel graph:
The 'common sense' line-of-best-fit would appear be an almost vertical line straight through the center of the points (edited by hand in red). However the linear ...
1
vote
1
answer
28
views
Make value ranges to guess
Hi I have excel sheet with following like data of shoppers and money they used:
...
0
votes
2
answers
2k
views
How can I plot an ROC curve? [closed]
Given this simple data:
How can I plot an ROC curve in Microsoft Excel? Step by step instructions would be very helpful. I know my TPR is ~87% and my FPR is ~13%. How do I know where to set the ...
1
vote
1
answer
168
views
Office Desk Rota Assignment problem
This is not a home work and the question is not related to studies (I am not a student). I have to do the weekly desk rota at the office and thought this forum might help with suggestions. My problem ...
1
vote
0
answers
86
views
Which statistical test should I use to compare land use type and species abundance?
I have abundance data for a species of bird and data on land use type in the areas where the bird data was collected. I want to test whether land use type affects bird abundance but I don't know what ...
3
votes
1
answer
69
views
Analysis of a dataset including dichotomial, ordinal and % data
I'm working on a dataset which is giving me trouble. I have 200 samples (Sample 1, Sample 2...). An example dataset (limited to 15 samples) is here. My dataset is structured with the following ...
0
votes
1
answer
380
views
Statistic problem to be resolved on Excel (or VBA) [closed]
I have a stat problem and I am not sure it can be resolved; I am not good in statistic but maybe someone can help me:
I need to create two numbers: $v_1$ and $v_2$ with Excel or VBA.
I want both ...
0
votes
1
answer
207
views
Sample Size Estimation for Two Sample T-Test (Excel)
I'm trying to work out how to calculate the necessary sample size for a two sample t-test using excel and need some help.
I don't think I am able to upload an excel attachment, so I will write out ...
0
votes
1
answer
75
views
What type of distribution to use?
This is my first post here.
I am making a financial model in excel of the feasibility of a project.
Herefore I need to make some assumptions. One of those assumptions would be the fuel price and how ...
2
votes
1
answer
2k
views
Forecasting Monthly Timeseries Data in Excel
I am trying to create a forecast using a monthly timeseries data set of marketing expenses for a fictional company. The data looks something like this:
Using linear regression to forecast future ...
2
votes
3
answers
198
views
How to isolate price effect in time series?
Here is what I have:
Excel
Yearly energy prices by state from 2002 (generally increasing, generally peaked a couple of years ago)
Yearly energy consumption by state by industry from 2008 (about 700 ...
0
votes
1
answer
56
views
Calculating t-value for regression coefficients
I am estimating a nonlinear model as follows:
$$Y=B_0+B_1X_1+B_2X_2+B_3aX_3^{1-b}+B_4$$
I have estimated $B_0$, $B_1$, $B_2$, $B_3$, $B_4$, $a$, and $b$ using least squares in Excel (minimizing SSR ...