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. Question 2

Suppose you wanted to estimate the average household income of all Grand Canyon University (GCU) students. To expedite the process, you only gather household income data from all your friends who major in business at GCU. You then calculate the average income among your friends and report that it represents the average income of all GCU students. Is this a good approach? If not, how would you gather data to derive a better estimate? Explain your answer. Question 3 Income data typically have some outliers. For example, Tim Cook, CEO of Apple, Inc., had a salary of about 400 million in 2011. Suppose you had a data set of incomes in 2011 for all GCU faculty and Tim Cook. Which measure of central tendency would you use when reporting on the incomes in your data set if you do not want outliers to have much effect? Explain your answer.

NEED TO MAKE AN ORDER? HERE IS HOW IT WORKS

Need an answer from similar question?Click here and get a solution now

You have just landed to the most confidential, trustful essay writing service to order the paper from. We have a dedicated team of professional writers who will assist you with any kind of assignment that you have. Your work is handled confidentially with a specific writer who ensures you are satisfied. Be assured of quality, unique and price friendly task delivered in good time when you place an order at our website. We have a team of dedicated writers with degrees from all spheres of study. We readily accept all types of essays and we assure you of content that will meet your expectations. Our staff can be reached  via live chat, email or by phone at any given time with prompt response.  

Prices starting at:

High school	Undergrad.(yrs 1-2)	Undergrad.(yrs 3-4)	Master’s	Doctoral
$10 / page	$10/ page	$12/ page	$15 / page	$17/ page
Note: The prices in the table above are applicable to orders completed within 14 days. Kindly see the full price table for more prices..

We urge you to provide as much information as possible to avoid many revisions. Set your deadline, choose your level, give payment information and relax while you track your work. We will deliver your paper on time. Are you in a quagmire and you are unable to complete your assignments? Do you doubt yourself on the quality of the essay you have written? Myprivatementor.com  is here to assist you. We will offer you unmatched quality that is plagiarism free. Place an order at myprivatementor.com  for guaranteed  high grades.