Reference no: EM13977171
Assignment: 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.
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.
o Under what conditions would you use a median rather than the mean as a measure of central tendency?
o Why is the range the most convenient measure of dispersion and the most imprecise measure of variability?
o Why is it important to consider the type of data when computing descriptive statistics?
o Why do we use a standard deviation instead of variance?
o Is it helpful to understand the equations, or do you just need to know how to plug the formula into Microsoft Excel?
|
If you make the percentage price change that you calculated
: If you make the percentage price change that you calculated in part a) will total revenue increase or decrease? How do you know?
|
|
Calculate stress in beam and coefficient of linear expansion
: 5 kN forces are acting longitudinally on each end of a beam with a cross-sectional area of 100cm2 and an original length of 5m. As a result of such forces, the length of the beam has been reduced by 1 cm. Calculate the stress in the beam and the ..
|
|
Draw a histogram of emxp
: Draw a histogram of EMXP. Does EMXP have an approximately normal distribution? Does it have an obvious skew (left or right) and any obvious outliers? If an analysis requires that EMXP have a normal distribution, do you think that your results will..
|
|
Find the rms voltages across the resistor
: A 45.0-Ω resistor, a 0.100-H inductor, and a 10.0-muF capacitor are connected in series to a 60.0-Hz source. The rms current in the circuit is 2.25 A. Find the rms voltages across the resistor.
|
|
Why do we use a standard deviation instead of variance
: 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
|
|
What is pccorps capital productivity
: What is PCCorps capital productivity? This must be done in Excel and formula showed how you arrive at the answer.
|
|
Calculate the maximum current delivered by the source
: Calculate the maximum current delivered by the source. Calculate the phase angle between the current and voltage. Is the current leading or lagging behind the voltage?
|
|
What is the final kinetic energy of the electron
: A 5 Mev photon collides with an electron that is at rest, and imparts to it the maximum possible kinetic energy. Subsequent to the collision, in what directions, repectively, are the electron and the photon traveling?
|
|
Name and describe the five steps of coaching
: Name and describe the five steps of coaching. What is executive coaching'? Do you think it is necessary? Support your answer with research. The five steps of coaching are forging a partnership, inspiring commitment, growing skills, promoting persiste..
|