The 400 meters is a standard track event and it is a part of both the Olympic Ga
ID: 2949447 • Letter: T
Question
The 400 meters is a standard track event and it is a part of both the Olympic Games and World Championships. The top 17 finishers of the men’s and women’s semifinal races from the 2013 World Championships are listed.
Calculate the mean, median, range, and standard deviation for each data set. You are expected to use technology to make your calculations (such as a calculator, Microsoft Excel, etc.). State specifically what technology you used.
Explain in three to five sentences how you found the standard deviation. Be sure to describe any technology that you used and how you used it.
Suppose the timing device used in the men’s race failed to activate at the start of the race and instead began to record the timesseconds into the race. Consider how the competitors’ times would be affected. Would the seconds be added to or subtracted from the times recorded? Would the median you calculated in question #1 be affected? If yes, how? If no, why not?
Find out who placed 5th in the final of the men’s and the women’s 400 meter races at the 2008 Summer Olympics in Beijing. Record the names, nationalities, and times. Be sure to properly cite your source(s) on a Works Cited page. Under “assignment specifications” below, there are some guidelines to help you with citing your source(s).
If both of those 5th place finishers had competed in the semifinals of the 2013 World Championships with their 2008 Olympic final time, where would they have placed? Who would have done relatively better at the 2013 World Championship semifinals? Justify your answer mathematically. Consider using more than one method to justify your answer.
Submission Guidelines: Your project should be typed; however, mathematical calculations may be handwritten. Your facts must be properly cited with a Works Cited page. For citation, use the Modern Language Association (MLA) format and use parenthetical citation with a Works Cited list as the final page (non-content page). Purdue University offers a very good online reference at their Writing Lab's website.
http://owl.english.purdue.edu/owl/resource/747/01/
http://library.ccbcmd.edu/screens/web/MLA_fall2014.pdf
Men’s 2013 World Championship – Semifinal Results
Rank
Name
Nationality
Time (sec.)
1
LaShawn Merritt
United States
44.60
2
Yousef Masrahi
Saudi Arabia
44.61
3
Tony McQuay
United States
44.66
4
Kirani James
Grenada
44.81
5
Luguelín Santos
Dominican Republic
44.83
6
Pavel Maslák
Czech Republic
44.84
7
Jonathan Borlée
Belgium
44.85
8
Anderson Henriques
Brazil
44.95
9
Kevin Borlée
Belgium
45.03
10
Chris Brown
Bahamas
45.18
11
Jarrin Solomon
Trinidad and Tobago
45.43
12
Deon Lendore
Trinidad and Tobago
45.47
13
Arman Hall
United States
45.54
14
Nigel Levine
Great Britain
45.60
15
Javon Francis
Jamaica
45.62
16
Matteo Galvan
Italy
45.69
17
Javere Bell
Jamaica
45.77
Women’s 2013 World Championship – Semifinal Results
Rank
Name
Nationality
Time (sec.)
1
Amantle Montsho
Botswana
49.56
2
Christine Ohuruogu
Great Britain
49.75
3
Francena McCorory
United States
49.86
4
Natasha Hastings
United States
49.94
5
Antonina Krivoshapka
Russia
49.99
6
Stephanie McPherson
Jamaica
49.99
7
Novlene Williams-Mills
Jamaica
50.34
8
Libania Grenot
Italy
50.47
9
Kseniya Ryzhova
Russia
50.48
10
Regina George
Nigeria
50.84
11
Nataliya Pyhyda
Ukraine
51.02
12
Floria Guei
France
51.42
13
Bianca R?zor
Romania
51.49
14
Marie Gayot
France
51.54
15
Kineke Alexander
Saint Vincent and the Grenadines
51.64
16
Ashley Spencer
United States
51.80
17
Aauri Bokesa
Spain
51.94
Rank
Name
Nationality
Time (sec.)
1
LaShawn Merritt
United States
44.60
2
Yousef Masrahi
Saudi Arabia
44.61
3
Tony McQuay
United States
44.66
4
Kirani James
Grenada
44.81
5
Luguelín Santos
Dominican Republic
44.83
6
Pavel Maslák
Czech Republic
44.84
7
Jonathan Borlée
Belgium
44.85
8
Anderson Henriques
Brazil
44.95
9
Kevin Borlée
Belgium
45.03
10
Chris Brown
Bahamas
45.18
11
Jarrin Solomon
Trinidad and Tobago
45.43
12
Deon Lendore
Trinidad and Tobago
45.47
13
Arman Hall
United States
45.54
14
Nigel Levine
Great Britain
45.60
15
Javon Francis
Jamaica
45.62
16
Matteo Galvan
Italy
45.69
17
Javere Bell
Jamaica
45.77
Explanation / Answer
Calculate the mean, median, range, and standard deviation for each data set. You are expected to use technology to make your calculations (such as a calculator, Microsoft Excel, etc.). State specifically what technology you used.
USED EXCEL
install analysis tool pack.
Go to data >data analysis>descriptive statistics.
select the variable time.
You will get the below output:
COMING TO ANSWERS:
in excel standard deviation is calculated using function below:
For mens standrad deviation is
=STDDEV.S(A2:A19)
=0.412736
For Womens standard deviation is
=STDDEV.S(D3:D19)
=0.803275
Suppose the timing device used in the men’s race failed to activate at the start of the race and instead began to record the timesseconds into the race. Consider how the competitors’ times would be affected. Would the seconds be added to or subtracted from the times recorded? Would the median you calculated in question #1 be affected? If yes, how? If no, why not?
it will increase .
It would get affected.
median would be 45.03+x
Men’s 2013 World Championship– Semifinal ResultsDescrptive statistics Time (sec.) Mean 45.14588235 Standard Error 0.100103104 Median 45.03 Mode #N/A Standard Deviation 0.412735672 Sample Variance 0.170350735 Kurtosis -1.642755467 Skewness 0.159576894 Range 1.17 Minimum 44.6 Maximum 45.77 Sum 767.48 Count 17
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.