What is the average difference between the two genders

Assignment Help Other Subject

Reference no: EM132227594

Assignment -

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.

Attachment:- Assignment Files.rar

Reference no: EM132227594

Questions Cloud

What is necessary to manage diversity : What is necessary to maintain an effective workforce? What is necessary to manage diversity?

Compare the differentiated practice competencies : Compare and contrast the differentiated practice competencies between an associate and baccalaureate education in nursing. Explain how scope of practice changes

Wal-mart contribute and detract from communities : How does Wal-Mart contribute and detract from communities in which it operates stores? Why do retail managers need to consider ethical issues in making decision

What are the legal and ethical considerations of the trend : Select one of the following trends and discuss your understanding of this trend in healthcare and its potential impact on your practice as a nurse.

What is the average difference between the two genders : On average, are husbands or wives taller? What is the average difference in millimeters between the two genders? Explain your answer

What are the primary characteristics of each : Compare and contrast servant leadership with another leadership style or theory such as transformational leadership. What are the primary characteristics.

Services different from marketing of tangible products : Are marketing of services different from marketing of tangible products? What is free speech? What is symbolic speech?

Account such things as types of learning activities : How you will organised learning to use the system taking into account such things as types of learning activities,

Employment practices liability insurance : Identify and describe two specific laws that drive the need for employers to consider EPL (Employment Practices Liability) insurance.

User Account

All Pages