\"Objectives: 1. Collect data regarding ten different departments\' injury rates

Question

"Objectives: 1. Collect data regarding ten different departments' injury rates in a manufacturing in one year period of time. 2. Demonstrate descriptive analysis about the Departments 3. Draw conclusions regarding the listed Departments "

Procedure:
1. Fill in the project name, recorder name, department, and date.
2. List the Departments that need to be studied by the team
3. Record data systematically on a monthly basis using previous/ existing worksheets

Departments Months Descriptive Data Analysis Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Mean St. Dev. Max Min Range Lower Limit Upper Limit Department 1 12 22 20 23 24 26 27 26 19 18 17 14 Department 2 14 25 21 18 16 15 15 17 18 16 14 16 Department 3 12 20 18 16 15 17 14 18 16 22 24 25 Department 4 13 19 21 18 16 19 19 21 15 17 16 22 Department 5 16 23 17 21 24 26 21 16 12 17 18 19 Department 6 12 24 18 18 19 13 23 27 29 27 21 17 Department 7 15 19 18 11 17 18 16 21 22 25 15 12 Department 8 11 18 20 12 16 12 14 17 15 17 14 11 Department 9 17 18 12 12 13 15 16 17 12 18 15 21 Department 10 12 16 15 15 17 22 15 18 19 21 15 17 Total Mean St. Dev. Notes Max 1. Data set can be a column or a row Min 2. Upper and Lower limits are based Range on 30% tolerance. Lower Limit 3. Descriptive data analysis will be Upper Limit generated automatically. Analysis: What does the data tell us? 1. Occurrence of injury in each department during each month 2. Average number of injuries 3. Standard deviation of data set 4. Maximum value reached in the data set 5. Minimum value reached in the data set 6. Range values in a data set 7. Lower limit value based on the mean and the tolerance level 8. Upper limit value based on the mean and the tolerance level

Explanation / Answer

you can find the average, maximum and minimum,  range, standard deviaiton, lower and upper limits for each department in column wise

and for the yearwise you can find the above values in row wise statistics

partments Months Descriptive Data Analysis Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Mean St. Dev. Max Min Range Lower Limit Upper Limit Department 1 12 22 20 23 24 26 27 26 19 18 17 14 248 20.667 4.849 27 12 15 19.212 22.121 Department 2 14 25 21 18 16 15 15 17 18 16 14 16 205 17.083 3.175 25 14 11 16.131 18.036 Department 3 12 20 18 16 15 17 14 18 16 22 24 25 217 18.083 3.988 25 12 13 16.887 19.280 Department 4 13 19 21 18 16 19 19 21 15 17 16 22 216 18.000 2.697 22 13 9 17.191 18.809 Department 5 16 23 17 21 24 26 21 16 12 17 18 19 230 19.167 3.973 26 12 14 17.975 20.359 Department 6 12 24 18 18 19 13 23 27 29 27 21 17 248 20.667 5.483 29 12 17 19.022 22.311 Department 7 15 19 18 11 17 18 16 21 22 25 15 12 209 17.417 4.033 25 11 14 16.207 18.627 Department 8 11 18 20 12 16 12 14 17 15 17 14 11 177 14.750 2.927 20 11 9 13.872 15.628 Department 9 17 18 12 12 13 15 16 17 12 18 15 21 186 15.500 2.876 21 12 9 14.637 16.363 Department 10 12 16 15 15 17 22 15 18 19 21 15 17 202 16.833 2.823 22 12 10 15.986 17.680 Total 134 204 180 164 177 183 180 198 177 198 169 174 Mean 13.400 20.400 18.000 16.400 17.700 18.300 18.000 19.800 17.700 19.800 16.900 17.400 st.Dev 2.011 2.951 2.828 3.978 3.653 4.990 4.397 3.910 5.078 3.795 3.281 4.452 Max 17 25 21 23 24 26 27 27 29 27 24 25 Min 11 16 12 11 13 12 14 16 12 16 14 11 Range 6 9 9 12 11 14 13 11 17 11 10 14 Lower Limit 12.797 19.515 17.151 15.207 16.604 16.803 16.681 18.627 16.177 18.662 15.916 16.064 Upper Limit 14.003 21.285 18.849 17.593 18.796 19.797 19.319 20.973 19.223 20.938 17.884 18.736

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.