Create an individual value plot for the delivery time of two suppliers

Create an individual value plot for the delivery time of two suppliers

Problem Statement

The attachment shows the delivery time of two suppliers A and B. The response variable is in the Data column, and the categorical variable (supplier name) is in the group column. Create the individual value plot, which shows the delivery time of suppliers A and B, and interpret the results.

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 Supplier.xlsx attachment.
  2. Select the data and convert it to table format by clicking on 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 Individual Value Plot.


Step 4: Specify the analysis options
 A new Box Plot 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 Table13 Data to the Analysis Variables and Table13 Group to the Categorical Variables.




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.



How to interpret results

    The following conclusion can be drawn from this analysis.

    1. Delivery Time Variability:
      1. Supplier A: The delivery times for Supplier A vary between 29 and 35 days, with a more concentrated clustering around 31–33 days.
      2. Supplier B: The delivery times for Supplier B vary between 32 and 39 days, showing a wider spread, especially on the higher end.
    2. Central Tendency:
      1. Supplier A seems to have a lower average delivery time than Supplier B.
      2. The delivery times for Supplier A are more centered and less variable, while Supplier B is more variable.
    3. Outliers and Spread:
      1. There are no outliers for either supplier, but the higher variability of Supplier B may suggest less predictable delivery times.
    4. Performance Implication:
      1. Supplier A is likely more reliable because of its tighter clustering of delivery times.
      2. Supplier B, although delivering within an acceptable range most of the time, may sometimes cause delays because of its longer delivery times.

      • Related Articles

      • Create a box plot of the delivery time of two suppliers

        Problem Statement The attachment shows the delivery time of two suppliers, A and B. The response variable is in the Data column, and the categorical variable (supplier name) is in the group column. Create the box plot showing the delivery time of ...

      • Individual value plot frequently asked questions

        What is an individual value plot? An Individual Value Plot (also known as a "dot plot" in some contexts) is a type of data visualization that displays each individual data point on a number line. This plot helps show the distribution of data and ...

      • Individual value plot overview

        An Individual Value plot is a statistical tool that displays the performance or behavior of individual data points in a dataset. This plot generally emphasizes variation and trends in quality management, process control, and exploratory data ...

      • Time Series Plot Example

        Problem Statement Create a time series plot for the data shown in the Data tab. How to perform analysis Step 1: Open Sigma Magic Click on the Sigma Magic button on the Excel toolbar. Click on the New button to create a new project. Step 2: Data ...

      • Time Series Plot Overview

        A Time Series Plot is a graphical representation of data points collected or recorded at successive time intervals. It is widely used in various fields like finance, economics, weather forecasting, and business analytics to analyze trends, patterns, ...