Microsoft Office Tutorials and References
In Depth Information
l The Descriptive
Statistics dialog box
appears.
5
Click and drag the cells
you want to describe,
or type the cell range.
5
6
Click if your data has
labels (
9
changes to
).
6
7
8
7
Click to select where
you want the output
to appear (
changes
to ).
l If necessary, type a
location.
8
Click Summary Statistics (
changes
to ).
l Optionally, you can include other
statistics.
9
Click OK.
The statistics appear in a boxed area.
l To see all your statistics, widen the
column heads by clicking the border
between column letters and dragging.
Did You Know?
Descriptive statistics are
available as Excel functions.
Excel Functions
Descriptive
Excel
Descriptive
Excel
Statistic
Function
Statistic
Function
Mean
Skewness
AVERAGE()
SKEW()
Standard Error
Range
STEYX()
MAX()–MIN()
Median
Minimum
MEDIAN()
MIN()
Mode
Maximum
MODE()
MAX()
Standard Deviation
Sum
STDEV()
SUM()
Sample Variance
Count
VAR()
COUNT()
Kurtosis
KURT()
Chapter 5: Explore the Patterns in Your Data
125
 
Search JabSto ::




Custom Search