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:MinimumFirst quartileSecond quartile (Median)Third quartileMaximumMeanRangeSample standard deviationSample varianceCoefficient of variationPart 2:Address each of the following questions in a written Word document.On average, are husbands or wives taller? What is the average
difference in millimeters between the two genders? Explain your answer.How would you interpret the median heights?Compare the means and the medians for each dataset. What initial
conclusions can be made here regarding the “contour” of each dataset?Compare the standard deviation values. Which dataset (husbands or
wives) has the most dispersion? What does your conclusion suggest?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)?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.
screen_shot_2018_05_04_at_4.39.12_am.png

screen_shot_2018_05_04_at_4.39.32_am.png

Don't use plagiarized sources. Get Your Custom Essay on
Aggregating Data
Just from $13/Page
Order Essay

mis_660_rs_heights.xlsx

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

Purchase answer to see full
attachment

GradeAcers
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.

Order your essay today and save 15% with the discount code DISCOUNT15