Explore BrainMass
Share

Computing mean, variance and standard deviation

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

1) Please calculate the standard deviation, mean, and variance for the dataset below (round to the nearest 2 decimal places where applicable).
Men's 400 Meter Race
Athlete Country Time
LaShawn Merritt USA 43.75
Jeremy Wariner USA 44.74
David Neville USA 44.80
Chris Brown BAH 44.84
Leslie Djhone FRA 45.11
Martyn Rooney GBR 45.12
Renny Quow TRI 45.22
Johan Wissman SWE 45.39

Mean:
Standard Deviation:
Variance:

2) Do the standard deviation, mean, and variance calculations (same as question #3 above) in a Microsoft Excel document, using Excel formulas, and send it as a separate attachment (or embed the Excel file below).
Men's 400 Meter Race
Athlete Country Time
LaShawn Merritt USA 43.75
Jeremy Wariner USA 44.74
David Neville USA 44.80
Chris Brown BAH 44.84
Leslie Djhone FRA 45.11
Martyn Rooney GBR 45.12
Renny Quow TRI 45.22
Johan Wissman SWE 45.39

3) Describe a situation in which you could use z-scores to make better business process decisions (i.e. in the medical field, appointments, etc.)

© BrainMass Inc. brainmass.com October 17, 2018, 1:03 pm ad1c9bdddf
https://brainmass.com/statistics/standard-deviation/computing-mean-variance-and-standard-deviation-599891

Attachments

Solution Preview

1) Please calculate the standard deviation, mean, and variance for the dataset below (round to the nearest 2 decimal places where applicable).
Men's 400 Meter Race
Athlete Country Time
LaShawn Merritt USA 43.75
Jeremy Wariner USA 44.74
David Neville USA 44.80
Chris Brown BAH 44.84
Leslie Djhone FRA 45.11
Martyn Rooney GBR 45.12
Renny Quow TRI 45.22
Johan Wissman SWE 45.39

ANSWER
Mean: ...

Solution Summary

The solution gives detailed steps on computing the mean, variance and standard deviation using both hand and excel.

$2.19
Similar Posting

Computing mean, median, mode, variance, standard deviation

1. The ages of all the patients in the isolation ward of the hospital are 38, 26, 13, 41, and 22. What are the population mean, variance, and standard deviation?

2. The weights of a sample of seven FedEx shipments, to the nearest pound, are 10, 7, 11, 10, 13, 5, and 4. Compute the sample mean, the median, and the modal weight.

3. The following is the number of shares traded (in 1,000's) for a sample of eight stocks listed on the New York Stock Exchange; 62, 41, 60, 49, 39, 45, 26, and 38. Compute the mean, range, and standard deviation.

Please show me all the steps so that I can fully understand how to do these types of problems.

View Full Posting Details