Transcript Applied Business Statistics Methods and Excel

Part 2 Exploratory Data Analysis
Chapter 3 Describing Data: Numeric
Descriptive Statistics
© Juta and Company Ltd, 2012
Applied Business Statistics Methods and
Excel-Based Applications 3rd Edition
1
• Introduction
– Location
– Dispersion
– Skewness
• Central Location Measures
– Arithmetic Mean (Average)
– Median
© Juta and Company Ltd, 2012
Applied Business Statistics Methods and
Excel-Based Applications 3rd Edition
2
• Central Location Measures continued
– Mode
– Which central location
measure is best?
© Juta and Company Ltd, 2012
Applied Business Statistics Methods and
Excel-Based Applications 3rd Edition
3
• Non-central Location Measures
– Quartiles
– Percentiles
© Juta and Company Ltd, 2012
Applied Business Statistics Methods and
Excel-Based Applications 3rd Edition
5
© Juta and Company Ltd, 2012
Applied Business Statistics Methods and
Excel-Based Applications 3rd Edition
6
• Measures of Dispersion
– Range
– Variance
© Juta and Company Ltd, 2012
Applied Business Statistics Methods and
Excel-Based Applications 3rd Edition
7
• Measures of Dispersion continued
– Standard Deviation
– Coefficient of Variation
© Juta and Company Ltd, 2012
Applied Business Statistics Methods and
Excel-Based Applications 3rd Edition
8
• Measure of Skewness
– Symmetrical Distribution
– Positively Skewed Distribution
© Juta and Company Ltd, 2012
Applied Business Statistics Methods and
Excel-Based Applications 3rd Edition
9
• Measure of Skewness continued
– Negatively Skewed Distribution
– Pearson’s Coefficient of Skewness
© Juta and Company Ltd, 2012
Applied Business Statistics Methods and
Excel-Based Applications 3rd Edition
10
• The Box Plot
© Juta and Company Ltd, 2012
Applied Business Statistics Methods and
Excel-Based Applications 3rd Edition
11
• Choosing Valid Descriptive Statistics Measures
• Using Excel (2007) to Compute Descriptive
Statistics
– Function Keys
– Data Analysis Add-in
© Juta and Company Ltd, 2012
Applied Business Statistics Methods and
Excel-Based Applications 3rd Edition
12
© Juta and Company Ltd, 2012
Applied Business Statistics Methods and
Excel-Based Applications 3rd Edition
13
• Summary
• Exercises
© Juta and Company Ltd, 2012
Applied Business Statistics Methods and
Excel-Based Applications 3rd Edition
14
End of Chapter 3
Applied Business Statistics Methods
and Excel-based Applications
Third edition
TREVOR WEGNER
ISBN 978-0-70217-774-3
© Juta and Company Ltd, 2012
Applied Business Statistics Methods and
Excel-Based Applications 3rd Edition
15