Skip to main content

The purpose of this assignment is to use a...

Just Click on Below Link To Download This Course:

https://bit.ly/33VKYDr

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.

 

Download Now

 

 

Labels:

Comments

Post a Comment

Popular posts from this blog

Assignments GCU HCA 827 Full Course

Just Click on Below Link To Download This Course: http://bit.ly/2u6dNxJ HCA 827 Full Course Assignments GCU HCA 827 Topic 2 Change and the Learning Organization Health care leaders must embrace a lifestyle of change in order to create the culture of a learning organization that is amenable to and supportive of innovation, adaptation, and change. Rogers’ diffusion of innovation theory can be used to create a significant conceptual framework for change. In this assignment, you will describe how health care leaders can use Rogers’ theory to create the culture of a learning organization. General Requirements: Use the following information to ensure successful completion of the assignment: This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. Doctoral learners are required to use APA style for their writing assignments. The APA Style Guide is located in ...
Post a Comment
Read more

ESL 533 Advanced Methodologies of SEI GCU

Just Click on Below Link To Download This Course: https://bit.ly/39LWLal ESL 533 Advanced Methodologies of SEI GCU ESL 533 Full Course Discussions GCU ESL 533 Topic 1 Discussion 1 According to Jim Cummins, social language (BICS) takes 1-3 years while academic language (CALPS) is more difficult and takes 5-8 years to develop. How can teachers help English language learners develop academic language? How can teachers reach out to students who are in the Silent Period? ESL 533 Topic 1 Discussion 2 Based on key legislation pertaining to English language learners (ELLs) in your state, describe the characteristics of the English immersion program in terms of instructional strategies, time spent in the classroom with other ELL students, and time spent in regular classrooms with native speakers. You can find this information on the Department of Education website of your state. ESL 533 Topic 2 Discussion 1 Describe the difference between diagnostic, formative, and summative ass...
Post a Comment
Read more

There are many diseases that are caused by the malfunction of specific organelles.

Just Click on Below Link to Download This Course: https://bit.ly/3zHEiXr BIO 101 MODULE 2 DISCUSSION Discussion: Eukaryotic and Prokaryotic Cells Discussion Topic The cells in our body are complex cells called eukaryotic cells. Prokaryotic cells are very simple, like bacteria. Prokaryotic cells tend to be less organized and more primitive, whereas eukaryotic cells like our skin, liver, and brain cells benefit from the complexity of organization and compartmentalization. Although simple, prokaryotic cells like bacteria are not compartmentalized like human and animal cells, but they seem to function as they need to. Bacteria have been around for millions of years and survive in the harshest of conditions. Is being complex always beneficial? Use the search terms “eukaryotic” or “prokaryotic” at  The Scientist site  and find a recent discovery to share with your classmates. Summarize the article and compare/contrast the articles findings with those of your classmates. ...
Post a Comment
Read more