Question
This data shows the number of employee injuries reported in the first 25 days after a new device training session in each of the 10
This data shows the number of employee injuries reported in the first 25 days after a new device training session in each of the 10 production Plants of a certain company across the world.
a) Report the average, standard deviation and variance for injury level at each plant in rows 28, 29 and 30 of each column using proper excel functions under each column
b) Assuming significance level of 0.05, is there any significant difference in the injuries reported between these 10 Plants?
(use Single factor ANOVA)
c) The manager is particularly concerned about the results from Plant 1 compared to plant 8. Is there evidence that the injury level at Plant 1 is significantly higher from that of Plant 8? (use t-Test: Two-Sample Assuming Unequal Variances)
d) How will the manager know if the results of Plant 1 is significantly different from the other plants? Please explain. (Do not need to run the test, only explain what you would do to find out if there was any difference or not in full details.)
Please provide statistical evidence for your answers. (Use proper test methods and report the results of the tests except for part "d" where you only need to explain your method)
DO NOT FORGET TO WRITE THE NULL AND ALTERNATIVE HYPOTHESIS WHEN APPLICABLE. DO NOT FORGET TO INTERPRET THE RESULTS YOU GET FROM EXCEL.
TEST RESULTS WITHOUT INTERPRETATION IS ABSOLUTELY INCOMPLETE.
MAKE A CONCLUSIONS WHICH MUST BE WRITTEN IN PLAIN LANGUAGE TO THE GENERAL PUBLIC (UNDERSTANDABLE TO A MIDDLE SCHOOL GRADE STUDENT)
day number | Plant 1 | Plant 2 | Plant 3 | Plant 4 | Plant 5 | Plant 6 | Plant 7 | Plant 8 | Plant 9 | Plant 10 |
1 | 5 | 1 | 5 | 4 | 1 | 4 | 3 | 1 | 3 | 4 |
2 | 3 | 4 | 4 | 3 | 4 | 5 | 2 | 2 | 5 | 5 |
3 | 5 | 5 | 5 | 3 | 2 | 7 | 4 | 3 | 3 | 5 |
4 | 3 | 4 | 4 | 4 | 4 | 5 | 5 | 1 | 5 | 5 |
5 | 3 | 2 | 4 | 3 | 6 | 3 | 3 | 4 | 4 | 5 |
6 | 2 | 4 | 3 | 4 | 3 | 4 | 5 | 1 | 4 | 5 |
7 | 5 | 1 | 5 | 3 | 5 | 4 | 4 | 3 | 4 | 4 |
8 | 3 | 3 | 1 | 5 | 4 | 5 | 3 | 3 | 5 | 1 |
9 | 4 | 5 | 2 | 5 | 2 | 4 | 5 | 4 | 6 | 1 |
10 | 5 | 3 | 5 | 5 | 3 | 7 | 3 | 3 | 3 | 2 |
11 | 8 | 5 | 3 | 5 | 5 | 5 | 4 | 2 | 1 | 4 |
12 | 5 | 4 | 3 | 5 | 3 | 4 | 5 | 4 | 5 | 1 |
13 | 4 | 2 | 4 | 5 | 5 | 3 | 3 | 4 | 4 | 3 |
14 | 8 | 4 | 2 | 5 | 4 | 3 | 2 | 2 | 3 | 2 |
15 | 1 | 1 | 2 | 4 | 7 | 5 | 2 | 3 | 3 | 2 |
16 | 3 | 3 | 4 | 3 | 3 | 4 | 1 | 4 | 5 | 5 |
17 | 4 | 2 | 1 | 3 | 5 | 7 | 3 | 5 | 4 | 3 |
18 | 3 | 3 | 3 | 4 | 2 | 6 | 2 | 1 | 3 | 5 |
19 | 2 | 5 | 3 | 3 | 1 | 5 | 4 | 4 | 2 | 3 |
20 | 5 | 4 | 4 | 5 | 2 | 3 | 5 | 3 | 4 | 4 |
21 | 5 | 5 | 5 | 4 | 1 | 5 | 5 | 4 | 4 | 5 |
22 | 2 | 4 | 3 | 3 | 3 | 5 | 5 | 3 | 5 | 4 |
23 | 5 | 5 | 1 | 3 | 4 | 6 | 5 | 4 | 4 | 5 |
24 | 1 | 3 | 2 | 4 | 6 | 9 | 5 | 3 | 1 | 3 |
25 | 9 | 1 | 1 | 2 | 3 | 7 | 5 | 4 | 4 | 4 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started