Essay Writer » Essay Blog » Research Paper Help » Descriptive statistics II

Descriptive statistics II

Reading about descriptive statistics is one thing. Actually using software to compute them requires different skill sets. This assignment is designed to give you the opportunity to practice using Microsoft Excel to compute a variety of descriptive statistics for the data set provided below. Assume that you want to describe your office coworkers in terms of gender, height, and weight. The following is the data you collected:

GenderHeight (rounded to the nearest inch)Weight (rounded to the nearest pound)
M53156
F46131
M54123
M44142
F56156
F76171
F87143
F65135
F45138
F44114
M57154
F68166
M65153
M66140
F54143
F66156
M51173
M58143
M49161
F48131

For each variable, using Microsoft Excel, compute the mean, the median, and the mode (if appropriate).

For each variable, using Microsoft Excel, compute the range and standard deviation (if appropriate).

Using Microsoft Excel, create a visual display for each variable (bar graph or histogram) as appropriate.

Attach a document with your combined Microsoft Excel printout results and graphs.

In the body of your main post, in paragraph form and in your own words, describe your coworkers on the basis of the data you collected. Additionally, share your reflections of your experience conducting these descriptive analyses. If you are having difficulty using Microsoft Excel, this is a chance to start a discussion with your instructor and classmates to seek help, guidance, and tips.

 

 

Last Updated on March 1, 2018

Don`t copy text!
Scroll to Top