Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
"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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple choice test data - How do I get Excel to deal with one row of data? | Excel Discussion (Misc queries) | |||
Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) | |||
how to do normality test in excel | Excel Worksheet Functions | |||
Tests for Normality in Excel | Excel Discussion (Misc queries) | |||
how do I generate test data | New Users to Excel |