This preview has intentionally blurred parts. Sign up to view the full document

View Full Document

Unformatted Document Excerpt

Is What a Pareto Chart? Bar chart arranged in descending order of height from left to right Bars on left relatively more important than those on right Separates the "vital few" from the "trivial many" (Pareto Principle) PARETO CHART VIEWGRAPH 1 Why Use a Pareto Chart? Breaks big problem into smaller pieces Identifies most significant factors Shows where to focus efforts Allows better use of limited resources PARETO CHART VIEWGRAPH 2 Constructing a Pareto Chart Step 1 - Record the data Step 2 - Order the data Step 3 - Label the vertical axis Step 4 - Label the horizontal axis Step 5 - Plot the bars PARETO CHART VIEWGRAPH 3 Constructing a Pareto Chart Step 6 - Add up the counts Step 7 - Add a cumulative line Step 8 - Add title, legend, and date Step 9 - Analyze the diagram PARETO CHART VIEWGRAPH 4 Analysis Sheet Example Outstanding Debts Category Amount ($) School tuition (monthly installments) 2,030 Visa 2,007 Church pledge (monthly installments) Mastercard 2,000 1,983 Balance of car loan 1,971 Home improvement loan balance 1,956 Total PARETO CHART 11,947 VIEWGRAPH 5 Pareto Chart Example Outstanding Debts Amount Owed $ 12,000 10,800 9,600 8,400 7,200 6,000 4,800 3,600 2,400 1,200 0 Tuition Visa Church MC Car Home Type of Debt LEGEND: AMOUNT OWED ON OUTSTANDING DEBTS AS OF 12 FEB 95. PARETO CHART VIEWGRAPH 6 Analysis Sheet Example Interest Rates on Outstanding Debts Category Int. Rate (%) Visa 21 Mastercard Balance of car loan 18 9 Home improvement loan balance 6 School tuition (monthly installments) 2 Church pledge (monthly installments) 1 PARETO CHART VIEWGRAPH 7 Pareto Chart Example Interest Rates on Outstanding Debts Interest Rates 57.0 51.3 45.6 39.9 34.2 28.5 22.8 17.1 11.4 5.7 0.0 Visa MC Car Home Tuition Church Type of Debt LEGEND: INTEREST RATES CHARGED ON OUTSTANDING DEBTS AS OF 12 FEB 95. PARETO CHART VIEWGRAPH 8 Data on BEQ / BOQ Complaints Complaint Feb Mar Apr Total Loud stereo noise after 2300 30 50 17 97 Insufficient hot water 23 20 11 54 Towels too small and/or thin 12 8 12 32 175 10 100 13 75 60 350 83 1 4 10 15 25 52 50 127 Cockroaches 324 265 373 962 Rooms too warm or too cold 300 110 95 505 Inadequate lighting Poor quality TV reception Worn-out furniture Insufficient storage space PARETO CHART VIEWGRAPH 9 EXERCISE 1 ANALYSIS SHEET ANSWER KEY BEQ / BOQ Complaints Category Amount Percent Cum. % * Cockroaches Rooms too warm or cold 962 505 43.2 22.7 43.2 Inadequate lighting 350 15.7 65.9 Insufficient storage space 127 5.7 81.6 Loud stereo noise after 2300 Poor quality TV reception 97 83 4.4 3.7 87.3 91.7 95.4 Insufficient hot water Towels too small and/or thin Worn-out furniture 54 32 15 2.4 1.4 0.7 97.8 99.2 99.9 Total 2225 * Cumulative percent column does not equal 100% because of rounding. PARETO CHART VIEWGRAPH 10 EXERCISE 1 PARETO CHART ANSWER KEY Number of Complaints BEQ / BOQ Complaints 2225 2007 1784 1561 1338 1115 892 669 446 223 0 Break point 100 % 90 80 70 60 50 40 30 20 10 0 Temp Storage TV Towels Roaches Lighting Stereo Water Furn Type of Complaint LEGEND: COMPLAINTS RECORDED IN BEQ / BOQ, 1 FEB - 30 APR 95. PARETO CHART VIEWGRAPH 11 Data on Injuries by Department FALL EYE CUT / INJURY ABRASION SPORT MOTOR VEHICLE ADMIN 0 0 2 3 0 OPS 1 0 1 2 1 MAINT 7 3 5 16 9 SAFETY 0 0 1 1 1 TRAIN 0 1 0 1 2 PARETO CHART VIEWGRAPH 12 Data on Injuries by Personnel Assigned FALL EYE CUT / INJURY ABRASION SPORT MOTOR VEHICLE ADMIN 0.0 0.0 0.2 0.3 0.0 OPS 0.1 0.0 0.1 0.2 0.1 0.035 0.015 0.025 0.08 0.045 SAFETY 0.0 0.0 0.2 0.2 0.2 TRAIN 0.0 0.2 0.0 0.2 0.4 MAINT PARETO 13 EXERCISE CHART VIEWGRAPH 2A ANALYSIS SHEET ANSWER KEY Injuries by Department No. Injuries Category Maintenance 40 Percen t Cum. % * 70.2 70.2 Operations 5 8.8 79.0 Admin 5 8.8 87.8 Training 4 7.0 94.8 Safety 3 5.3 100.1 Total 57 * Cumulative percent column does not equal 100% because of rounding. PARETO CHART VIEWGRAPH 14 EXERCISE 2A PARETO CHART ANSWER KEY Injuries Injuries by Department 57.0 51.3 45.6 39.9 34.2 28.5 22.8 17.1 11.4 5.7 0.0 100 90 80 70 60 50 40 30 20 10 0 Break point Maint Ops Admin Trng % Safety Department LEGEND: INJURIES TO SQUADRON PERSONNEL 1 FEB - 30 APR 95. PARETO CHART VIEWGRAPH 15 EXERCISE 2B ANALYSIS SHEET ANSWER KEY Injuries by Personnel Assigned Category Injury Rate Percent Cum. % * Safety Training 0.80 0.80 28.6 28.6 28.6 57.2 Admin 0.50 17.9 75.1 Operations 0.50 17.9 93.0 Maintenance 0.20 7.1 100.1 Total 2.80 * Cumulative percent column does not equal 100% because of rounding. PARETO CHART VIEWGRAPH 16 EXERCISE 2B PARETO CHART ANSWER KEY Injuries by Personnel Assigned 2.8 2.5 100 % 90 80 70 60 50 40 30 20 10 0 Break point 2.2 Injuries / Personnel Assigned 2.0 1.7 1.4 1.1 0.8 0.6 0.3 0.0 Safety Trng Admin Ops Maint Department LEGEND: INJURIES TO SQUADRON PERSONNEL 1 FEB - 30 APR 95. BASED ON NUMBER OF PERSONNEL ASSIGNED. PARETO CHART VIEWGRAPH 17 Data on Injuries by Department FALL EYE CUT / INJURY ABRASION SPORT MOTOR VEHICLE ADMIN 0 0 2 3 0 OPS 1 0 1 2 1 MAINT 7 3 5 16 9 SAFETY 0 0 1 1 1 TRAIN 0 1 0 1 2 PARETO CHART VIEWGRAPH 18 EXERCISE 2C ANALYSIS SHEET ANSWER KEY Injuries by Type Category Sports Motor vehicle No. Injuries 23 13 40.4 22.8 Cum. % 40.4 63.2 Percent Cuts/abrasions Falls 9 8 15.8 14.0 79.0 93.0 Eye injuries 4 7.0 100.0 Total PARETO CHART 57 VIEWGRAPH 19 EXERCISE 2C PARETO CHART ANSWER KEY Number of Injuries Injuries by Type 58.0 52.2 46.4 40.6 34.8 29.0 23.2 17.4 11.6 5. 8 0.0 Break point Sports Vehicle Cuts Falls Eye 100 % 90 80 70 60 50 40 30 20 10 0 Type of Injury LEGEND: INJURIES TO SQUADRON PERSONNEL 1 FEB - 30 APR 95. BASED ON TYPE OF INJURY. PARETO CHART VIEWGRAPH 20 Little League Yankees Stats Type of Error Wild pitch Missed fly ball to the outfield Missed grounder Missed pop fly to the infield Missed coaching signal Taken third strike Throw to wrong cutoff player Failure to back up the play Passed ball PARETO CHART Number 5 29 7 4 5 42 25 6 3 VIEWGRAPH 21 EXERCISE 3 ANALYSIS SHEET ANSWER KEY Stats for Little League Yankees Number Percent Cum. % * Taken third strikes 42 33.3 33.3 Missed fly balls 29 23.0 56.3 Throws to wrong cutoff player 25 19.8 76.1 Missed grounders 7 5.6 81.7 Failure to back up play 6 4.8 86.5 Wild pitches 5 4.0 90.5 Missed coaching signals 5 4.0 94.5 Missed pop flies 4 3.2 97.7 Passed balls 3 2.4 100.1 Type of Error Total 126 * Cumulative percent column does not equal 100% because of rounding . PARETO CHART VIEWGRAPH 22 EXERCISE 3 PARETO CHART ANSWER KEY Number of Errors Stats for Little League Yankees 126 112 98 84 70 56 42 28 14 0 Break point Strike FB Throw GB Backup WP 100 % 90 80 70 60 50 40 30 20 10 0 Pop fly Signal PB Type of Error LEGEND: ERRORS COMMITTED DURING FIRST FIVE GAMES OF SPRING SEASON 1995. PARETO CHART VIEWGRAPH 23 ... View Full Document

End of Preview

Sign up now to access the rest of the document