If you run a t-test, ANOVA, or linear regression without checking one critical assumption first, your results could be completely wrong. That assumption is normality, and learning how to check whether your data is normally distributed is one of the most foundational skills in statistics.
Many of the most common statistical tests assume that your data follows a normal distribution, also known as a Gaussian distribution. When that assumption fails, your p-values, confidence intervals, and conclusions become unreliable.
In this guide, I will walk you through every method available, from simple visual inspections to formal statistical tests like Shapiro-Wilk and Kolmogorov-Smirnov. I will also show you what to do when your data fails the normality test, with specific solutions for Excel, SPSS, R, and Python users.
Whether you are a researcher, analyst, student, or professional working in quality control, the procedure below gives you a clear, repeatable workflow. Let us start with the basics and build toward advanced interpretation.
Table of Contents
What Is a Normal Distribution?
A normal distribution is a symmetric, bell-shaped probability distribution where most observations cluster around the mean and the frequency of values tapers off equally in both directions. It is also called a Gaussian distribution, named after mathematician Carl Friedrich Gauss.
In a perfectly normal distribution, three key properties hold true. The mean, median, and mode are all equal. The distribution is perfectly symmetric around the center. And the spread follows a predictable pattern governed by the standard deviation.
That predictable pattern is called the empirical rule, or the 68-95-99.7 rule. Approximately 68% of your data falls within one standard deviation of the mean, 95% within two standard deviations, and 99.7% within three standard deviations.
This predictability is exactly why so many statistical methods require normality. When your data follows this pattern, you can make precise probability statements and use powerful parametric tests that have higher sensitivity to detect real effects.
Real-world data almost never follows a perfect normal distribution, though. The goal of normality testing is not to prove perfection but to determine whether your data is close enough to normal for parametric tests to produce valid results.
Why You Need to Check Normality Before Statistical Analysis
Parametric tests like the independent t-test, paired t-test, ANOVA, Pearson correlation, and linear regression all assume that the underlying data, or in the case of regression and ANOVA the residuals, come from a normal distribution.
When that assumption holds, these tests are the most powerful tools available. They give you smaller confidence intervals and a better chance of detecting true effects. When the assumption fails, the math behind these tests breaks down.
The consequences of ignoring non-normality depend on the test and how severely your data deviates. Mild departures from normality often cause only minor problems. Severe departures can inflate your Type I error rate, meaning you report significant results that do not actually exist.
Here is the important nuance that many analysts miss. For regression and ANOVA, you should test the normality of the residuals, not the raw data. The assumption applies to the error terms in your model, not the dependent variable itself. I have seen researchers discard perfectly good models because they tested the wrong thing.
Some tests are more sensitive to this assumption than others. T-tests are fairly robust to moderate non-normality, especially with larger sample sizes. ANOVA is similarly robust when group sizes are equal. Regression becomes more sensitive when residuals are heavily skewed or contain extreme outliers.
How to Check Whether Your Data Is Normally Distributed: Visual Methods
Visual inspection is always your first step in normality testing. Graphical methods give you an immediate, intuitive read on your data shape before you run any formal tests. I recommend starting here for every dataset.
Visual methods are fast, they do not require sample size assumptions, and they help you spot specific problems like skewness, outliers, or bimodal distributions that a single p-value would never reveal.
Histograms: The Starting Point
A histogram displays the frequency distribution of your data by grouping values into bins and showing the count or proportion in each bin. For normally distributed data, the histogram should resemble a symmetric bell curve.
Look for symmetry first. If one tail is visibly longer than the other, your data is skewed. Positive skew means the right tail is longer, which is common in income or reaction time data. Negative skew means the left tail is longer.
Next, check for a single peak at the center. Two peaks suggest a bimodal distribution, which could mean your data contains two distinct subgroups that should be analyzed separately.
The limitation of histograms is that small sample sizes produce jagged, hard-to-interpret shapes. With fewer than 30 observations, a histogram may look irregular even when the underlying distribution is normal.
QQ Plots: The Gold Standard for Visual Normality
A quantile-quantile plot, or QQ plot, compares the quantiles of your data against the quantiles of a theoretical normal distribution. If your data is normally distributed, the points fall along a straight diagonal line.
Deviations from the straight line tell you exactly how your data differs from normal. S-shaped curves indicate heavy or light tails. Points curving upward at the right end suggest positive skew. Points dropping below the line at the left end suggest negative skew.
To create a QQ plot in R, use qqnorm(my_data) followed by qqline(my_data). In Python, use scipy.stats.probplot(my_data, plot=plt). In SPSS, the QQ plot appears automatically when you run the Explore procedure.
The advantage of a QQ plot over a histogram is sensitivity. QQ plots reveal tail behavior that histograms hide, and they work reasonably well even with moderate sample sizes of 30 to 50 observations.
Box Plots: Detecting Skewness and Outliers
A box plot summarizes your data using five statistics: minimum, first quartile, median, third quartile, and maximum. It also flags potential outliers as individual points beyond the whiskers.
For normality assessment, check whether the median line sits roughly in the center of the box. If the median is closer to one end, your data is skewed. If the whiskers are dramatically unequal in length, that also signals asymmetry.
Outliers are important because they can trigger normality test failures even when the bulk of your data is well-behaved. Box plots help you identify whether one or two extreme values are the problem.
Stem-and-Leaf Plots
Stem-and-leaf plots are less common in published research but useful for small datasets. They show the actual data values while still giving you a sense of the distribution shape.
Think of a stem-and-leaf plot as a histogram that preserves individual data points. If you have 20 to 40 observations, this plot gives a quick visual check without losing detail.
Formal Statistical Tests for Normality
Visual inspection tells you whether your data looks normal, but statistical tests give you an objective measure. These tests evaluate the null hypothesis that your data was sampled from a normal distribution.
The challenge is that multiple tests exist, each with different strengths. Choosing the wrong test for your sample size or data characteristics can lead to incorrect conclusions.
Shapiro-Wilk Test
The Shapiro-Wilk test is widely considered the most powerful normality test for small to moderate sample sizes. Multiple simulation studies have shown it outperforms other tests when sample sizes are below 50, and it remains strong up to about 2,000 observations.
In SPSS, the Shapiro-Wilk result appears automatically in the Tests of Normality table when you use the Explore command. In R, use shapiro.test(my_data). In Python, use scipy.stats.shapiro(my_data).
The test produces a W statistic and a p-value. A W value close to 1.0 indicates that the data closely matches a normal distribution. The p-value tells you whether that match is statistically significant.
Forum discussions on r/AskStatistics consistently recommend Shapiro-Wilk as the default choice for sample sizes under 50. Medical and pharmaceutical researchers often follow standard operating procedures that mandate Shapiro-Wilk for all normality testing.
Kolmogorov-Smirnov Test
The Kolmogorov-Smirnov test, often called the K-S test, compares your data against any reference distribution you specify. For normality testing, you compare against a normal distribution with the same mean and standard deviation as your sample.
The standard K-S test has a major limitation when testing for normality. It assumes you know the true population parameters, which in practice you do not. The Lilliefors correction addresses this by adjusting critical values for when parameters are estimated from the sample.
SPSS reports both the Shapiro-Wilk and Kolmogorov-Smirnov results side by side. In R, you can use the nortest package with lillie.test(my_data) for the corrected version. The standard version is available via ks.test().
The K-S test is generally less powerful than Shapiro-Wilk for detecting departures from normality. Many statisticians recommend using it only when you need to test against a specific known distribution rather than a normal distribution with estimated parameters.
Anderson-Darling Test
The Anderson-Darling test is similar to the K-S test but gives more weight to the tails of the distribution. This makes it particularly sensitive to departures from normality in the extreme values.
If your data has tail problems, heavy or light tails relative to a normal distribution, Anderson-Darling is more likely to detect them than the K-S test. In R, use nortest::ad.test(my_data).
The test produces an A-squared statistic. Critical values for the Anderson-Darling test depend on the significance level you choose. At alpha 0.05, the critical value is approximately 0.787 for testing normality.
Other Normality Tests
The D’Agostino-Pearson test combines tests for skewness and kurtosis into a single measure of normality. It works well as a comprehensive check because it evaluates whether the overall shape deviates from normal rather than focusing on one aspect.
The Jarque-Bera test also uses skewness and kurtosis, and it is popular in econometrics and financial analysis. It uses a test statistic based on how far your data’s skewness and kurtosis deviate from the values expected under normality, which are 0 and 3 respectively.
The Cramer-von Mises criterion is another option, though it is less commonly used in practice. It is based on the squared difference between the empirical and theoretical cumulative distribution functions.
Comparing the Tests
For sample sizes under 50, use Shapiro-Wilk. It has the highest statistical power in this range. For moderate samples between 50 and several thousand, Shapiro-Wilk and Anderson-Darling both perform well.
For very large samples above 2,000, be cautious with all formal tests. They become overly sensitive, meaning they will flag trivially small deviations from normality as statistically significant. At that scale, visual inspection and practical judgment matter more than p-values.
Reddit users in r/statistics frequently describe the frustration of having a dataset with 700 or more observations where Shapiro-Wilk rejects normality even though the histogram looks perfectly bell-shaped. This is the large-sample sensitivity problem, and it is well documented in statistical literature.
How to Interpret Normality Test Results and P-Values
Every formal normality test follows the same hypothesis testing framework. The null hypothesis states that your data was drawn from a normal distribution. The alternative hypothesis states that it was not.
This means a non-significant result is actually what you want. If the p-value is greater than your alpha level, typically 0.05, you fail to reject the null hypothesis. Your data is consistent with a normal distribution.
If the p-value is less than 0.05, you reject the null hypothesis. Your data significantly deviates from normal, and you should consider data transformation or non-parametric alternatives.
Here is the critical mistake to avoid. A p-value above 0.05 does not prove your data is normal. It only means you do not have enough evidence to conclude it is not normal. With small samples, you may simply lack the power to detect real departures from normality.
Conversely, with large samples, you get the opposite problem. A sample of 500 observations can produce a p-value below 0.05 even when the data is practically normal for all analytical purposes. The test detects deviations so small they have no real impact on your parametric tests.
This is why I always recommend combining visual inspection with statistical testing. If your QQ plot looks like a clean straight line but Shapiro-Wilk returns p = 0.03 with a sample of 800, the visual evidence should carry more weight than the p-value.
Choose your alpha level thoughtfully. The conventional 0.05 threshold works for most situations. Some researchers use a stricter 0.01 for large samples to reduce false alarms. Others use 0.10 for small samples to increase sensitivity.
Step-by-Step Procedure to Test Normality
Following a consistent procedure ensures you never skip a critical step. Here is the workflow I use for every normality assessment, refined over years of statistical consulting.
Step 1: Clean and organize your data. Remove data entry errors, verify measurement units, and identify any legitimate outliers. Document any exclusions you make.
Step 2: Calculate descriptive statistics. Compute the mean, median, standard deviation, skewness, and kurtosis. If skewness is between -1 and +1 and kurtosis is between -2 and +2, your data is in the acceptable range for many parametric tests.
Step 3: Create visual displays. Generate a histogram and a QQ plot at minimum. A box plot adds outlier detection. Examine these plots carefully before running any formal tests.
Step 4: Select and run the appropriate statistical test. Use Shapiro-Wilk for samples under 50, and either Shapiro-Wilk or Anderson-Darling for larger samples. If testing residuals from a regression or ANOVA model, extract the residuals first and test those.
Step 5: Interpret results holistically. Never rely on a p-value alone. Combine the test result with your visual inspection and descriptive statistics. A single source of evidence is never sufficient.
Step 6: Document your decision. Record which test you used, the sample size, the test statistic, the p-value, and your visual assessment. This documentation matters for reproducibility and peer review.
How to Check Normality in Excel
Excel does not have built-in normality tests like Shapiro-Wilk or Kolmogorov-Smirnov. However, you can perform a meaningful normality assessment using a combination of visual tools and descriptive statistics.
Creating a histogram in Excel: Select your data, go to Insert, click the Statistics Chart icon, and choose Histogram. Adjust the bin width until the chart shows a clear shape. For normally distributed data, you should see a symmetric bell-like pattern.
Calculating skewness and kurtosis: Use the formula =SKEW(A2:A100) for skewness and =KURT(A2:A100) for kurtosis. Skewness near zero and kurtosis near zero (Excel reports excess kurtosis, so zero means normal) indicate approximate normality.
Building a QQ plot in Excel: This requires a few steps. First, rank your data from smallest to largest. Second, calculate the percentile for each value using (rank - 0.5) / n. Third, use NORM.INV(percentile, mean, standard_dev) to get the expected normal values. Fourth, create a scatter plot of actual values against expected values.
If the scatter plot forms a straight line, your data approximates a normal distribution. This is a manual process but gives you the same visual information as a QQ plot from dedicated statistical software.
Using the Data Analysis ToolPak: Enable this add-in from File, Options, Add-ins. Then use Data, Data Analysis, Descriptive Statistics to get a full summary including skewness, kurtosis, confidence intervals, and standard error.
For formal Shapiro-Wilk testing in Excel, you would need to implement the algorithm manually or use a VBA macro. Most analysts at this point switch to R, Python, or SPSS for formal testing while keeping Excel for data management and visualization.
What to Do When Your Data Fails the Normality Test
Failing a normality test is not the end of your analysis. You have several powerful options, and the right choice depends on why your data is non-normal and what analysis you planned to run.
Data Transformation
Transformation applies a mathematical function to every data point to make the distribution more normal. The most common transformations are log, square root, and inverse.
Log transformation works well for right-skewed data, especially when values span multiple orders of magnitude. Income, reaction times, and biological concentrations often respond well to log transformation. Use natural log ln(x) or log base 10.
Square root transformation is gentler than log transformation and works for count data. If your data includes zeros, use sqrt(x + 0.5) to avoid undefined values.
The Box-Cox transformation automatically finds the optimal power transformation for your data. It tests a range of lambda values and selects the one that best normalizes the distribution. In R, use MASS::boxcox(lm(my_data ~ 1)) to find the optimal lambda.
After applying any transformation, re-test for normality. Sometimes one transformation fixes the problem. Sometimes you need to try a different approach entirely.
Non-Parametric Alternatives
If transformation does not work or is not appropriate for your research question, switch to a non-parametric test. These tests do not assume normality and use ranks rather than raw values.
For comparing two independent groups, use the Mann-Whitney U test instead of the independent t-test. For paired data, use the Wilcoxon signed-rank test. For comparing three or more groups, use the Kruskal-Wallis test instead of one-way ANOVA.
For correlation, use Spearman’s rank correlation instead of Pearson. For regression, consider robust regression methods or generalized linear models that accommodate different distributions.
Non-parametric tests are slightly less powerful than their parametric counterparts when data actually is normal. But when normality fails, they are the correct and defensible choice.
When Transformations Help vs When to Switch Tests
Moderate skewness often responds well to transformation. If your data is log-normal or mildly right-skewed, a log transform may solve the problem cleanly.
Severely non-normal data with extreme outliers, heavy bimodality, or categorical underlying distributions will resist transformation. In these cases, switch to non-parametric tests rather than forcing a transformation.
Bimodal distributions are a special case. If your data has two peaks, no transformation will fix it. You likely have two subgroups mixed together, and the solution is to identify and separate those groups rather than transform the combined data.
Common Mistakes in Normality Testing
Even experienced analysts make errors in normality assessment. Here are the most common mistakes I encounter, along with how to avoid them.
Testing raw data instead of residuals for regression and ANOVA. The normality assumption for these models applies to residuals, not the dependent variable. Always extract and test residuals after fitting your model.
Over-relying on p-values with large samples. With 500 or more observations, normality tests flag trivially small deviations. Always pair p-values with visual inspection for large datasets.
Ignoring visual inspection entirely. Some analysts run a test, read the p-value, and move on. Visual plots reveal problems that p-values miss, including outliers, bimodality, and specific types of tail deviation.
Testing combined groups when groups should be tested separately. If you plan to compare groups using t-tests or ANOVA, test normality within each group, not on the combined dataset. The combined data may look non-normal even when each group is perfectly normal.
Confusing approximate normality with perfect normality. No real dataset is perfectly normal. The question is whether your data is close enough for parametric tests to work correctly. Visual similarity to a bell curve plus a non-significant test result is usually sufficient.
Forgetting to check assumptions beyond normality. Normality is one of several assumptions. Homogeneity of variance, independence of observations, and linearity may also apply depending on the test. Check all relevant assumptions, not just normality.
FAQs
How to determine if your data is normally distributed in Excel?
Create a histogram to visually check for a bell-shaped curve, then calculate skewness using =SKEW(range) and kurtosis using =KURT(range). For a QQ plot, rank your data, calculate percentiles, use NORM.INV to get expected normal values, and create a scatter plot. Excel does not have built-in formal normality tests like Shapiro-Wilk, so use visual methods and descriptive statistics or export your data to R or SPSS for formal testing.
Does ANOVA test for normality?
No, ANOVA does not test for normality. ANOVA assumes that the residuals of your data are normally distributed, but it does not verify this assumption itself. You must check normality separately before running ANOVA by testing the residuals, typically using a Shapiro-Wilk test and examining a QQ plot of the residual values.
How to determine if data is approximately normally distributed?
Combine visual inspection with statistical testing. Create a histogram to check for a symmetric bell shape, and a QQ plot to see if points fall along a straight line. Then run a Shapiro-Wilk or Anderson-Darling test. If the p-value is above 0.05 and the visual plots look reasonably normal, your data is approximately normally distributed for practical purposes.
How to do Shapiro-Wilk test for normality?
In R, run shapiro.test(your_data) to get the W statistic and p-value. In Python, use scipy.stats.shapiro(your_data). In SPSS, use Analyze, Descriptive Statistics, Explore, and the Shapiro-Wilk result appears in the Tests of Normality table. A p-value above 0.05 means your data is consistent with a normal distribution. A p-value below 0.05 means your data significantly deviates from normal.
What is the best test for normality?
Shapiro-Wilk is widely considered the most powerful normality test for sample sizes under 50 and remains effective up to about 2,000 observations. For very large samples, Anderson-Darling is a strong alternative because it weights tail deviations more heavily. The Kolmogorov-Smirnov test is generally less powerful and should be used with the Lilliefors correction when testing against an estimated normal distribution.
What sample size do I need for a normality test?
You need at least 8 observations for Shapiro-Wilk to produce a result, but the test has very low power below 20 observations. Between 20 and 50 observations is the sweet spot where Shapiro-Wilk performs best. For samples above 2,000, all normality tests become overly sensitive and may reject normality for trivially small deviations. In those cases, rely more on visual inspection than p-values.
Conclusion
Knowing how to check whether your data is normally distributed is essential before running any parametric statistical test. The process involves combining visual methods like histograms and QQ plots with formal tests like Shapiro-Wilk and Anderson-Darling.
Start with visual inspection, then confirm what you see with an appropriate statistical test based on your sample size. Interpret p-values carefully, especially with large samples where tests become overly sensitive to trivial deviations.
If your data fails normality, try transformations like log or Box-Cox first. If transformation does not work, switch to the appropriate non-parametric alternative. Always document your testing process for reproducibility.
The most important takeaway is this. Never run a parametric test without checking the normality assumption first. A few minutes of testing can save you from publishing results that do not hold up under scrutiny.
For your next analysis, follow the six-step procedure outlined above. Clean your data, check descriptive statistics, create visual plots, run the right test, interpret holistically, and document everything. That workflow will serve you across every statistical project in 2026 and beyond.