Required File: Blank Excel Workbook
Directions:
Diane works for a pretzel-manufacturing company with 2,300 employees. Her quality circle is trying to solve the problem of how to reduce accidents at the plant. Diane was asked to compile data using
a Frequency Chart listing the type of injuries that have occurred at the plant during the past month. The company nurse provided the following monthly accident report:
MONTHLY ACCIDENT REPORT – TASTEE PRETZELS, INC.
|
Date |
Person |
Description of Accident |
|
1 |
Smith |
Tripped over ladder, sprained ankle |
|
3 |
Rogers |
Hand caught in machine, large cut |
|
3 |
Jackson |
Slipped on mopped floor, injured back |
|
5 |
Cortez |
Fell down steps, injured back |
|
6 |
Gerber |
Brushed against ovens, burned hand |
|
8 |
Mitchell |
Tripped over boxes, sprained ankle |
|
9 |
Walls |
Didn’t use gloves, burned hand |
|
10 |
Washington |
Fell from ladder, broke leg |
|
12 |
Ott |
Lifted heavy box, injured back |
|
13 |
Wallace |
Solvent splashed, eye injured |
|
13 |
Michaels |
Fell on steps, injured back |
|
15 |
Chavez |
Running and tripped, injured back |
|
16 |
Jones |
Tripped over ladder, sprained ankle |
|
18 |
DiFabio |
Hand caught in machine, large cut |
|
19 |
Buzon |
Slipped on mopped floor, injured back |
|
20 |
Leveau |
Fell down steps, injured back |
|
21 |
Tillet |
Brushed against ovens, burned hand |
|
22 |
Corte |
Tripped over boxes, sprained ankle |
|
23 |
Davidson |
Didn’t wear gloves, burned hand |
|
26 |
Cardamone |
Fell from ladder, broke leg |
|
27 |
Holt |
Lifted heavy box, injured back |
|
30 |
Lilly |
Solvent splashed, eye injured |
|
30 |
Harris |
Fell on steps, injured back |
|
31 |
DeBono |
Running and tripped, injured back |
FREQUENCY CHART EXERCISE: A frequency table for data collection has four columns. The first column is labeled Item; the second column, Tally; and the third column, Number of Incidents, and the
fourth column is Percentage (%). Under the column Item, list the description of each incident. Place a slash mark (/) in the Tally column for each occurrence. In the Number of Incidents column add the total
number of slash marks listed in the Tally column. In the Percentage (%) column, calculate the percentage of each number of incidents. Use Excel to create this table.
The following is an Example:
Blade falls off /// 3 30%
Controls won’t work ///// 5 50%
Motor quits working // 2 20%
10 100%