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.
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?
AutoSave OFF " AFSC ... mth218_v4_wk4_analysis_of_anova_test_data_spreadsheet Share Comments Home Insert Draw Page Layout Formulas Data Review View Acrobat ? Tell me do v Conditional Formatting Insert 2 Calibri (Body) AA General Format as Table Delete v V V Sort & Find & Analyze Sensitivity Create and Share A $ v % 9 Cell Styles v Format Qv Filter Select Data Adobe PDF Paste BI Uv F2 X V fx P Q R B C D E F G H K L M N O A 1 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 10 9 Day 222 11 10 Day 567 12 11 Day 350 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 D Sheet1 - + 142% EnterAutoSave."FF Q E] F) 9 v a th218_v4_wk4_analysis_of_anova_test_data_spreadsheet Home Insert Draw Page Layout Formulas Data Review View Acrobat i5 Share D Comments 1 V ' Calibri (Body) LE [av Paste B 1' U V Create and Share 7 Adobe PDF 30 Day $ 233 31 Day 5 732 32 Day 5 666 33 Day 5 233 34 Night 5 9,060 35 Night 5 5,604 36 Night 5 5,663 37 Night $ 223 38 Night 5 6,334 39 Night 5 7,885 40 Night 5 3,442 41 Night 5 2,245 42 Night 5 3,448 43 Night 5 223 44 Night 3 6,678 45 Night 5 4,556 46 Night 5 344 47 Night $ 988 48 Night 3 907 49 Night 5 6,663 50 Night 5 113 51 Night 3 4,556 52 Night $ 2,567 53 Night 3 8,954 54 Night 5 3,463 55 Night 3 5,366 56 Night 5 2,332 57 Night 5 3,234 58 Night 5 1,222 $ 1,211 59 Night AutoSave."FF Q E] F) 9 v a th218_v4_wk4_analysis_of_anova_test_data_spreadsheet Home Insert Draw Page Layout Formulas Data Review View Acrobat t5 Share D Comments 1 V ' Calibri (Body) LE [av Paste B I U V Create and Share 7 Adobe PDF 59 Night 5 60 Night 5 1,222 61 Night $ 1,441 62 Night 5 3,744 63 Night 5 7,447 64 Night $ 3,473 65 Night $ 6,733 66 Night 5 7,452 67 Weekend 5 9,402 68 Weekend 5 8,925 69 Weekend 5 8,034 70 Weekend 5 8,968 71 Weekend 5 9,246 72 Weekend $ 6,902 73 Weekend $ 8,401 74 Weekend 5 7,028 75 Weekend 5 9,684 76 Weekend 5 8,726 77 Weekend 5 7,833 78 Weekend 5 7,843 79 Weekend 5 9,845 80 Weekend $ 8,262 81 Weekend 5 8,523 82 Weekend 5 9,367 83 Weekend 5 2,357 84 Weekend 5 9,070 85 Weekend 5 9,783 86 Weekend 5 9,683 87 Weekend $ 10,311 88 Weekend 5 9,481 89 Weekend 5 AutoSave OFF " AFSC ... mth218_v4_wk4_analysis_of_anova_test_data_spreadsheet Home Insert Draw Page Layout Formulas Data Review View Acrobat ? Tell me Share Comments AA do v Calibri (Body) 2 11 General Conditional Formatting Insert Format as Table v Delete v V V Create and Share Paste BI Uv A $ % 9 Sort & Find & Analyze Sensitivity Cell Styles v Format Qv Filter Select Data Adobe PDF E95 x v fx A B C D E F G H K L M N O P Q R 89 88 Weekend $ 9,481 90 89 Weekend 10,525 91 90 Weekend 9,852 92 91 Weekend 9,026 93 92 Weekend 8,362 94 93 Weekend 8,727 95 94 Weekend 8,792 96 95 Weekend 9,573 97 96 Weekend 8,673 98 7 Weekend 7,847 99 98 Weekend 9,758 100 99 Weekend 8,953 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 Sheet1 + Edit + 142%
