KIN 300 – Dr. Ernst
Worksheet 3 – Descriptive Statistics
Instructions:
You will use the data set (BMI Scores) provided below to create three tables (Data
Organization Table, Simple Frequency Distribution Table, Grouped Frequency
Distribution Table). You will use MS Excel to display your data. With all of your tables,
be sure to highlight and bold your titles and sums and add borders to the table. You will
create two charts: one column chart and one pie chart. You will also create two new
tables: a table with the Measures of Central Tendency and one with the Measures of
Variability.
Data Set: BMI Scores
The following data are BMI scores.
27, 21, 34, 32, 19, 28, 27, 33, 40, 32, 30, 22, 26, 30, 38, 18, 32, 24, 22, 30, 34, 18, 26, 24,
23, 19, 29, 20, 23, 35, 38, 27, 33, 42, 34, 32, 37, 27, 25, 23, 44, 20, 22, 22, 27, 31, 22, 28,
31, 27, 22, 24, 20
Measures of Central Tendency: Mean, Median and Mode
1. Find the mean, median and mode for the BMI Scores data set. You will need to show
where these statistics are on your tables by bolding and/or shading the cells which
contain these statistics. You will also calculate the mean for the data set in the cell
below the sum of scores in the Data Organization Table.
EXAMPLE
The following example data are exam scores from an exam that is worth 50 pts.
44, 39, 47, 42, 41, 50, 29, 33, 44, 50, 32,
Data Organization Table with Median Identified
Data Organization Table
Sub # Raw Data D-Order
1 44 50
2 39 50
3 47 47
4 42 44
5 41 44
6 50 42 Median
7 29 41
8 33 39
9 44 33
10 50 32
11 32 29
Sum = 451 451
Mean = 41
Simple Frequency Distribution Table with Mode Identified
Simple Freq Dist Table
X f X*f
Mode 50 2 100
47 1 47
Mode 44 2 88
42 1 42
41 1 41
39 1 39
33 1 33
32 1 32
29 1 29
Sum = 11 451
2. Create a Grouped Frequency Distribution Table. For your BMI Scores use the
following BMI Categories to form your groups.
< 18.5 Underweight, 18.5 – 24.9 Normal, 25 – 29.9 Overweight, > 30 Obese
Group Freq Dist Table
Group f
50-45 3
44-40 4
39-35 1
34-30 2
29-0 1
Sum = 11
Measures of Variability: Range, Variance and Standard Deviation
3. Calculate the Range for the BMI Scores data set.
4. Create two new tables. One will include all of the measures of Central Tendency
(mean, median and mode) and the other will include all of the measures of variability
(range, variance and standard deviation). For the second table, you will only have the
range calculated for now, but please include all three statistics in the table so that you
can add in the variance and standard deviation later (see tables below).
Meas of Central Tend Measures of Variability
Mean 41 Range 22
Median 42 Variance
Mode 50, 44 Std Dev
