question archive 1_Magazine sales are compared over a 5-week period at four Used Books stores in San Francisco
Subject:BusinessPrice: Bought3
1_Magazine sales are compared over a 5-week period at four Used Books stores in San Francisco. Are the population variances the same for weekly sales (4 stores)?
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
Transfer this data to an Excel table and determine the degrees of freedom.
Please note that df1 = number of columns -1 and df2 = number of rows -
df1 = _3-3__
df2 = __3-3__
https://openstax.org/books/introductory-business-statistics/pages/12-2-one-way-anovaLinks to an external site.
2_Based on the table in Exercise 1, please use the Data Analysis Toolpack in Excel to run an ANOVA Single Factor Test and determine the f-value: ____________
3_ A company's quarterly sales of soda (number of six-packs sold) at three convenience stores. Does this sample provide sufficient evidence to conclude that there is a significant difference in treatment means?
Store 1 Store 2 Store 3
Quarter 1 1,521 1,298 1,708
Quarter 2 1,396 1,492 1,382
Quarter 3 1,178 1,052 1,132
Quarter 4 1,730 1,659 1,851
Please transfer this data to an Excel worksheet and then run an ANOVA Two Factor test with Replication to determine the Sum of Squares Values for the Columns: ________
4_Based on the data in Question 3, please refer to the ANOVA Two Factor Test with Replication to determine the F-value for the Columns: _______
5_Based on the data in Question 3, please refer to the ANOVA Two Factor Test with Replication to determine the p-value for the Columns: _______ and whether it represents a significant difference from Quarter to Quarter.
____ YES
____ NO