KEMBAR78
ASQ Data Analysis | PDF | Microsoft Excel | Computing
Scribd
Upload
36 views7 pages

ASQ Data Analysis

This document contains a template for tracking defects and occurrences over time. Data on defects such as "breakdown of rolling plate" can be entered on a weekly basis, with totals automatically calculated. Charts will then visualize the data through a histogram of defects over time, a bar chart of defect counts, and a Pareto chart showing the most common defects. Instructions are provided on modifying the template by hiding rows if fewer than 10 defects need to be recorded.

Uploaded by

normal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
36 views7 pages

ASQ Data Analysis

This document contains a template for tracking defects and occurrences over time. Data on defects such as "breakdown of rolling plate" can be entered on a weekly basis, with totals automatically calculated. Charts will then visualize the data through a histogram of defects over time, a bar chart of defect counts, and a Pareto chart showing the most common defects. Instructions are provided on modifying the template by hiding rows if fewer than 10 defects need to be recorded.

Uploaded by

normal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 7

Defect Types/

Event Occurrence TOTAL

breakdown of rolling plate 1800

#VALUE! ###

#VALUE! ###

#VALUE! ###

#VALUE! ###

#VALUE! ###

#VALUE! ###

#VALUE! ###

#VALUE! ###

#VALUE! ###
The "Check Sheet-Weekly" worksheet can be printed for use by individuals in their data collection
Once data is collected on printed forms, type either the combined data or data for each individual into this Excel wo
If Data is entered for each individual data recorder, use one of these templates for each individual
**To determine the overall defect rates, it is recommended that all data be combined from all data recor
and entered into this template so that the data can be analyzed overall to find the defect with the most o

The following charts will automatically be generated:


Histogram: shows the number of defects over time
Bar Chart: shows the number/count of defects
Pareto Chart: displays the 80/20 rule for defects

To modify this template:


The check sheet is designed to record up to 10 defects or events. If less defects are desired to be reco
hide the corresponding rows in the "Check Sheet-Weekly" worksheet by following these steps
Select the rows to be hidden by clicking on the row header
Click "Format" from the menu bar, then choose "Row" then "Hide"
dividual into this Excel worksheet.
s for each individual
mbined from all data recorders
the defect with the most occurences

cts are desired to be recorded,


wing these steps
Project Name:

Name of Data Recorder:

Location:

Data Collection Dates:

Dates
Defect Types/
Event Occurrence Sunday Monday Tuesday Wednesday Thursday Friday Saturday TOTAL

breakdown of rolling plate 100 500 1200 1800

Defect 2

Defect 3

Defect 4

Defect 5

Defect 6

Defect 7

Defect 8

Defect 9

Defect 10

TOTAL 100 500 1200 1800


1400

1200
1200

1000
Counts

800

600
500

400

200
100

0
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
2000

1800
1800

1600

1400
Counts

1200

1000

800

600

400

200

0
breakdown Defect 2 Defect 3 Defect 4 Defect 5 Defect 6 Defect 7 Defect 8 Defect 9 Defect 10
of rolling
plate
2000

1800
1800

1600

1400
Counts

1200

1000

800

600

400

200

0
breakdown #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
of rolling
plate

You might also like