Create a pie chart for defect categories by the given frequencies

Create a pie chart for defect categories by the given frequencies

Problem Statement

Data shown in the data tab contains various defect categories and the frequency of defects. Create a Pie Chart for the given data in the attachment.

How to perform analysis

Step 1: Open Sigma Magic
  1. Click on the Sigma Magic button on the Excel toolbar.
  2. Click on the New button to create a new project.
Step 2: Data Preparation
  1. Open the Defects.xlsx attachment
  2. Select the data and convert it to table format by clicking on Ctrl-T.


Step 3: Add the pie chart template
  1. Click on the Tool Wizard to add the analysis template.
  2. Click on Graph and then Pie Chart.



Step 4: Specify analysis options
 A new Pie Charts worksheet will be added to your workbook, and the following dialog box will be opened. Click on the Setup tab on the right. Accept the default values and specify the analysis options.



Next, click on the Data tab and specify the data. Drag and drop the Table1 Frequency to the Frequency Variables and Table 1 Cause to the Categorical Variables.



If you need to make changes to the charts, specify the optional settings in the Charts tab.

 Labels:

  • Add a title for the chart.
  • Label the X-axis and Y-axis appropriately.

Appearance:

  • Adjust colors, font sizes, or other visual elements as needed.
  • Enable/disable gridlines or background shading.

Finally, click the Verify tab to ensure all the inputs are okay and shown in a green checkmark.



Step5: Generate analysis results
Click on the OK button to generate analysis results. The following figure shows an example output screen.


How to interpret results

The following conclusion can be drawn from this analysis.
    1. Total Defects: 426
    2. Average Defects per Category: 85.2
    3. Highest Defect Count: 232 (Scratches)
    4. Lowest Defect Count: 15 (Other)
    5. There is a significant drop between the top two defects and the rest:
                       Scratches: 54.5%
                       Cuts: 26.1%
                       Tear: 10.8%
                       Burns: 5.2%
                       Other: 3.5%
          6.The chart and table indicate that "Scratches" are the most common defect, at more than 54% of the total, followed by "Cuts" at 26%.


      • Related Articles

      • Pie chart frequently asked questions

        What is a pie chart? A pie chart is a circular chart divided into slices to illustrate numerical proportions. Each slice represents a category’s contribution to the whole, with the size of each slice proportional to the value it represents. When ...

      • Pie chart overview

        A pie chart is a circular statistical graphic divided into slices to show numerical proportions. Each slice is a category or part of the whole, and the size of each slice is proportional to the quantity or percentage that the category represents. The ...

      • Pareto chart frequently asked questions

        What is a Pareto chart? A Pareto chart is a type of bar chart that displays data in descending order of frequency or size, often combined with a line graph that shows the cumulative total. It’s used to highlight the most important factors in a ...

      • Bar chart frequently asked questions

        What is a bar chart? A bar chart is a graphical representation of data where individual bars represent different categories or groups. The length or height of each bar is proportional to the value or frequency of the category it represents. When ...

      • Bar chart overview

        A bar graph or a chart is a two-dimensional graph used to illustrate data through rectangles where the dimension or size, in this case, the height or length, is directly proportional to the value for which it presents. The axes of a chart may be ...