All Questions
Tagged with excel hypothesis-testing
15 questions
2
votes
0
answers
33
views
Unsure as to what tests, how, and potential in a research scenario
There are three classrooms of students of different grades. I want to analyze what variables of these influenced likelihood of scoring 0 on a test. The factors are: grade (8, 9 or 10) and stress level ...
0
votes
1
answer
212
views
Comparing pre and post treatment data - best statistical test?
I am analysing a range of clinical outcomes for a drug treatment and need to compare the values pre and post treatment - I’m using excel to do this and have found that for most of my outcomes the data ...
2
votes
0
answers
28
views
Portion of variance explained by individual properties with ANOVA
I have used the ANOVA test to compare the expected values of three datasets. The data sets contain data about the lifespans of three brands of frying oils. I have used Excel to perform the test and I ...
0
votes
1
answer
676
views
Calculate correlation between time of day and number of created cases (call center)
I have a data set showing all incoming call during a month and the cases created by the call center agents. The cases are related to a specific call.
My hypothesis is that the agents create less ...
0
votes
1
answer
4k
views
How to properly calculate the exact p-value for binomial hypothesis testing (e.g. in Excel)?
I am confused with calculation of the p-value for binomial hypothesis testing when not using the normal approximation and its Z-statistic.
My hypothesis testing is for the situation when H₀: π = π₀ ...
0
votes
1
answer
22
views
How do i analyze my data statistically [closed]
I need help regarding hypothesis testing. Not a statistics major but familiar with basic concepts (basic descriptive statistics, frequency, measures of: central tendency, location, dispersion) so ...
0
votes
1
answer
108
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 ...
3
votes
3
answers
4k
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 ...
1
vote
2
answers
193
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
1
answer
1k
views
Hypothesis test binomial distribution in Excel
I have a list of invoices and a list of payments. (both with order ID)
I want to test if the amount of unpaid invoices is significantly less than 10% using binomial test in Excel
How do I do this?
1
vote
1
answer
75
views
Is is statistically correct to use binom.dist in excel to test equality of two population proportions?
I have two independent populations with size n1=272 and n2=664. The number of successes are x1=4 and x2=6 respectively.
Is it statistically correct to use binom.dist() function to test the equality ...
0
votes
1
answer
2k
views
What statistical test to use - comparing models?
Say, I have created 3 models that evaluates the amount of harmful pollution. It uses a variety of factors (location, time of year, etc.) to determine this.
I have a bunch of data for 10+ Cities from ...
3
votes
1
answer
3k
views
(non) linear regression on graphs with multiple y per x values
I have a data set with multiple y values per x value. Using Excel the scatter plot and the regression line tools, I wish to apply regression on the data to determine if there is any connection between ...
6
votes
1
answer
5k
views
Chi-squared distribution for dice not returning expected values?
I'm trying to verify that my dice are reasonably fair and balanced. I'm not sure I'm doing it right, though, since I'm basically teaching myself stats without references. To achieve this, I've settled ...
5
votes
2
answers
13k
views
How to get the expected counts when computing a chi-squared test?
I just have 1500 data points in excel. However, I want to do a chi squared test to prove if the data is normaly distributed.
My question is: How to calculate the expected range for such a large data ...