Time Series Plot Example

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

Step 3: Add analysis template
  1. Click on the Tool Wizard to add the analysis template.
  2. Click on Graph and then Time Series Plot.

Step 4: Specify the analysis options
A new Time Series 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 Table1 Data to the to the Y Variables and Table 1 Group to the Grouping 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.

Interpretation of Results

Increase in Data Values:

  • The after group has higher values compared to the before group, suggesting an overall upward shift in the data.
  • The mean increased from 13 to 18.67, and the minimum value rose from 11 to 18.

 Reduced Variability:

  • The standard deviation (Stdev) decreased from 1.41 to 0.82, indicating that the data points in the after group are more closely clustered around the mean, implying lower variability.

Possible Trend Change:

  • The before group fluctuates more, while the after group shows a steady upward trend.
  • This could indicate an improvement or an external factor influencing the data after a certain point.

    • Related Articles

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

    • Matrix Plot Example

      Problem Statement The following variables are data from three distributions (normal, rayleigh, and uniform). Can you check if the variables are correlated using a matrix plot? How to perform analysis Step 1: Open Sigma Magic Click on the Sigma Magic ...

    • Time Study Example

      Problem Statement Create a time study for the following case. The TAKT Time for this exercise is 52 sec. Process step Time 1 Time 2 Time 3 Notes Get part from the tub 8 7 10 NVA Load part onto the fixture 20 15 17 Get tape from dispenser 3 2 NVA Put ...

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

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