Data is given below. Please correct the wrong ones. i will upvote!RespondentPlanCompany1LayOffPublic2NoChangePublic3NoChangePublic4AddPublic5AddPublic6NoChangePublic7NoChangePublic8LayOffPublic9NoChangePrivate10NoChangePrivate11AddPublic12AddPublic13AddPublic14LayOffPublic15AddPublic16LayOffPublic17AddPrivate18LayOffPublic19NoChangePublic20NoChangePublic21AddPrivate22LayOffPublic23LayOffPublic24AddPrivate25NoChangePublic26AddPublic27NoChangePublic28NoChangePrivate29LayOffPublic30LayOffPublic31NoChangePublic32LayOffPublic33AddPublic34AddPublic35LayOffPrivate36LayOffPrivate37NoChangePrivate38AddPrivate39AddPublic40LayOffPublic41LayOffPublic42NoChangePrivate43LayOffPublic44AddPublic45AddPublic46NoChangePublic47LayOffPublic48LayOffPublic49AddPublic50NoChangePublic51NoChangePublic52NoChangePublic53AddPrivate54AddPrivate55AddPublic56LayOffPrivate57LayOffPublic58AddPrivate59AddPrivate60AddPrivate61LayOffPublic62AddPrivate63NoChangePublic64AddPrivate65LayOffPublic66AddPublic67AddPublic68LayOffPublic69AddPrivate70LayOffPrivate71NoChangePrivate72NoChangePrivate73NoChangePublic74NoChangePublic75AddPublic76NoChangePublic77AddPrivate78LayOffPublic79AddPublic80AddPublic81NoChangePublic82NoChangePublic83AddPublic84NoChangePrivate85AddPrivate86NoChangePublic87LayOffPublic88LayOffPublic89AddPublic90NoChangePublic91LayOffPublic92AddPublic93NoChangePrivate94LayOffPublic95LayOffPublic96NoChangePublic97LayOffPublic98LayOffPublic99LayOffPrivate100AddPrivate101AddPrivate102LayOffPublic103AddPublic104LayOffPrivate105LayOffPublic106AddPrivate107NoChangePrivate108AddPrivate109AddPrivate110AddPublic111LayOffPublic112AddPublic113AddPublic114LayOffPrivate115AddPublic116AddPublic117LayOffPublic118LayOffPublic119NoChangePrivate120NoChangePrivate121NoChangePublic122LayOffPrivate123NoChangePublic124LayOffPrivate125AddPublic126NoChangePublic127LayOffPublic128LayOffPublic129NoChangePublic130AddPrivate131AddPublic132AddPublic133LayOffPrivate134AddPrivate135NoChangePrivate136AddPrivate137LayOffPublic138LayOffPrivate139NoChangePrivate140LayOffPrivate141AddPublic142LayOffPublic143LayOffPublic144LayOffPublic145LayOffPublic146NoChangePublic147AddPrivate148AddPublic149LayOffPrivate150LayOffPrivate151NoChangePublic152AddPublic153AddPublic154NoChangePrivate155AddPrivate156NoChangePublic157AddPrivate158AddPrivate159NoChangePrivate160AddPrivate161AddPublic162LayOffPublic163AddPublic164LayOffPrivate165LayOffPublic166NoChangePublic167LayOffPrivate168AddPublic169NoChangePrivate170AddPrivate171LayOffPrivate172NoChangePublic173LayOffPrivate174NoChangePrivate175NoChangePublic176NoChangePublic177AddPrivate178NoChangePrivate179LayOffPublic180AddPrivate 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 responsevariable showed three options: The 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 tolay 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 ExcelOnline file below. Construct a spreadsheet to answer the following questions.XOpen spreadsheeta. 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 yourconclusion?Compute the value of the X² test statistic (to 2 decimals).3.52The p-value is 0.0089What is your conclusion?Cannot concludethe 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.PrivatePublicPublic ↑41.6736.59(to 4 decimals).% (to 2 decimals) of private companies plan on adding employees.% (to 2 decimals) of public companies plan on laying off employees.Check My WorkReset Problem

Question

Accepted Answer

AddLay offNo changeTotalPublic384233113Private30181967Total686052180

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