Compute a Descriptive Statistic

Compute a Descriptive Statistic

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.

"Looking for a Similar Assignment? Order now and Get a Discount!

Frequently Asked Questions

A Page will cost you $12, however, this varies with your deadline. 

When you pay us, you are paying for a near perfect paper and the time convenience. 

Upon completion, we will send the paper to via email and in the format you prefer (word, pdf or ppt). 

Yes, we have an unlimited revision policy. If you need a comma removed, we will do that for you in less than 6 hours. 

As you Share your instructions with us, there’s a section that allows you to attach as any files. 

Yes, through email and messages, we will keep you updated on the progress of your paper. 

Start by filling this short order form thestudycorp.com/order 

And then follow the progressive flow. 

Having an issue, chat with us here

Regards,

James from thestudycorp.com