# Data Normality Tests in Excel

## Is Your Data Normal?

Statistical analysis (e.g., ANOVA) may rely on your data being "normal" (i.e., bell-shaped), so how can you tell if it really is normal?

The two tests most commonly used are:

#### The Anderson-Darling values shown are:

- A-squared = 0.270
- p value= 0.648
- 95% Critical Value = 0.787
- 99% Critical Value = 1.092

If |
Then |

p value <= a | Reject the null hypothesis |

p value > a | Cannot reject the null hypothesis - the data is normal. |

A-squared > critical value |
Reject the null hypothesis |

A-squared <= critical value |
Cannot reject the null hypothesis - the data is normal. |

"Null hypothesis" is that the data is normal.

The "alternative hypothesis" is that the data is non-normal.

Reject the Null hypothesis (i.e., accept the alternative) when p<=alpha or A-squared>critical value.

**Using the p value**: *p* = 0.648 which is greater than alpha (level of significance) of 0.01. So we cannot reject the null hypothesis (i.e., the data is normal).

**Using the critical values**, you would only reject this "null hypothesis" (i.e., data is non-normal) if A-squared is greater than either of the two critical values. Since 0.270 < 0.787 and 0.270 < 1.092, you can be at least 99% confident that the data is normal.

### Normal Probability Plot Method

The probability plot transforms the data into a normal distribution and plots it as a scatter diagram.

- Normal data will follow the trend line.
- Non-normal data will have more points farther from the trend line.
- QI Macros probability plot also calculates R².

### Normal Probability Plots in QI Macros Add-in for Excel

QI Macros has several tools that will run a Probability Plot for you. They include:

- Descriptive Statistics
- Capability Suite of Six Charts
- XmR, XbarR and XbarS chart templates

**Example of QI Macros XmR chart Template**

Just by looking at the histogram (bell shaped) and probability plot, you can see that this data is fairly normal.

### Why Choose QI Macros Statistical Software for Excel?

### Affordable

- Only
**$249**- less with quantity discounts - No annual fees
- Free Technical Support

### Easy to Use

- Works Right in Excel
- Interprets Results for You
- Accurate Results Without Worry

### Proven and Trusted

- 100,000 Users in 80 Countries
- Celebrating 20th Anniversary
- Five Star CNET Rating - Virus Free