Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Exercises In Computational Mathematics With MATLAB

Authors: Tom Lyche, Jean Louis Merrien

1st Edition

366243511X, 9783662435113

More Books

Students also viewed these Mathematics questions

Question

2. How do I perform this role?

Answered: 1 week ago