Aggregating Data

Do you require help with your paper? Use our custom writing service to achieve better grades and meet your deadlines. Trust our team of writing experts with your work today, and enjoy peace of mind.


Order a Similar Paper Order a Different Paper

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
    difference in millimeters between the two genders? Explain your answer.
  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:

Your manager has requested some additional information from you
regarding the data. Specifically, you have been asked to calculate the
differences between “Male Heights” and “Female Heights.” Your manager is
only interested in married couples in which the husbands are taller
than their wives. Repeat the analyses requested in Part 1 for this new
dataset. What conclusions can be drawn here? Include discussion about
whether outliers exist in this dataset.

APA format is not required, but solid academic writing is expected.

This assignment uses a grading rubric. Please review the rubric prior
to beginning the assignment to become familiar with the expectations
for successful completion.

Writerbay.net

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed journal articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and PhD writers.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper