Assignment:
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.
|
Gender Identification
|
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.
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.