Fluent Essays

ARE 112 – Winter 2021 Analysis Project - Instructions Due on Canvas Saturday February 27th 1 of 2 What you need to do (just recommending) : 1 1. Look at the prior reports in the 2 Files/Assignment link on Canvas to get an idea of 3 where you want to end up. 4 2. Watch the video on Canvas – will be posed to 5 the Assignment/Analysis folder - to see how it is 6 done. The objective of this assignment is not to 7 learn statistics but to see how statistics – 8 quantitative tools – can assist a manager in 9 making decisions. You may find it useful to 10 make notes on this this handout as you watch the 11 video. 12 Link – to be upload later this week title “#A Analysis Project Video” in the Pages folder 13 14 3. Download the Excel file found on Canvas and emailed with this handout. Here are screen shots 15 This is for chi-square 16 17 18 Employee _Ref Promoted Management Training Program 1 No No 2 Yes Yes 9 Yes Yes 140 No No Here is where the HIDE command was used 148 Yes Yes 149 No No 150 No Yes Formula # Promoted Training Program Formula Yes 80 No 70 p-value = Total 150 # Promoted Training Program Yes No Total =COUNTIF(c2:c151,$B$153) In Per Cent Chi square test with Excel formula =CHISQ.TEST(C154:C155,D154:D155) We are testing the idea that Promotion = function (Going to the training program). ARE 112 – Winter 2021 Analysis Project - Instructions Due on Canvas Saturday February 27th 2 of 2 This is for ANOVA – single factor 1 2 3 4. Perform the chi square and ANOVA test - you may want to take a few notes watching the video. 4 5. Copy and paste the output to a document. 5 6. Do a simple write of why the test was done and what you found - can be done in one-page write up. 6 When writing up statistical results we want to keep it short and simple because you will be communicating to 7 an audience that may appreciate statistical results, they may not like statistics. 8 7. Put your name on the write up, use wrap text (in the video), prefer no color, upload in pdf or doc or docx 9 formats, no google docs. 10 8. Grading is 5 points for results and 5 points for write up and format - 12 point font and wrap text. Difficult 11 not to get full credit 12Chi_Sq_DATA Employee_Ref Promoted Management Training Program 1 No No 2 Yes Yes 3 No No 4 Yes Yes 5 No No 6 No No 7 Yes Yes 8 Yes Yes 9 Yes Yes 10 Yes Yes 11 No No 12 No No 13 Yes Yes 14 No No 15 Yes No 16 Yes Yes 17 No Yes 18 Yes Yes 19 Yes Yes 20 Yes Yes 21 Yes Yes 22 Yes Yes 23 No No 24 Yes Yes 25 No No 26 Yes Yes 27 No No 28 Yes Yes 29 Yes Yes 30 No No 31 No No 32 Yes Yes 33 Yes Yes 34 No No 35 Yes Yes 36 No No 37 Yes Yes 38 No No 39 Yes Yes 40 No No 41 No No 42 Yes Yes 43 Yes Yes 44 Yes Yes 45 Yes Yes 46 Yes No 47 Yes No 48 No No 49 Yes No 50 Yes Yes 51 Yes Yes 52 Yes Yes 53 Yes Yes 54 Yes Yes 55 No No 56 Yes Yes 57 Yes No 58 Yes Yes 59 No No 60 No No 61 Yes Yes 62 Yes Yes 63 Yes Yes 64 Yes Yes 65 No No 66 Yes Yes 67 No No 68 No No 69 No No 70 No No 71 No No 72 No No 73 Yes Yes 74 No Yes 75 No No 76 No No 77 No No 78 Yes Yes 79 No Yes 80 Yes Yes 81 Yes Yes 82 No Yes 83 No No 84 No No 85 No No 86 No No 87 No No 88 No No 89 No No 90 Yes Yes 91 No No 92 Yes Yes 93 No Yes 94 Yes Yes 95 Yes No 96 Yes Yes 97 Yes Yes 98 Yes Yes 99 No No 100 No No 101 No No 102 Yes Yes 103 Yes Yes 104 Yes Yes 105 Yes Yes 106 Yes Yes 107 Yes Yes 108 Yes Yes 109 No No 110 Yes Yes 111 No No 112 Yes Yes 113 No No 114 Yes Yes 115 Yes No 116 No No 117 Yes Yes 118 No No 119 No No 120 Yes Yes 121 No No 122 Yes No 123 Yes Yes 124 No No 125 Yes Yes 126 No No 127 Yes Yes 128 Yes Yes 129 Yes Yes 130 Yes Yes 131 Yes No 132 No No 133 Yes Yes 134 Yes Yes 135 No No 136 Yes Yes 137 Yes Yes 138 Yes Yes 139 No No 140 No No Here is where the HIDE command was used 141 No No 142 No No 143 No No 144 No No 145 Yes Yes 146 No No We are testing the idea that Promotion = function (Going to the training program). 147 Yes Yes 148 Yes Yes =CHISQ.TEST(actual_range, expected_range) 149 No No 150 No Yes Chi square test with Excel formula Formula =COUNTIF(c2:c151,$B$153) # Promoted Training Program Formula =CHISQ.TEST(C154:C155,D154:D155) Yes 83 No 67 p-value = Total 150 0 In Per Cent # Promoted Training Program Yes 55.3\% No 44.7\% Total 100\% ARE112 - Winter 2021 #A Analysis Project - Chi Square ANOVA_DATA Item # Week Code Satisfaction Level Office Code Office 1 Week1 38 1 Boston Week # Boston Atlanta San Diego Seattle 2 Week2 40 1 Boston 1 38 42 44 31 3 Week3 30 1 Boston 2 40 45 43 43 4 Week4 42 1 Boston 3 30 44 40 44 5 Week5 36 1 Boston 4 42 43 40 43 6 Week6 41 1 Boston 5 36 46 37 36 7 Week7 40 1 Boston 6 41 42 35 43 8 Week8 42 1 Boston 7 40 37 37 46 9 Week9 36 1 Boston