Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Tests for Normality in Excel
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 |
#2
|
|||
|
|||
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" wrote in message ... 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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |