Home Depot carries four major brands of power tools. The manager at the West Reno Home Depot would like to order the display of power tools by brand based on average sales. The brand with the highest average sales would be placed in the front of the aisle and the brand with the lowest average sales would be placed in the back of the aisle. The manager collects the average sales for 20 weeks ofthe four brands to determine if average sales differ by brand. Conduct the appropriate test.

Click here for the Excel data file

Rigid	Ryobi	Milwaukee	DeWalt
300.99	503.89	465.69	188.02
393.18	777.66	434.37	297.17
454.21	672.75	568.81	190.44
392.07	707.15	445.34	195.49
304.18	827.61	617.26	320.13
350.2	569.51	493.92	391.4
450.28	541.81	637.43	191.62
316.91	531.38	846.5	201.91
216.81	794.49	846.88	123.22
215.94	655.03	369.82	155.17
422.92	826.04	676.53	179.71
205.03	598.35	320.4	270.22
425.52	731.9	657.47	292.26
432.36	787.87	738.3	212.59
469	748.58	637.87	269.37
254.97	871.42	206.96	234.28
464.08	581.6	270.36	207.59
398.85	494.85	638.9	304.88
501.3	761.27	482.82	257.53
405.63	614.33	726.38	325.35

1. What are the values of the test statistic and p-value?(Round to 4decimal places)

Test statistic = _____?___

p-value = _____?______

1. What are the decision and conclusion to this test at the 5% significance level?

_____?___. ______?____. Therefore, we ____?______ conclude

__________________________?________________________

c.Should you run a comparison test? If yes, complete the confidence interval(round to 3decimal places)and determine if the differences are significant at the 5% significance level. If no, enter zeros for the confidence interval and select N/A in the drop-down menu.

95% Confidence Interval

Difference Lower Limit | Upper Limit | Significant at 5%

Rigid - Ryobi ? ? ?

Rigid - Milwaukee ? ? ?

Rigid - DeWalt ? ? ?

Ryobi - Milwaukee ? ? ?

Ryobi - DeWalt ? ? ?

Milwaukee - DeWalt ? ? ?