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

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

Everything we know about life comes from studying our own planet.

Just Click on Below Link To Download This Course: https://bit.ly/3kzqojI BIO 101 MODULE 1 DISCUSSION Discussion: Life’s Extreme Environments Discussion Topic Everything we know about life comes from studying our own planet. Recent discoveries about life forms in extreme environments have renewed scientists’ interest in looking for life elsewhere. Organisms that thrive in a wide variety of harsh conditions –called extremophiles—are broadening scientists’ understanding of the diverse environmental conditions life can withstand. Scientists have had to modify their theories and expand their view of what types of environments are habitable based on the new information presented by the existence of extremophiles. Watch the following 1.5 minute NOVA video on extremophiles. Complete your initial post by answering the questions below: Life’s Extreme Environments https://www.pbslearningmedia.org/resource/nvfl.sci.space.extremophiles/lifes-extreme-environments/#.WjLURN-nGM8 ...
Post a Comment
Read more

SPD 320 Topic 7 Benchmark Comprehensive Report Summary and Recommendations GCU

Just Click on Below Link To Download This Course: https://mindsblow.com/product/spd-320-topic-7-benchmark-comprehensive-report-summary-recommendations-gcu/ SPD 320 Topic 7 Benchmark Comprehensive Report Summary and Recommendations GCU After formal assessments for determining eligibility under IDEA’s 13 disability categories are completed, school-based specialists are charged with summarizing the results to aid team decision making. In turn, specific recommendations are made to ensure school staff and family members fully understand how programming and supports should be implemented to address documented student needs. It is vital that teachers understand how to review assessment results and be an active team member in collaborating with families around the specific recommendations to be implemented. Teachers must be able to advocate for necessary programming and supports while still addressing the questions/needs of family members. Review the “Report of Psychological Assessment...
Post a Comment
Read more