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?

78 Weekend 79 Weekend 80 Weekend 81 Weekend 82 Weekend 83 Weekend 84 Weekend 85 Weekend 86 Weekend 87 Weekend 88 Weekend 89 Weekend 90 Weekend 91 Weekend 92 Weekend 93 Weekend 94 Weekend 95 Weekend 96 Weekend 97 Weekend 98 Weekend 99 Weekend mmmmmmmmmmmmmmmmmmmmmm 2:047 . LTE Safari mth218_v4_wk4_analysis_of_anova_test_data_spreadsheet.xIsx 1 AD Q . . . X Read Only - This is an older file format. Changes can only be saved to a copy of the... More fx Total Sales A B C D E F G Participant ID Shift Total Sales 2 1 Day $ 599 3 2 Day 233 4 3 Day 605 5 4 Day 222 6 5 Day 1,100 6 Day 855 8 7 Day 344 9 8 Day 333 10 9 Day 222 11 10 Day 567 12 11 Day 850 13 12 Day 888 14 13 Day 200 15 14 Day 566 16 15 Day 335 17 16 Day 643 18 17 Day 344 19 18 Day 456 20 19 Day 124 21 20 Day 125 22 21 Day 742 23 22 Day 112 24 23 Day 322 25 24 Day 1,224 26 25 Day 112 27 26 Day 70 28 27 Day 233 29 28 Day 783 30 29 Day 634 31 30 Day 233 32 31 Day 732 33 32 Day 666 34 33 Day 233 35 34 Night 9,060 36 35 Night 5,604 37 36 Night 5,663 38 37 Night 223 39 38 Night 6,334 40 39 Night 7,885 41 40 Night ur 3,442 Sheet141 Night S 2,245 42 Night S 3,448 43 Night 3 223 44 Night S 6,578 45 Night $ 4,555 46 Night 5 344 47 Night 3 988 48 Night 5 907 49 Night S 6,663 50 Night 3 113 51 Night S 4,556 52 Night $ 2,567 53 Night 5 8,954 54 Night S 3,463 55 Night S 5,366 56 Night S 2,332 57 Night S 3,234 58 Night S 1,222 59 Night S 1,211 60 Night S 1,222 61 Night S 1,441 52 Night 5 3,744 63 Night S 7,447 54 Night S 3,473 55 Night S 5,733 66 Night S 7,452 67 Weekend S 9,402 68 Weekend S 8,925 69 Weekend S 8,034 70 Weekend S 8,968 a 71 Weekend S 9,246 72 Weekend S 6,902 73 Weekend S 8,401 74 Weekend S 7,028 75 Weekend S 9,684 76 Weekend $ 8,726 77 Weekend S 7,833 78 Weekend S 7,843 79 Weekend S 9,845 80 Weekend S 8,262 81 Weekend S 8,523 82 Weekend S 9,367 83 Weekend S 2,357 84 Weekend