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. 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