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 have the Basic Stats worksheet active, then the following analysis setup dialog box is displayed.

The Analysis Setup contains several tabs on the right. 

Setup: This tab contains the settings for the analysis. In this example, you can specify the data type, the notes type, and the stats you want to display for this analysis.

Data: This tab allows you to select the data that you want to analyze. The left section of this dialog box contains the list of available data, and the right section contains the selected data for analysis. Drag and drop the requisite data for analysis. Note that there are three data that be specified. The analysis variable, the grouping variable, and the by variable.

Charts: This tab allows you to specify the options for the charts. This is optional and can be used to override the defaults specified by the software. Here, you can change the title, subtitle, the axis labels, limits, and add horizontal and vertical lines.

 

Verify: This tab lets you verify is you have correctly specified the analysis options. If there are any errors, it will be shown here before you perform the analysis. In this example, all the inputs seem to be okay.

Clicking on OK will generate analysis results. Note that the analysis settings are saved with your worksheet. The next time you open this dialog box, all your settings can be viewed and/or updated as required.

• Related Articles

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

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

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

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

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