Skip to main content
Cross Validated

Return to Question

Question Protected by Glen_b
added 1 characters in body; edited tags; edited title
Source Link
Jeromy Anglim
Jeromy Anglim
  • 45.7k
  • 24
  • 157
  • 259

Check How to check for Normal Distribution innormal distribution using Excel for performing a t-test?

I'm looking for a way to check a data set for normality in Excel, justI want to verify that the requirements for using a t-test are being metknow how 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?

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?

How to check for normal distribution using Excel for performing a t-test?

I want to know how 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?

Source Link
Eudora
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?