Question:

You are in charge of conducting an analysis for your organization to determine if there is a difference in product sales between the day shift, the night shift, and the weekend shift. Your coworker has already collected the data and it is ready for you to analyze.

Review the data your coworker collected in the Analysis of ANOVA Test Data Spreadsheet.

First, plan your analysis. Second, conduct your analysis. Third, describe your analysis.

Part 1: Planning

• What are the null and alternative hypotheses?
• Where did you obtain your data or who obtained it for you?

Part 2: Analysis

• What are the descriptive statistics for your sample? Include:
• Sample size
• Mean
• Median
• Mode
• Standard deviation
• Analysis Procedures: What did you do to conduct your analysis?

Part 3: Results and Discussion

• What are the test statistics and results? Include
• f statistic
• p-value
• What are the results? Are the results inferable to the population?
• Do you reject or fail to reject the null hypothesis? Explain.
• What do the results mean? What is your recommendation to the organization?

Submit your assignment.

Participant ID	Shift	Total Sales
1	Day	$ 599
2	Day	$ 233
3	Day	$ 605
4	Day	$ 222
5	Day	$ 1,100
6	Day	$ 855
7	Day	$ 344
8	Day	$ 333
9	Day	$ 222
10	Day	$ 567
11	Day	$ 850
12	Day	$ 888
13	Day	$ 200
14	Day	$ 566
15	Day	$ 335
16	Day	$ 643
17	Day	$ 344
18	Day	$ 456
19	Day	$ 124
20	Day	$ 125
21	Day	$ 742
22	Day	$ 112
23	Day	$ 322
24	Day	$ 1,224
25	Day	$ 112
26	Day	$ 70
27	Day	$ 233
28	Day	$ 783
29	Day	$ 634
30	Day	$ 233
31	Day	$ 732
32	Day	$ 666
33	Day	$ 233
34	Night	$ 9,060
35	Night	$ 5,604
36	Night	$ 5,663
37	Night	$ 223
38	Night	$ 6,334
39	Night	$ 7,885
40	Night	$ 3,442
41	Night	$ 2,245
42	Night	$ 3,448
43	Night	$ 223
44	Night	$ 6,678
45	Night	$ 4,556
46	Night	$ 344
47	Night	$ 988
48	Night	$ 907
49	Night	$ 6,663
50	Night	$ 113
51	Night	$ 4,556
52	Night	$ 2,567
53	Night	$ 8,954
54	Night	$ 3,463
55	Night	$ 5,366
56	Night	$ 2,332
57	Night	$ 3,234
58	Night	$ 1,222
59	Night	$ 1,211
60	Night	$ 1,222
61	Night	$ 1,441
62	Night	$ 3,744
63	Night	$ 7,447
64	Night	$ 3,473
65	Night	$ 6,733
66	Night	$ 7,452
67	Weekend	$ 9,402
68	Weekend	$ 8,925
69	Weekend	$ 8,034
70	Weekend	$ 8,968
71	Weekend	$ 9,246
72	Weekend	$ 6,902
73	Weekend	$ 8,401
74	Weekend	$ 7,028
75	Weekend	$ 9,684
76	Weekend	$ 8,726
77	Weekend	$ 7,833
78	Weekend	$ 7,843
79	Weekend	$ 9,845
80	Weekend	$ 8,262
81	Weekend	$ 8,523
82	Weekend	$ 9,367
83	Weekend	$ 2,357
84	Weekend	$ 9,070
85	Weekend	$ 9,783
86	Weekend	$ 9,683
87	Weekend	$ 10,311
88	Weekend	$ 9,481
89	Weekend	$ 10,525
90	Weekend	$ 9,852
91	Weekend	$ 9,026
92	Weekend	$ 8,362
93	Weekend	$ 8,727
94	Weekend	$ 8,792
95	Weekend	$ 9,573
96	Weekend	$ 8,673
97	Weekend	$ 7,847
98	Weekend	$ 9,758
99	Weekend	$ 8,953