# Aggregating Data

For this assignment, you will use the “Heights” dataset. In the
dataset, the heights (in mm) of n = 199 married couples are recorded.
The data comes from a random sample from the much larger population of
married couples. Complete each of the steps below to create a visual
representation of the dataset.

Part 1:

Using Excel functions, calculate the following summary values for each of the three variables:

1. Minimum
2. First quartile
3. Second quartile (Median)
4. Third quartile
5. Maximum
6. Mean
7. Range
8. Sample standard deviation
9. Sample variance
10. Coefficient of variation

Part 2:

Address each of the following questions in a written Word document.

1. On average, are husbands or wives taller? What is the average
2. How would you interpret the median heights?
3. Compare the means and the medians for each dataset. What initial
conclusions can be made here regarding the “contour” of each dataset?
4. Compare the standard deviation values. Which dataset (husbands or
wives) has the most dispersion? What does your conclusion suggest?
5. Given the answers in question 1, compare the variability of heights
between husbands and wives. Which partner type is more likely to have
extremely tall individuals (outliers)?
6. Interpret the % coefficient of variation.

Part 3: