In time series and econometric modeling, we often encounter the normality test as part of the residuals diagnosis to validate a model's assumption(s).
NumXL provides an intuitive interface to help Excel users conduct a normality test in Excel using several methods. In this tutorial, we’ll demonstrate the steps to construct a normality test in Excel of hypothesis using NumXL functions.
- Select an empty cell to store the histogram table
- Locate the Statistical Test (STAT TEST) icon in the toolbar (or menu in Excel 2003) and click on the down-arrow. When the drop-down menu appears, select “Normality Test”.
- The Normality Test in Excel dialog box appears.
- Select the cell range for the input data.
- Selecting the input data cell range will enable the “Options” and “Missing Values” tabs. Click the “Options” Tab.
- Select the Normality tests to include in the output table.
Note: Initially, all tests are selected as shown above.
- If your data include one or more intermediate observations with missing values, click the “Missing Values” tab.
- Initially, missing values are dropped from the sample data. If you wish to change this behavior/treatment, select an alternative method.
- Now, Click “OK” to generate the output table.
- The normality test in Excel wizard generates the output table as shown below: