Discuss the below:
Q1) 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
|
Q2) Do the standard deviation, mean, and variance calculations in a Microsoft Excel document
|
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
|
Q3) Describe a situation in which you could use z-scores to make better business process decisions (i.e. in the medical field, appointments, etc.)