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

Full Course Discussions GCU SPD 300

Just Click on Below Link To Download This Course: http://bit.ly/37qR3q6 SPD 300 Full Course Discussions GCU SPD 300 Topic 1 DQ 1 IDEA emphasizes the value of inclusion for students with disabilities in the general education classroom. What are some positive effects of inclusion for both students with and without disabilities? SPD 300 Topic 1 DQ 2 Review your state’s department of education website. Identify and describe three resources from the website that are available to schools and teachers in your state regarding compliance with IDEA. How do these resources specifically support students with disabilities and their families? What is your opinion of the site? Was it easy to find? Is it easy to navigate? Do you think families will find it helpful? Why or why not? SPD 300 Topic 2 DQ 1 Under IDEA, consider the rights afforded to students with disabilities who attend private schools and who are eligible for special education services. How do they compare to those ...
Post a Comment
Read more