# Sales of People magazine are compared over a 5-week period at four Borders outlets in Chicago. Are the population variances thesame for weekly sales (4 stores)?ITTTWeekly SalesStore 1Store 2Store 3Store 4102978910010677911161058275871158010610211210194100Click here for the Excel Data File(a) Calculate the degrees of freedom.dfidf2(b) Based on the given hypotheses, choose the correct option. H: o21 = o22 23 24; Hị: Not all the variances are equal at a0.05Reject the null hypothesis if H> 20.6Reject the null hypothesis if H< 20.6(c) Calculate the value of Hcalc- (Round your answer to 2 decimal places.)Hcalc(d) Should we reject the null hypothesis?NoYes

Question
Asked Oct 19, 2019
63 views

Hi,

I need help with the attached homework question and below is the excel data file for you as well.

 Store 1 Store 2 Store 3 Store 4 102 97 89 100 106 77 91 116 105 82 75 87 115 80 106 102 112 101 94 100

Thanks!

check_circle

## Expert Answer

Step 1

Enter the Given data in excel as shown below

Step 2

Steps to form analysis in Excel is shown below

• Go to data
• Click on data analysis
• Click on ANOVA: Single Factor
• Enter the details as shown below
• Click ok
Step 3

Result obtained from ...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

### Hypothesis Testing

© 2020 bartleby. All Rights Reserved.