MIS 660 Topic 1 Aggregating Data GCU

Description

MIS 660 Topic 1 Aggregating Data GCU

The purpose of this assignment is to use a spreadsheet to create a visual representation of a data set.

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.

You are not required to submit this assignment to LopesWrite.

Course Tutor helps in providing the best essay writing service. If you need 100% original papers for MIS 660 Topic 1 Aggregating Data GCU, then contact us through call or live chat.

MIS 660 Topic 1 Aggregating Data GCU

ACCT 553 DeVry, BIAM 500 DeVry, CIS 500 STR, CIS 558 STR, ENG 105 GCU, FIN 390 DeVry, FIN 504 GCU, HCA 545 GCU, HCA 699 GCU, HLT 306 GCU, HLT 362 GCU, HLT 555 GCU, HLT 610 GCU, HLT 665 GCU, HOSP 594 DeVry, HRM 600 DeVry, MAT 144 GCU, MGMT 600, MGT 599 STR, MGT 655 GCU, MKT 373 GCU, PSY 362 GCU, PSY 565 GCU, PSY 575 GCU, PSY 665 GCU, SOC 102 GCU, SOC 320 GCU, SOC 372 GCU, SOC 412 GCU, NSG 6440 SU, HIM 515 GCU, NSG 4029 SU, HIM 615 GCU, NSG 3029 SU, NSG 4055 SU, NSG 6630 SU, NSG 6005 SU, CRMJ 310, PSY 510 GCU, CRMJ 300 Devry, CRMJ 425, SPD 200 GCU, HLT 490 GCU ,ECH 340 GCU , ECH 440 GCU , ECH 355 GCU ,ECH 350 GCU ,LDR 461 GCU ,ECH 425 GCU ,REL 212 STR ,SCI 115 STR ,CIS 505 STR ,JUS 652 GCU, MGT 640 GCU, CIS 527 STR, SOC 436 GCU,ACC 502 GCU, FIN 504 GCU , MATH 260 DeVry ,ETHC 445 DeVry ,ECET 220 DeVry , CARD 405 DeVry, NETW 203 DeVry, NETW 205 DeVry, ECET 365 DeVry ,MATH 270 DeVry ,PHYS 310 DeVry, BIB 106 GCU ,CIS 512 STR ,SYM 506 GCU ,ECN 601 GCU  ,BIAM 570 DeVry, PSY 402 GCU , SOC 480 GCU , BIAM 530 DeVry,  DNP 810 GCU , DNP 820 GCU , DNP 825 GCU , ECN 450 GCU , DNP 830 GCU , LDR 804 GCU , MAT 105 GCU , ECS 501 GCU , ECS 555 GCU , TSL 552 GCU , ECS 560 GCU , NRS 493 GCU , ECS 570 GCU , BUS 352 GCU , MIS 660 GCU