Practice with Descriptive Statistics

latice1

Main
Similar Questions

Home >Homework Answsers >Mathematics homework help >Numerical analysis homework help

Assignment 1: Practice with Descriptive Statistics

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:

Gender	Height (rounded to the nearest inch)	Weight (rounded to the nearest pound)
M	53	156
F	46	131
M	54	123
M	44	142
F	56	156
F	76	171
F	87	143
F	65	135
F	45	138
F	44	114
M	57	154
F	68	166
M	65	153
M	66	140
F	54	143
F	66	156
M	51	173
M	58	143
M	49	161
F	48	131

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.

Submission Details:

By Saturday, February 20, 2016, post your response to the Discussion Area.
By Wednesday, February 24, 2016, read through all classmates' posts and respond to at least two. Acknowledging that it can be difficult to generate a rich discussion around a statistical procedure discussion question, here are a few potential topics of discussion you might want to keep in mind as you respond to each other:

Under what conditions would you use a median rather than the mean as a measure of central tendency?
Why is the range the most convenient measure of dispersion and the most imprecise measure of variability?
Why is it important to consider the type of data when computing descriptive statistics?
Why do we use a standard deviation instead of variance?
Is it helpful to understand the equations, or do you just need to know how to plug the formula into Microsoft Excel?