Presenting Data in Tables and Charts

1
Statistics for Managers Using Microsoft Excel
Chapter 2 Presenting Data in Tables and Charts
2
Organizing Numerical Data
Numerical Data
41, 24, 32, 26, 27, 27, 30, 24, 38, 21
Frequency Distributions Cumulative Distributions
Ordered Array
21, 24, 24, 26, 27, 27, 30, 32, 38, 41
Ogive
Histograms
Stem and Leaf Display
2 144677 3 028 4 1
Polygons
Tables
3
Organizing Numerical Data
Numerical Data
Frequency Distributions Cumulative Distributions
Ordered Array
Histograms
Tables
4
Tabulating Numerical Data

• Sort Raw Data in Ascending Order
• Find Range
• Select Number of Classes
• Compute Class Interval (width)
• Determine Class Boundaries (limits)
• Compute Class Midpoints
• Count Observations Assign to Classes OR use
  Excel to crunch the numbers.