Question

In: Math

Sales of People magazine are compared over a 5-week period at four Borders outlets in Chicago....

Sales of People magazine are compared over a 5-week period at four Borders outlets in Chicago.

Weekly Sales
Store 1 Store 2 Store 3 Store 4
103 98 89 105
  104 77 94 117
105 83 75 86
112 82 104 104
114 98 91 98

Fill in the missing data. (Round your p-value to 4 decimal places, mean values to 1 decimal place, and other answers to 3 decimal places.)

Treatment Mean    n Std. Dev
Store 1            
Store 2            
Store 3            
Store 4            
Total            
One-Factor ANOVA
  Source SS     df    MS F p-value
  Treatment               
  Error         
  
  Total      
   
(a) Based on the given hypotheses choose the correct option.
H0: μ1 = μ2 = μ3 = μ4
H1: Not all the means are equal
α = 0.05

  
  • Reject the null hypothesis if F < 3.24

  • Reject the null hypothesis if F > 3.24

(b) Determine the value of F. (Round your answer to 2 decimal places.)
  F-value   
(c)

On the basis of the above-determined values, choose the correct decision from below.



  • Reject the null hypothesis.

  • Fail to reject the null hypothesis.

(d) Determine the p-value. (Round your answer to 4 decimal places.)
  p-value   

Solutions

Expert Solution

For the given samples the description of the sample is done in excel tool and some formulas are shown in that as:

Mean =AVERAGE(B2:B6) ,Standard deviation==STDEV.S(B2:B6) Store 1 Store 2 Store 3 Store 4 Total
103 98 89 105
104 77 94 117
105 83 75 86
112 82 104 104
114 98 91 98
Mean= 107.6 87.6 90.6 102 387.8
n= Sample size= 5 5 5 5 20
Standard deviation= 5.030 9.762 10.455 11.292

36.538

a) Performing one-factor ANOVA on the given samples in excel results is:

ANOVA: Single Factor
SUMMARY
Groups Count Sum Average Variance
Store 1 5 538 107.6 25.3
Store 2 5 438 87.6 95.3
Store 3 5 453 90.6 109.3
Store 4 5 510 102 127.5
ANOVA
Source of Variation SS df MS F P-value F crit
Between Groups 1333.35 3 444.45 4.9743 0.0126 3.2389
Within Groups 1429.6 16 89.35
Total 2762.95 19

a) Based on the Hypotheses:

H0: μ1 = μ2 = μ3 = μ4

H1: Not all the means are equal

Rejection region:

At 0.05 level of significance the F-critical value is 3.24 ( As computed in excel or can also be computed using F-table) so, Reject the null hypothesis if F > 3.24.

b) From the One way, ANOVA shown above the F statistic is calculated as:

F=4.97

c) Decision:

On the basis of the above F statistic and calculation, we reject the Null hypothesis since F >F-critical value=3.24.

d) P-value:

The P-value is computed using the excel tool as shown above through ANOVA as:

P-value=0.0126.


Related Solutions

Sales of People magazine are compared over a 5-week period at four Borders outlets in Chicago....
Sales of People magazine are compared over a 5-week period at four Borders outlets in Chicago. Weekly Sales Store 1 Store 2 Store 3 Store 4 103 95 87 100   105 73 89 117 106 79 74 88 115 78 106 101 114 99 94 100 Fill in the missing data. (Round your p-value to 4 decimal places, mean values to 1 decimal place, and other answers to 3 decimal places.) Treatment Mean    n Std. Dev Store 1      ...
Sales (in thousands) of the new Thorton Model 506 convection oven over the eight-week period since...
Sales (in thousands) of the new Thorton Model 506 convection oven over the eight-week period since its introduction have been as follows: Week Sales 1 18.6 2 21.4 3 25.2 4 22.4 5 24.6 6 19.2 7 21.7 8 23.8 a. Which exponential smoothing model provides better forecasts, one using a = .6 or a = .2? Compare them using mean squared error. b. Using the two forecast models in part (a), what are the forecasts for week 9? Hi,...
Freight car loadings over an 18-week period at a busy port are as follows: Week Number...
Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week Number Week Number 1 360 7 430 13 505 2 375 8 450 14 515 3 390 9 470 15 545 4 375 10 455 16 560 5 390 11 475 17 575 6 400 12 495 18 590 a. Determine a linear trend line for expected freight car loadings. YˆY^ =  +  t b. Use the above trend equation to predict expected loadings for...
Freight car loadings over an 18-week period at a busy port are as follows: Week Number...
Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week Number Week Number 1 370 7 415 13 450 2 380 8 425 14 455 3 390 9 435 15 475 4 380 10 425 16 485 5 390 11 435 17 495 6 395 12 445 18 505 a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) YˆY^ =  +  t...
Freight car loadings over an 18-week period at a busy port are as follows: Week Number...
Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week Number Week Number 1 290 7 335 13 490 2 300 8 375 14 495 3 310 9 415 15 515 4 300 10 405 16 525 5 310 11 445 17 535 6 315 12 485 18 545 a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) YˆY^ =  +  t...
1.Assume you collected a quarterly sales data (in millions of dollars) over a four-year period from...
1.Assume you collected a quarterly sales data (in millions of dollars) over a four-year period from the first quarter 2016 to the fourth quarter 2019, and computed the seasonal index for each quarter. If the values of the actual sales and deseasonalised sales were 162 and 158.68, respectively, in the second quarter of 2016, what is the (normalised) seasonal index for the second quarter? Round your answer to two decimal places. 2. Assume you collected data representing the number of...
Which one of the following statements is not correct? A. Over a week-long period, if a...
Which one of the following statements is not correct? A. Over a week-long period, if a healthy person were to ingest 35 g of NaCl, the total amount of NaCl excreted in the urine would be less than 35 g. B. In the proximal tubule, large amounts of Na+ and water are reabsorbed but the concentration of Na+ in the proximal tubular fluid does not change. C. A drug that inhibits active NaCl reabsorption in the ascending limb of the...
Freight car loadings over an 18-week period at a busy port are as follows:
  Freight car loadings over an 18-week period at a busy port are as follows: Week Tons loaded 1 220 2 245 3 280 4 275 5 300 6 310 7 350 8 360 9 400 10 380 11 420 12 450 13 460 14 475 15 500 16 510 17 525 18 541 The port manager wants build a model to forecast the loads for the remainder of the year. a. Which variable is the dependent/response variable? b. Which...
The number of times a machine broke down each week was observed over a period of...
The number of times a machine broke down each week was observed over a period of 100 weeks and recorded as shown in the table below. Complete parts a and b below. Number of Breakdowns 0 1 2 3 4 5 or More Number of weeks 9 22 32 26 6 5 a. Using alphaequals?0.10, perform a? chi-square test to determine if the population distribution of breakdowns follows the Poisson probability distribution. What is the null? hypothesis, Upper H 0??...
“Fourth quarter U.S. online sales grew 26.2 percent as compared to the same period in the...
“Fourth quarter U.S. online sales grew 26.2 percent as compared to the same period in the previous year. Full year results show U.S. online sales year-over-year growth was 32.2%. Overall, full year total company sales, including both online and store sales, increased 9.5% year-over-year.” Which of the following would NOT explain what this is about? a. The data in the news release was computed using horizontal analysis based in the income statement. b. Total sales reported indicate year-over-year growth. c....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT