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.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more