EmployeeID	Training Group	(PPE) Safety Violations	Safety Knowledge	Feelings of Acceptance
EM324	New Onboarding	2.4	3.2	3.7
EM325	New Onboarding	2.5	4.1	3.2
EM326	New Onboarding	2.2	3.8	3.2
EM327	New Onboarding	2.6	4.1	4.0
EM328	New Onboarding	1.0	3.0	3.5
EM329	New Onboarding	2.6	2.6	3.4
EM330	New Onboarding	1.3	2.7	2.5
EM331	New Onboarding	1.6	4.9	3.1
EM332	New Onboarding	2.7	3.4	3.5
EM333	New Onboarding	3.2	5.3	3.9
EM334	New Onboarding	2.1	3.3	3.8
EM335	New Onboarding	2.0	3.9	3.4
EM336	New Onboarding	2.9	4.1	4.1
EM337	New Onboarding	2.0	3.1	3.2
EM338	New Onboarding	2.4	2.7	3.7
EM339	New Onboarding	2.8	4.2	3.8
EM340	New Onboarding	2.3	4.2	3.6
EM341	New Onboarding	2.0	3.8	3.5
EM342	New Onboarding	3.3	3.6	3.3
EM343	New Onboarding	1.8	3.1	3.0
EM344	New Onboarding	2.3	2.2	3.5
EM345	New Onboarding	2.2	2.5	4.0
EM346	New Onboarding	1.8	3.4	3.1
EM347	New Onboarding	2.4	4.2	3.9
EM348	New Onboarding	2.9	4.5	4.4
EM349	New Onboarding	2.8	4.1	3.4
EM350	New Onboarding	1.6	3.5	3.7
EM351	New Onboarding	2.8	3.0	3.3
EM352	New Onboarding	1.3	2.7	3.5
EM353	New Onboarding	2.6	5.3	3.7
EM354	New Onboarding	2.5	4.2	3.6
EM355	New Onboarding	2.6	3.7	4.2
EM356	New Onboarding	1.3	3.9	3.7
EM357	New Onboarding	2.4	3.1	4.0
EM358	New Onboarding	2.0	4.5	3.6
EM359	New Onboarding	1.3	4.2	4.1
EM360	New Onboarding	3.2	3.5	3.3
EM361	New Onboarding	2.8	2.7	4.1
EM362	New Onboarding	2.9	2.3	3.2
EM363	New Onboarding	2.5	4.4	4.7
EM364	New Onboarding	2.3	2.2	3.8
EM365	New Onboarding	2.8	3.4	2.9
EM366	New Onboarding	2.8	3.6	4.1
EM367	New Onboarding	2.1	2.7	3.8
EM368	New Onboarding	3.3	3.4	3.7
EM369	New Onboarding	1.8	3.2	3.9
EM370	New Onboarding	1.8	3.7	3.4
EM371	New Onboarding	2.5	2.8	3.3
EM372	New Onboarding	2.7	1.7	3.8
EM373	New Onboarding	3.7	1.0	3.3
EM374	Current Practice	2.5	3.2	3.5
EM375	Current Practice	4.1	4.1	3.5
EM376	Current Practice	3.1	2.9	4.3
EM377	Current Practice	2.2	1.7	3.9
EM378	Current Practice	3.1	1.7	3.7
EM379	Current Practice	3.2	3.0	4.4
EM380	Current Practice	3.9	2.1	3.9
EM381	Current Practice	3.2	3.2	4.3
EM382	Current Practice	3.3	2.7	3.4
EM383	Current Practice	2.6	3.6	3.5
EM384	Current Practice	3.0	2.6	3.3
EM385	Current Practice	3.6	4.1	2.9
EM386	Current Practice	2.2	4.3	4.2
EM387	Current Practice	2.5	4.1	4.0
EM388	Current Practice	4.1	2.8	4.8
EM389	Current Practice	3.4	2.7	3.3
EM390	Current Practice	3.1	3.4	3.6
EM391	Current Practice	2.7	3.5	3.5
EM392	Current Practice	2.9	3.1	3.4
EM393	Current Practice	3.2	4.5	3.6
EM394	Current Practice	2.8	2.8	3.6
EM395	Current Practice	3.5	3.1	4.2
EM396	Current Practice	3.5	2.8	3.9
EM397	Current Practice	3.5	2.6	3.9
EM398	Current Practice	3.5	1.9	4.0
EM399	Current Practice	3.1	3.4	3.7
EM400	Current Practice	3.0	2.7	3.1
EM401	Current Practice	3.8	2.5	4.6
EM402	Current Practice	3.0	3.4	3.3
EM403	Current Practice	3.3	3.9	3.5
EM404	Current Practice	3.7	3.6	3.2
EM405	Current Practice	3.7	3.0	3.3
EM406	Current Practice	3.2	3.5	3.5
EM407	Current Practice	2.9	2.6	3.8
EM408	Current Practice	2.6	2.8	3.6
EM409	Current Practice	3.1	4.6	3.8
EM410	Current Practice	4.1	3.8	4.1
EM411	Current Practice	2.8	3.1	2.9
EM412	Current Practice	3.2	2.6	4.2
EM413	Current Practice	3.1	2.0	3.7
EM414	Current Practice	4.3	2.0	4.1
EM415	Current Practice	2.6	2.7	3.5
EM416	Current Practice	3.0	3.7	3.5
EM417	Current Practice	3.3	1.9	3.1
EM418	Current Practice	2.4	4.4	3.9
EM419	Current Practice	2.4	2.7	3.8
EM420	Current Practice	2.5	3.7	3.3
EM421	Current Practice	2.6	2.5	3.2
EM422	Current Practice	3.2	3.3	3.1
EM423	Current Practice	4.6	3.8	3.3

An organization would like to evaluate a new onboarding program. To do so, new employees are randomly assigned to either receive the new onboarding training program or go through the existing onboarding training program. A posttest-only, with control group design in use, and the posttest outcomes include measures of Safety Violations, Safety Knowledge, and Feelings of Acceptance, which are administered 6 months after all new employees joined the organization. Higher scores on each of those measures indicate higher levels of the concept. Using data found in the Activity Data sheet of the Excel workbook, do and respond to the following: 1. Create a pivot table and chart that displays compares the two training groups on all three post test outcomes. Be sure to also create a proper title and customize the chart so that is would be presentable to stakeholders. Remember, to change the values in the pivot table from sum to average. 2. Run three independent-samples t tests in which you compare the average levels of safety violations, safety knowledge, and feelings of acceptance for those who participated in the new onboarding program (New Onboarding) and those who completed the existing onboarding program (Current Practice). What did you find Report the means, t -test, and p value for each comparison? Then describe your interpretation of the findings? 3. Based on these analyses, what is the overall impression of the organizations new onboarding program, was it effective? explain assuming the program costs are similar 4. Thinking about the 4 criteria for training evaluation (reactions, knowledge, behaviors, results), which criteria were evaluated, and what additional outcomes could we measure to be able to evaluate each of the four training outcome categories?

please answer all parts with step by step excel work