![]() |
Test for normality of data
I need to test a data set for normal distribution.
How do I do this? Also, is there a way to create a graph that will display both the test data set and a normal data set with the same mean and stdev? Thank you, Rob |
Test for normality of data
Hi, Look in help for Normdist Mike "Rob" wrote: I need to test a data set for normal distribution. How do I do this? Also, is there a way to create a graph that will display both the test data set and a normal data set with the same mean and stdev? Thank you, Rob |
Test for normality of data
Rob -
I need to test a data set for normal distribution. How do I do this? < For a "statistical inference" test, use the chi-square goodness-of-fit test. Search Google or Wikipedia. Also, is there a way to create a graph that will display both the test data set and a normal data set with the same mean and stdev? < My free Better Histogram add-in could display the test data, and it's possible to add a normal curve. For an example, see http://www.mikemiddleton.com/Histogr...ormalCurve.xls - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "Rob" wrote in message ... I need to test a data set for normal distribution. How do I do this? Also, is there a way to create a graph that will display both the test data set and a normal data set with the same mean and stdev? Thank you, Rob |
Test for normality of data
"Mike Middleton" wrote...
Rob *- I need to test a data set for normal distribution. How do I do this? For a "statistical inference" test, use the chi-square goodness- of-fit test. ... Wouldn't one also want to use a Kolmogorov-Smirnov test too? And for normality, wouldn't a quick (as in quick rejection) test for not normal be skewness and kurtosis substantially nonzero? |
All times are GMT +1. The time now is 02:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com