Duplicate Analysis

Sometimes, we want to perform minor changes to an analysis to see the impact of the change on the analysis results. You don't have to re-do all the steps of adding a new analysis tool, specifying the data and analysis options etc. in order to do this. A quick way to perform the what-if analysis is to duplicate an existing analysis and then make changes to the settings.

In order to do this select the worksheet that you want to duplicate and then click on the Duplicate button on the main menu bar.

Let's say we have a box plot of AG Data shown below. We want to perform the same analysis but add Shift as the categorical variable for this analysis.

In order to do this, you can duplicate this worksheet and then click on Data tab and then specify the Shift variable.

Clicking on the OK button will generate the new analysis as shown below.

The Duplicate button can be used to quickly duplicate an existing analysis. It will copy the entire analysis and all your setup options. You just need to make minor changes and then click on the OK button to generate/update analysis results.

• Related Articles

• Analysis Summary

  You can view a summary of all the analysis performed in your workbook by clicking on the Summary button on the main menu bar. An example output of the summary page is shown below: The summary sheet contains the following columns: A brief description ...

• Specifying Analysis Setup

  If you want to specify the options for any analysis, you can click on the Analysis Setup button on the main menu bar. Depending on the worksheet that is currently active, the analysis setup will be displayed for that worksheet. For example, if you ...

• Compute Outputs

  If you want to update analysis results because you updated your data or changed any analysis settings, you can do so by clicking on the Compute Outputs button on the main menu bar. Another way to update analysis results is to click on Analysis Setup ...

• Main Menu Bar

  The software is an add-in within Microsoft Excel. When you open Microsoft Excel, you should see the software on the main menu bar. Click on the Sigma Magic button to load the software into memory. This will open the Sigma Magic menus as shown in the ...

• Tool Wizard

  You can add a new analysis template to your project using the tool wizard. Click on the Tool Wizard on the main menu bar. This will open a dialog box as shown in the figure below. You can click on the tool grouping at the left, such as "Stats," and ...