1 Pre-Training Post-Training Scores ב ப 5 2 73.23 80.67 B 68.13 73.5 71.78 76.75 5 63.88 77.03 5 78.13 79.37 7 66.99 73 B 69.48 71.08 9 75.26 73.31 0 71.3 67.44 1 82.72 80.93 2 68.54 71.81 3 76.34 73.11 4 74.8 79.83 5 69.16 73.37 6 77.62 83.83 7 74.14 70.72 8 78.86 79.3 9 79.12 78.56 0 85.82 76.68 1 81.68 80.53 2 78.41 75.23 3 70.98 81.17 4 71.55 81.19 5 72.72 89.78 6 75.09 81.6 7 8
Please conduct a step by step of these statistical tests on separate sheets of Microsoft Excel. If the calculations in Microsoft Excel are incorrect, the null and alternative hypotheses, as well as the conclusions drawn from them, will be meaningless and will not receive any points
3. Paired T-Test: A company implemented a training program to improve employee performance. To evaluate the effectiveness of the program, the company recorded the test scores of 25 employees before and after the training. Determine if the training program is effective in terms of scores of participants before and after the training.
(Hints: The null can be about maintaining status-quo or no difference among groups; if alternative hypothesis is non-directional, use the two-tailed p-value from excel file to make a decision about rejecting or not rejecting the null)
H0 =
H1=
Conclusion:
Step by step
Solved in 2 steps with 4 images
