Data Normality Tests using p value and critical values


© 2007 KnowWare International, Inc. DBA LifeStar
2253 S. Oneida St., Ste 3D
Denver, CO 80224

Jay Arthur
888-468-1537
303-756-9144
Email Us

We help people think!

Is Your Data Normal?

Statistical analysis 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:

  • Normal Probability Plot
  • p-value or Critical Value method

Normal Probability Plot Method

If you've used any of the QI Macros X Chart templates, you know that the normal probability plot is part of the XmR, XbarR and XbarS templates:

probability plot in Excel

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

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.

p-value and Critical Value Method

The Descriptive Statistics or Normality Test in the QIMacros Anova Tools uses the Anderson-Darling method to analyze normality more rigorously. The output includes the Anderson-Darling statistic, A-squared, and both a p-value and critical values for A-squared. Using Cells A1:A26 from the XbarR.xls in c:\qimacros\testdata, you would get:

p value and A2 critical value calculations

The Anderson-Darling values shown are:

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

In this case, the "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.

Another Example

Using Cells D1:D41 (after deleting the blank row) from the XbarR.xls in c:\qimacros\testdata, you would get the following result. Notice how the normality plot curves at the right so that some of the points are farther from the line. Using Anderson-Darling we discover that the data is considered normal at one level (99%), but not at another (95%).

p value and A2 critical value calculations

Using the p value p = 0.016 which is greater than alpha of 0.01 (0.01 < 0.016 < 0.05), we can reject the null hypothesis (i.e., the data is normal) at alpha = 0.05, but not at alpha = 0.01.

Using the critical values, . Since 0.787 <0.932 < 1.092, you would reject the null hypothesis at 95% but not reject it at 99%.

Frankly, the double negatives of "not rejecting the null hypothesis" makes my brain tired. All I really want to know is: "Is my data normal?" So, in summary:

  • if the dots fit the trend line on the normal probability plot, then the data is normal
  • if p > alpha then the data is normal
  • if A-squared < Critical Value, then the data is normal.

To purchase the QI Macros go to https://www.qimacros.com/orderform.html.

If you already own the QI Macros, you can purchase an upgrade at https://www.qimacros.com/orderup.html . You must purchase one upgrade for each license you own.

Buy QI Macros Excel SPC Software for Histograms and Control Charts Now QI Macros Excel SPC Software for Histograms and Control Charts $139 Plus S&H


© 2007 KnowWare International Inc. (888) 468-1537
knowwareman@qimacros.com
Home | Lean Six Sigma | QI Macros | KnowWare | Site Map

Dashboards and Scorecards

QI Macros 30-day Trial & FREE QI Macros Course
Name:
E-mail
 

QI Macros SPC Software for Excel
Or Buy It Now!
Unconditional
90-Day
Money-Back
Guarantee

The QI Macros for Excel $139, is an inexpensive easy to use set of Excel add-ins for statistical process control and Lean Six Sigma. It draws line, pie, bar, pareto, box whisker, histogram (Cp, Cpk), scatter and control charts (with stability analysis).

It contains over 70 fill in the blank templates such as the Ishikawa diagram, QFD, DOE, FMEA, PPAP, and Gage R&R for MSA. Performs ANOVA, t-test, F-test, and regression analysis.

Buy All-in-One, Excel SPC Software Now

Quantity Discounts

Customer Testimonials

Minitab Comparison

QI Macros FAQs

FREE Lean Six Sigma Course
& QI Macros 30-day Trial
Name:
E-mail