Skip to main content
1 of 2
Eudora
  • 281
  • 1
  • 2
  • 4

Check for Normal Distribution in Excel

I'm looking for a way to check a data set for normality in Excel, just to verify that the requirements for using a t-test are being met.

For the right tail, is it appropriate to just calculate a mean and standard deviation, add 1, 2 & 3 standard deviations from the mean to create a range then compare that to the normal 68/95/99.7 for the standard normal distribution after using the norm.dist function in excel to test each standard deviation value.

Or is there a better way to test for normality?

Eudora
  • 281
  • 1
  • 2
  • 4