F-Test Two-sample for Variances Use Excel’s 2-sample variances data analysis too
ID: 3260173 • Letter: F
Question
F-Test Two-sample for Variances
Use Excel’s 2-sample variances data analysis tool to solve the following problem. A well-known ice cream store wants to test two different methods for scooping ice cream so they can use the one that has the least variability in their training of new and current employees. It took a sample of the ice cream cones scooped and measured the weights. PLEASE DO NOT USE PICTURES!
Use the F-Test Two-Sample for Variances to test the hypothesis that the variances between the two methods are the same. Interpret the results.
Method 1
Method 2
4.7
3.6
3.9
4.3
3.2
3.9
3.8
5.4
3.9
4.1
4.8
4.7
3.6
4.8
5.1
3.5
4.8
3.9
5.3
3.9
3.4
4.8
4.2
5
5.3
4.4
4.6
Method 1
Method 2
4.7
3.6
3.9
4.3
3.2
3.9
3.8
5.4
3.9
4.1
4.8
4.7
3.6
4.8
5.1
3.5
4.8
3.9
5.3
3.9
3.4
4.8
4.2
5
5.3
4.4
4.6
Explanation / Answer
H0: There is no significance difference between the variance of Method 1 and Method 2
H1: There is significance difference between the variance of Method 1 and Method 2
Let the LOS be alpha = 5%
Descriptive Statistics: Method 1, Method 2
Total Sum of
Variable Count Mean SE Mean StDev Variance Sum Squares
Method 1 12 4.225 0.201 0.696 0.484 50.700 219.530
Method 2 15 4.413 0.153 0.593 0.351 66.200 297.080
Test Statistic
F = S12 / S22 = 0.484 / 0.351 = 1.3789
Lower Critical F: 0.2977242 Upper Critical F: 3.094587
P-Value: 0.5643
Here F value is in the F - Critical values, and P-value > alpha 0.05, so we accept H0
Thus we conclude that there is no significance difference between the variance of Method 1 and Method 2.
i.e. the variances between the two methods are the same
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.