KEMBAR78
Data Analysis | PDF | Microsoft Excel | Data Analysis
Scribd
Upload
52 views7 pages

Data Analysis

This document describes a defect tracking worksheet template for recording defects over multiple weeks. Data on defects is entered on a printed check sheet by individual recorders, then combined into the Excel template. The template will chart the number of each defect over time, including a histogram, bar chart, and Pareto chart. Users can modify the template by hiding rows for defects not being recorded. The goal is to analyze defect data overall to determine which defect occurs most frequently.

Uploaded by

vrushalmaniyar
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
52 views7 pages

Data Analysis

This document describes a defect tracking worksheet template for recording defects over multiple weeks. Data on defects is entered on a printed check sheet by individual recorders, then combined into the Excel template. The template will chart the number of each defect over time, including a histogram, bar chart, and Pareto chart. Users can modify the template by hiding rows for defects not being recorded. The goal is to analyze defect data overall to determine which defect occurs most frequently.

Uploaded by

vrushalmaniyar
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

Defect 1

71

Defect 1

71

Defect 1

71

Defect 1

71

Defect 1

71

Defect 1

71

Defect 1

71

Defect 1

71

Defect 1

71

Defect 1

71

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

Defect 1

10

12

12

12

12

12

71

Defect 2

10

12

12

12

12

12

71

Defect 3

10

12

12

12

12

12

71

Defect 4

10

12

12

12

12

12

71

Defect 5

10

12

12

12

12

12

71

Defect 6

10

12

12

12

12

12

71

Defect 7

10

12

12

12

12

12

71

Defect 8

10

12

12

12

12

12

71

Defect 9

10

12

12

12

12

12

71

Defect 10

10

12

12

12

12

12

71

TOTAL

100

120

120

120

120

10

120

TOTAL

710

140

120

120

Counts

100

120

120

120

120

100

80

60

40

20
10
0
Sunday

Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

80
71

71

71

71

71

71

71

71

71

71

Defect 1

Defect 2

Defect 3

Defect 4

Defect 5

Defect 6

Defect 7

Defect 8

Defect 9

Defect 10

70

Counts

60

50

40

30

20

10

80
71

71

71

71

71

71

71

71

71

71

Defect 1

Defect 1

Defect 1

Defect 1

Defect 1

Defect 1

Defect 1

Defect 1

Defect 1

Defect 1

70

Counts

60

50

40

30

20

10

You might also like