
All you need to do is:
1. In a separate Excel file (e.g., your data file) sort your data in ascending order. Note: When
testing for normality, be sure to run each group (population)
separately. Recall, for example in ANOVA, you are comparing a
number of normal curves along an axis. Each normal curve must
obviously be a "normal curve."
[To do this select from the top menu Data and then Sort. Be sure the correct column is selected before sorting].
2. Copy and paste the sorted column of data into the first column above. Just click on the first existing entry and then paste. The new numbers will appear correctly.
3. Check out what the outcome is in the alpha = 0.05 column.
4.
Also check out the Normal Quantile Plot; if your data set is normally
distributed the plot will approximate a straight line. [A
leptokurtic distribution (on the skinny side of normality) will exhibit
a sigmoid (s-shaped) plot, whereas a platykurtic distribution (on the
broad side of normality) will appear as a reverse sigmoid curve.
5.
If you want to test another set of data, Edit/Unpaste the data you
first added and then add your new set. Otherwise you may get an
error stating that it's a read-only file and that you can't modify it
without a password.
This is the response you get if your data set is not randomly distributed: