Aggregating Data

User Generated

ufreenab10

Business Finance

Description

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.

Unformatted Attachment Preview

female.height male.height 1590 1809 1560 1841 1620 1659 1540 1779 1420 1616 1660 1695 1610 1730 1635 1753 1580 1740 1610 1685 1590 1735 1610 1713 1700 1736 1522 1715 1680 1799 1680 1785 1630 1758 1570 1729 1720 1720 1740 1810 1600 1725 1689 1764 1600 1683 1550 1585 1540 1684 1640 1674 1640 1724 1630 1630 1560 1855 1652 1796 1580 1700 1570 1765 1590 1700 1650 1721 1591 1823 1670 1829 1600 1710 1610 1745 1610 1698 1670 1853 1510 1610 1520 1680 1620 1809 1530 1580 1451 1600 1570 1585 1580 1590 1670 1630 1510 1560 1660 1610 1440 1570 1670 1635 1670 1730 1560 1590 1600 1490 1660 1504 1580 1500 1640 1650 1620 1550 1640 1560 1552 1600 1545 1570 1550 1600 1660 1640 1670 1560 1760 1640 1600 1571 1550 1570 1590 1650 1690 1705 1675 1735 1686 1768 1721 1754 1739 1699 1825 1740 1704 1719 1731 1679 1755 1713 1723 1783 1585 1749 1710 1724 1620 1764 1791 1795 1738 1639 1734 1695 1666 1745 1775 1669 1700 1804 1700 1664 1753 1788 1765 1680 1715 1755 1764 1793 1580 1590 1510 1600 1660 1700 1530 1490 1580 1500 1600 1570 1620 1410 1560 1590 1710 1580 1690 1610 1660 1610 1590 1530 1690 1600 1693 1580 1636 1670 1600 1570 1700 1740 1540 1555 1614 1530 1690 1590 1610 1670 1690 1550 1650 1540 1660 1731 1713 1725 1828 1735 1760 1685 1685 1559 1705 1723 1700 1660 1681 1803 1866 1884 1705 1780 1801 1795 1669 1708 1691 1825 1760 1949 1685 1806 1905 1739 1736 1845 1868 1765 1736 1741 1720 1871 1720 1629 1624 1653 1786 1620 1695 1674 1620 1630 1610 1540 1610 1630 1530 1520 1544 1570 1580 1550 1570 1521 1580 1630 1650 1640 1650 1520 1620 1744 1647 1615 1680 1670 1620 1570 1660 1550 1590 1620 1560 1670 1650 1539 1470 1580 1670 1520 1620 1710 1530 1630 1720 1570 1560 1864 1643 1705 1736 1691 1753 1680 1724 1710 1638 1725 1725 1630 1810 1774 1771 1815 1575 1729 1749 1705 1875 1784 1584 1774 1658 1790 1798 1824 1796 1725 1685 1769 1749 1716 1664 1773 1760 1725 1645 1694 1851 1691 1880 1835 1730 1644 1650 1635 1590 1590 1566 1590 1662 1550 1570 1560 1630 1530 1723 1758 1718 1723 1708 1786 1764 1675 1641 1743 1823 1720 20.0 % Part 3 Excel Spreadsheet Calculations Excel spreadsheet calculations specified in Part 3 are not included. Excel spreadsheet calculations specified in Part 3 are incomplete or incorrect. Excel spreadsheet calculations specified in Part 3 are partially complete and correct. Excel spreadsheet calculations specified in Part 3 are mostly complete and correct. Excel spreadsheet calculations specified in Part 3 are complete and correct. 25.0 % Part 3 Data Analysis Questions Answers to data analysis questions are not included. Answers to data analysis questions are incomplete or incorrect. Answers to data analysis questions are included but contain errors or inaccuracies. Answers to data analysis questions are mostly complete and accurate. Answers to data analysis questions are complete and accurate, 10.0 % Mechanics of Writing (includes spelling, punctuation, grammar, language use) Surface errors are pervasive enough that they impede communication of meaning. Inappropriate word choice or sentence construction is used. Writer is clearly in command of standard, written, academic English. Frequent and repetitive mechanical errors distract the reader. Inconsistencies in language choice (register) or word choice are present. Sentence structure is correct but not varied. Some mechanical errors or typos are present, but they are not overly distracting to the reader. Correct and varied sentence structure and audience- appropriate language are employed. Prose is largely free of mechanical errors, although a few may be present. The writer uses a variety of effective sentence structures and figures of speech. Total Weightage 100% Aggregating Data 1 Unsatisfactory 0.00% 2 Less than Satisfactory 74.00% 3 Satisfactory 79.00% 4 Good 87.00% 5 Excellent 100.00% 100.0 % Content 20.0 % Part 1 Excel Spreadsheet Calculations Excel spreadsheet calculations specified in Part 1 are not included. Excel spreadsheet calculations specified in Part 1 are incomplete or incorrect. Excel spreadsheet calculations specified in Part 1 are partially complete and correct. Excel spreadsheet calculations specified in Part 1 are mostly complete and correct. Excel spreadsheet calculations specified in Part 1 are complete and correct. 25.0 % Part 2 Data Analysis Questions Answers to data analysis questions are not included. Answers to data analysis questions are incomplete or incorrect. Answers to data analysis questions are included but contain errors or inaccuracies. Answers to data analysis questions are mostly complete and accurate. Answers to data analysis questions are complete and accurate. 20.0 % Part 3 Excel Spreadsheet Calculations Excel spreadsheet calculations specified in Part 3 are not included. Excel spreadsheet calculations specified in Part 3 are incomplete or incorrect. Excel spreadsheet calculations specified in Part 3 are partially complete and correct. Excel spreadsheet calculations specified in Part 3 are mostly complete and correct. Excel spreadsheet calculations specified in Part 3 are complete and correct.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

...


Anonymous
Great study resource, helped me a lot.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags