Create a multi-vari chart to understand the source of variation

Create a multi-vari chart to understand the source of variation

Problem Statement

Create a Multi-Vari chart for the data given below. Determine which variable contributes the most to the variation of the output. The data for this exercise is attached. 

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 Multi vari chart.xlsx attachment.
  2. Select the data and convert it to table format by clicking Ctrl-T.


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


Step 4: Specify analysis options
 A new Multi Vari Chart 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 Longterm and Table1 Output to the ResponseVariables and Table 1 Positional and Table1 Short Term to the Factor 1 Variable.



If you need to change 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.

Interpreting Results

The following conclusion can be drawn from this analysis.
  1. Factor1 variance contribution: 0.07
  2. Factor2 variance contribution: 0.27
  3. Factor3 variance contribution: 8.68
  4. As can be seen, factor 3 contributes most to the output variation with a variance of 8.68.
  5. Factors Factor 1 and Factor 2 have far lower contributions toward the variation.

    • Related Articles

    • Multi-vari chart overview

      A Multi-Vari Chart is a statistical tool that visually analyzes the variation within a process or system. It seeks to differentiate between sources of variation, such as within subgroups, between subgroups, and over time. This chart gives an easy and ...

    • Create a waterfall chart to show the variation in inventory level by quarter

      Problem Statement Create a waterfall plot for the given data. Show the variation of inventory from 2015 to 2016 with changes in each quarter. The data is given in the attachment. How to perform analysis Step 1: Open Sigma Magic Click on the Sigma ...

    • Multi Voting Example

      Problem Statement Use a Multi Voting template to determine the mode of entertainment for the weekend within a family of 4 people (Father, Mother, Son, Daughter). How to perform analysis Step 1: Open Sigma Magic Click on the Sigma Magic button on the ...

    • 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 ...

    • Create a run chart for company revenue

      Problem Statement The following data represents Apple's quarterly revenue and earnings per share (EPS) from 2007 to 2014. Construct a time series plot of Apple's revenue by quarter. Create a run chart for the revenue over time and determine if the ...