The Normality Test Dialog Box

Supporting Information



Controls recalculation of analysis results

  • None
  • Auto
  • Manual

For more information, see: Recalculating Analysis Results


For help with range controls, see: Specifying Your Input Data

Data Range

The input data range.


The column(s) containing grouping information. Different grouping values indicate that the data in the corresponding cells are from different groups. You can add, remove, order grouping columns via controlling buttons: Move Up button Button Group List Move Up.png, Move Down button Button Group List Move Down.png, Remove button Button Group List Remove.png, Select All button Button Group List Select All.png, Select button Button Group List Add.png in toolbar Group List Toolbar.png.

The grouping columns will be set as categorical if most of the column values are text. So you can easily reorder the output columns.

Quantities to Compute


Perform Shapiro-Wilk test.


Perform Kolmogorov-Smirnov test.

Parameters List:


The test will use the mean and variance estimated from the input data.


The test will use the mean and variance specified by the user.
Only available when Parameters = Specified. Mean value to use in the Kolmogorov-Smirnov test.
Only available when Parameters = Specified. Variance value to use in the Kolmogorov-Smirnov test.

Perform the Lilliefors test.


Perform the Anderson-Darling test.

D'Agostino-K squared

Perform the D'Agostino-K squared test.


Perform the Chen-Shapiro test.

Significance Level The significance level of the test.


For help with directing output, see: Output Results

Graph Arrangement

Set the plots format of this analysis.

Arrange Graphs into Columns

Specify number of columns to arrange output graphs.

Arrange Plots of Same Type in One Graph

Check to plot all graphs in one graph window.
Dataset Identifier Specify the identifier for the source datasets.
Select a type to specify the source datasets information.
  • Range
Use the range syntax.
  • Book Name
Use the workbook long name.
  • Sheet Name
Use the worksheet name.
  • Name
Use the long name of the corresponding column if there is a long name, otherwise use the short name of column.
  • Short Name
Use the short name of the corresponding column.
  • Long Name
Use the long name of the corresponding column.
  • Units
Use the unit of the corresponding column.
  • Comments
Use the comment of corresponding column.
  • <Custom>
Use custom formats to define a data identifier. For its usage, please refer to Advanced legend text customizations.
Show Identifier in Flat Sheet
Specify whether to use the dataset identifier in flat sheet.
Normality Report Tables

Specifies the destination of report worksheet tables


Specifies the destination workbook.
  • <none>: Do not output report worksheet tables
  • <source>: The source data workbook
  • <new>: A new workbook.
  • <existing>: A specified existing workbook


The destination worksheet, always <new>.

Result Log

Use this check box to Specify whether to output the report to Result Log

Script Window

Use this check box to specify whether to output the report to Script Window.

Notes Window

Use this drop-down list to specify the destination Notes Window:
  • <none>: Do not output to any Notes window.
  • <new>: Output to a new Notes window. You can enter the desired name of the Note window here.
Optional Report Tables

Specifies what is output to report worksheet


Notes table

Input Data

Table for input data

Masked Data

Table for masked data

Missing Data

Table for missing data



Output a histogram.

Box Charts

Output a box chart.