Help needed

Statistics help

· Reading about descriptive statistics is one thing. Actually using software to compute them requires skill and practice. This assignment is designed to give you an opportunity to practice using Microsoft Excel to compute a variety of descriptive statistics.

The data set provided is for members of a local fitness club and gives their gender, height, and weight.

M

M

F

156

F

F

F

F

F

44

M

F

M

65

M

F

54

143

F

66

156

M

M

143

M

F

131

Gender Identification	Height (rounded to the nearest inch) Save Time On Research and Writing Hire a Pro to Write You a 100% Plagiarism-Free Paper. Get My Paper	Weight (rounded to the nearest pound)
								M	53			156
										F	46		131
	54	123
	44	142
56
76	171
87			143
	65	135
45	138
114
57	154
68	166
153
	66	140
51	173
58
49	161
48

For each variable, using Microsoft Excel, compute the mean, the median, and the mode.

For each variable, using Microsoft Excel, compute the range and standard deviation.

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

Choose colors and formatting options in Microsoft Excel that you find helpful to enhance the readability of your data. Attach a document with your combined Microsoft Excel results and graphs.

In the body of your main post, in paragraph form and in your own words, describe the fitness club members on the basis of the data you collected. Explain why you chose particular visual formats. Additionally, share your reflections of your experience conducting these descriptive analyses.

If you are having difficulty using Microsoft Excel, this is an opportunity to start a discussion with your instructor and classmates to seek help, guidance, and tips.