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 categorical response variable showed three options: The company plans to hire and add to the number of employees, the company plans no change the number of employees, or the company plans to lay off and reduce the number of employees. Another categorical 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 answer the following questions. 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, what is your conclusion? Compute the value of the X² test statistic (to 2 decimals). 3.52 The p-value is 0.0089 What is your conclusion? Cannot conclude 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. Private companies are more likely to add employees. Public 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. Public 41.67 (to 4 decimals). 36.59
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 categorical response variable showed three options: The company plans to hire and add to the number of employees, the company plans no change the number of employees, or the company plans to lay off and reduce the number of employees. Another categorical 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 answer the following questions. 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, what is your conclusion? Compute the value of the X² test statistic (to 2 decimals). 3.52 The p-value is 0.0089 What is your conclusion? Cannot conclude 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. Private companies are more likely to add employees. Public 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. Public 41.67 (to 4 decimals). 36.59
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 10CYU
Related questions
Question
Data is given below. Please correct the wrong ones. i will upvote!
Respondent | Plan | Company |
1 | LayOff | Public |
2 | NoChange | Public |
3 | NoChange | Public |
4 | Add | Public |
5 | Add | Public |
6 | NoChange | Public |
7 | NoChange | Public |
8 | LayOff | Public |
9 | NoChange | Private |
10 | NoChange | Private |
11 | Add | Public |
12 | Add | Public |
13 | Add | Public |
14 | LayOff | Public |
15 | Add | Public |
16 | LayOff | Public |
17 | Add | Private |
18 | LayOff | Public |
19 | NoChange | Public |
20 | NoChange | Public |
21 | Add | Private |
22 | LayOff | Public |
23 | LayOff | Public |
24 | Add | Private |
25 | NoChange | Public |
26 | Add | Public |
27 | NoChange | Public |
28 | NoChange | Private |
29 | LayOff | Public |
30 | LayOff | Public |
31 | NoChange | Public |
32 | LayOff | Public |
33 | Add | Public |
34 | Add | Public |
35 | LayOff | Private |
36 | LayOff | Private |
37 | NoChange | Private |
38 | Add | Private |
39 | Add | Public |
40 | LayOff | Public |
41 | LayOff | Public |
42 | NoChange | Private |
43 | LayOff | Public |
44 | Add | Public |
45 | Add | Public |
46 | NoChange | Public |
47 | LayOff | Public |
48 | LayOff | Public |
49 | Add | Public |
50 | NoChange | Public |
51 | NoChange | Public |
52 | NoChange | Public |
53 | Add | Private |
54 | Add | Private |
55 | Add | Public |
56 | LayOff | Private |
57 | LayOff | Public |
58 | Add | Private |
59 | Add | Private |
60 | Add | Private |
61 | LayOff | Public |
62 | Add | Private |
63 | NoChange | Public |
64 | Add | Private |
65 | LayOff | Public |
66 | Add | Public |
67 | Add | Public |
68 | LayOff | Public |
69 | Add | Private |
70 | LayOff | Private |
71 | NoChange | Private |
72 | NoChange | Private |
73 | NoChange | Public |
74 | NoChange | Public |
75 | Add | Public |
76 | NoChange | Public |
77 | Add | Private |
78 | LayOff | Public |
79 | Add | Public |
80 | Add | Public |
81 | NoChange | Public |
82 | NoChange | Public |
83 | Add | Public |
84 | NoChange | Private |
85 | Add | Private |
86 | NoChange | Public |
87 | LayOff | Public |
88 | LayOff | Public |
89 | Add | Public |
90 | NoChange | Public |
91 | LayOff | Public |
92 | Add | Public |
93 | NoChange | Private |
94 | LayOff | Public |
95 | LayOff | Public |
96 | NoChange | Public |
97 | LayOff | Public |
98 | LayOff | Public |
99 | LayOff | Private |
100 | Add | Private |
101 | Add | Private |
102 | LayOff | Public |
103 | Add | Public |
104 | LayOff | Private |
105 | LayOff | Public |
106 | Add | Private |
107 | NoChange | Private |
108 | Add | Private |
109 | Add | Private |
110 | Add | Public |
111 | LayOff | Public |
112 | Add | Public |
113 | Add | Public |
114 | LayOff | Private |
115 | Add | Public |
116 | Add | Public |
117 | LayOff | Public |
118 | LayOff | Public |
119 | NoChange | Private |
120 | NoChange | Private |
121 | NoChange | Public |
122 | LayOff | Private |
123 | NoChange | Public |
124 | LayOff | Private |
125 | Add | Public |
126 | NoChange | Public |
127 | LayOff | Public |
128 | LayOff | Public |
129 | NoChange | Public |
130 | Add | Private |
131 | Add | Public |
132 | Add | Public |
133 | LayOff | Private |
134 | Add | Private |
135 | NoChange | Private |
136 | Add | Private |
137 | LayOff | Public |
138 | LayOff | Private |
139 | NoChange | Private |
140 | LayOff | Private |
141 | Add | Public |
142 | LayOff | Public |
143 | LayOff | Public |
144 | LayOff | Public |
145 | LayOff | Public |
146 | NoChange | Public |
147 | Add | Private |
148 | Add | Public |
149 | LayOff | Private |
150 | LayOff | Private |
151 | NoChange | Public |
152 | Add | Public |
153 | Add | Public |
154 | NoChange | Private |
155 | Add | Private |
156 | NoChange | Public |
157 | Add | Private |
158 | Add | Private |
159 | NoChange | Private |
160 | Add | Private |
161 | Add | Public |
162 | LayOff | Public |
163 | Add | Public |
164 | LayOff | Private |
165 | LayOff | Public |
166 | NoChange | Public |
167 | LayOff | Private |
168 | Add | Public |
169 | NoChange | Private |
170 | Add | Private |
171 | LayOff | Private |
172 | NoChange | Public |
173 | LayOff | Private |
174 | NoChange | Private |
175 | NoChange | Public |
176 | NoChange | Public |
177 | Add | Private |
178 | NoChange | Private |
179 | LayOff | Public |
180 | Add | Private |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 8 images
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt