Video A Deloitte employment survey asked a sample of human resource executives how their company planned to change its workforce over the next 12 months. A categ company plans to hire and add to the number of employees, the company plans no change in the number of employees, or the company plans to lay off and reduce variable indicated if the company was private or public, Sample data for 180 companies are contained in the Excel Online file below. Construct a spreadsheet to ans x Open spreadsheet a. Conduct a test of independence to determine if the employment plan for the next 12 months is independent of the type of company. At a .05 level of significance Compute the value of the x test statistic (to 2 decimals). The p-value is (to 4 decimals). What is your conclusion? the employment plan is not independent of the type of company. b. Discuss any differences in the employment plans for private and public companies over the next 12 months. companies are more likely to add employees. companies are more likely to have no change in their number of employees. companies are more likely to lay off employees. % (to 2 decimals) of private companies plan on adding employees. % (to 2 decimals) of public companies plan on laying off employees. D F G H Formula Parta Observed Frequency Table Company Private Public Company Public Total #NA #NA Plan Add No Change Lay Off Total 0 0 0 #N/A #N/A #N/A LayOff Plan Private Add No Change Lay Off Total =SUM(G4G6) 1 2. 3 4 5 6 7 8 9 10 11 #NA =SUM(H4 H6) 0 0 0 Expected Frequency Table Company Private Public Company Public Total Private #N/A #NA #NIA Plan Add No Change Lay Off Total 0 0 0 0 Plan Add No Change Lay Off Total =SUM(G11:G13) #N/A #NA A B Rospondent Plan 1 LayOff 2. Add 3 LayOff 4 5 Add 6 NoChange 7 Add 8 NoChange 9 Add 10 LayOff 11 LayOff 12 Add 13 Lay Off 14 LayOff 15 Add 16 NoChange 17 LayOff 18 Add 19 NoChange 20 21 LayOff 22 Lay Off 23 Add 24 Add 25 NoChange 26 Add #N/A =SUM(H11:13) 0 0 Company Public Public Public Public Private Public Public Private Public Public Public Public Public Public Private Public Private Public Public Private Public Private Public Public Public Private #N/A p-value (to 4 decimals) Number of Rows 3 Number of Columns 2 Layoff #N/A Degrees of Freedom #N/A Agasaga Sa Chi Square Test Statistic (to 2 decimals) Level of Significance (Alpha) 0.05 #N/A Reject Null Hypothesis? (Enter "Reject" or "Do not reject") 29 Company Public Company Public Part b Column Probabilities Table Private #NA 27 28 29 30 31 32 33 34 Add Add Lay Off NoChange LayOff NoChange Add Add Private Public Public Public Public Public Public Public Plan Private Add No Change Lay OF Plan Add No Change Lay Off 32 #N/A #N/A #N/A #NA #N/A Percentage of private companies planning to add employees (to 2 decimals #N/A 36 37 35 36 NoChange Lay Off Public Public #N/A Percentage of public companies planning to lay off employees (to 2 decimals) 38 39 40 41 42 43 44 45 46 47 48 49 50 51 53 86 S 688 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 Add NoChange LayOff NoChange NoChange Lay Off Add Add NoChange Add NoChange NoChange LayOff Add NoChange Public Public Public Private Public Public Private Private Public Public Public Private Public Private Private 1 A N98 F G D 1 H K 8 51 52 53 se SS SE 57 S8 59 Add NoChange Add Add NoChange Add Private Private Public Public Public Private SO 51 52 53 S4 SS 56 57 58 59 60 61 Layoff Private 61 63 65 GE 67 58 TO TT 2 5 2 ES EE 17 51 2 s 4 5 6 7 8 9 0 1 2 3 4 5 3 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 TOS Add Public NoChange Private Layon Public Add Public Add Public NoChange Private NoChange Public LayOff Private Add Private LayOf Public LayOff Public Add Private Add Public NoChange Public Layo Public NoChange Public NoChange Public NoChange Public NoChange Public Layoff Public NoChange Public Layoff Public Add Private Add Public Layoff Private Add Public Layoff Public Layon Private Layo Public Add Public Add Public LayOff Public LayOff Private Layon Public NoChange Public Add Private Add Public NoChange Public Add Public Layoff Private NoChange Public NoChange Private NoChange Public NoChange Public NoChange Public LayOfT Public Add NoChange Public NoChange Private 2 0 1 2 3 4 > Prnale 759 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 B TYOUTange Add NoChange Add Layoff Layoff Add Add Add Add Add LayOff Layoff Layoff NoChange Add LayOff Add LayOff Add Add NoChange PUOLIC Private Public Private Public Public Private Public Private Public Public Public Private Private Public Public Private Public Public Public Private Private UU 106 107 108 109 110 111 112 113 114 115 116 118 7:19 120 121 122 124 125 126 1271 128 29 130 5:31 132 133 134 135 336 137 136 139 1:40 141 42 143 144 145 146 147 148 149 150 151 152 153 154 TV 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 13a 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 B TOOnung NoChange Private LayOff Private Add Private NoChange Public NoChange Public NoChange Public Add Public Add Private Add Public LayOff Private Add Private Layoff Private LayOF Public NoChange Private LayOff Public NoChange Private Layoff Public LayOff Public NoChange Public Add Private Add Private Add Private LayOff Public LayOff Public Add Private LayOff Public Add Public LayOf Public LayOff Public LayOff Public Layoff Public NoChange Private LayOfT Privale LayOff Public NoChange Public Layoff Public NoChange Public NoChange Public Add Private Add Private NoChange Private Add Public Add Private Layoff Public NoChange Private Add Private Add Private Layoff Private NoChange Privale Layoff Public NoChange Public LayOF Public Add Public Add Public NoChange Public Add Privale 156 157 158 159 160 161