Are there any tests for Normality in Excel? I've used other statistical
packages and currently don't have access to them. Does Excel have this type
of capability and if it does, how do I use it?
Thanks,
Barb Reinhardt
Are there any tests for Normality in Excel? I've used other statistical
packages and currently don't have access to them. Does Excel have this type
of capability and if it does, how do I use it?
Thanks,
Barb Reinhardt
Barb,
The Analysis TookPak included with Excel has a
"Descriptive Statistics" function that generates information like
the following. The data was from a column of test scores.
You must first checkmark Analysis Tool Pak in Tools | Add-ins.
Regards,
Jim Cone
San Francisco, USA
'-------------------------------------
Mean 527.5502008
Standard Error 2.818282828
Median 528
Mode 558
Standard Deviation 88.94350581
Sample Variance 7910.947226
Kurtosis 0.013569105
Skewness 0.0683953
Range 553
Minimum 247
Maximum 800
Sum 525440
Count 996
Confidence Level (95.0%) 5.530465913
"Barb Reinhardt" <[email protected]>
wrote in message
news:[email protected]...
Are there any tests for Normality in Excel? I've used other statistical
packages and currently don't have access to them. Does Excel have this type
of capability and if it does, how do I use it?
Thanks,
Barb Reinhardt
Excel does not have built in tests for Normality, but it also is not a
statistical package (it is a spreadsheet that has some limited
statistical capabilities built in). There are some commercial
statistics Add-Ins that would cover this, or you could do a simple
Chi-Square goodness of fit test. If you want a full-blown statistics
package, R is free
www.r-project.org
Jerry
Barb Reinhardt wrote:
> Are there any tests for Normality in Excel? I've used other statistical
> packages and currently don't have access to them. Does Excel have this type
> of capability and if it does, how do I use it?
>
> Thanks,
> Barb Reinhardt
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks