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