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!

Sales of People magazine are compared over a 5-week period at four Borders outlets in Chicago. Are the population variances the
same for weekly sales (4 stores)?
ITTT
Weekly Sales
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
Click here for the Excel Data File
(a) Calculate the degrees of freedom.
dfi
df2
(b) Based on the given hypotheses, choose the correct option. H: o21 = o22 23 24; Hị: Not all the variances are equal at a
0.05
Reject the null hypothesis if H> 20.6
Reject 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?
No
Yes
help_outline

Image Transcriptionclose

Sales of People magazine are compared over a 5-week period at four Borders outlets in Chicago. Are the population variances the same for weekly sales (4 stores)? ITTT Weekly Sales 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 Click here for the Excel Data File (a) Calculate the degrees of freedom. dfi df2 (b) Based on the given hypotheses, choose the correct option. H: o21 = o22 23 24; Hị: Not all the variances are equal at a 0.05 Reject the null hypothesis if H> 20.6 Reject 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? No Yes

fullscreen
check_circle

Expert Answer

Step 1

Enter the Given data in excel as shown below

help_outline

Image Transcriptionclose

А В C D weekly sales 1 2 store1 store2 store3 store4 100 102 97 89 106 77 91 116 105 82 75 87 105 6 115 80 102 112 101 94 100 LO LO N

fullscreen
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
help_outline

Image Transcriptionclose

? X Anova: Single Factor Input ок SA$2:SDS7 Cancel Grouped By: Columns O Bows Help Labels in first row Alpha: 0.05 Output options Output Range: SIS8:SRS23 New Worksheet Ply: New Workbook

fullscreen
Step 3

Result obtained from ...

help_outline

Image Transcriptionclose

Anova: Single Factor SUMMARY Average Variance Groups Count Sum store1 5 540 108 28.5 437 117.3 store2 5 87.4 90.8 store3 5 454 116.2 101 106 store4 5 505 ANOVA F crit Source of Variation df P-value SS MS Between Groups 1337.2 3 445.733 4.84493 0.01385 3.23887 Within Groups 1472 16 92 Total 19 2809.2 LO LO

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

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

Math

Statistics

Hypothesis Testing

Related Statistics Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: for an experiment involving 3 levels of factor A and 3 levels of factor B with a sample of n=8 in ea...

A: The degrees of freedom values for the F-factor for A*B interaction is (4, 63) and it is obtained bel...

question_answer

Q: A newspaper article reports that the mean cost for preventative dental care per year is $175 with a ...

A: Given:Sample size=250Population standard deviation=$35Sample mean=$171Significance level=0.05Explana...

question_answer

Q: A researcher is interested in conducting a mail survey. He finds out that there is a 40% response ra...

A: Consider X is a random variable defined as the number of responds. n is the number of people, and p ...

question_answer

Q: A researcher reports an independent-measures t statistic with df = 16. How many participants were in...

A: Consider that there are two groups of participants with sample size n1 and n2, respectively.Hence,To...

question_answer

Q: what is the value of SP for the following set of data? x           y 1          4 2          4 9    ...

A: From the given information,

question_answer

Q: Eric wants to estimate the percentage of elementary school children who have a social media account....

A: The formula for the 99% confidence interval for the proportion is given below:

question_answer

Q: With one method of a procedure called acceptance sampling, a sample of items is randomly selected wi...

A: Here, an entire batch of CDs are accepted only if all 3 selected CDs are not defective.

question_answer

Q: The Downtown Parking Authority of Tampa, Florida, reported the following information for a sample of...

A: Given information:Sample size (n) = 250The number of hours cars are parked and the amount they are c...

question_answer

Q: When purchasing bulk orders of​ batteries, a toy manufacturer uses this acceptance sampling​ plan: R...

A: Binomial distribution:Since there are only two outcomes (shipment accepted and shipment rejected), t...