Graphing Usain Bolt's 2008 WR 100m Sprint

	A	B	C	D	E	F	G	H	I
1	Graphing Usain Bolt's 2008 WR 100m Sprint					Instructions
2	A	B	C	D	E
3	Distance (m)	Time (s)	Time for each 10m interval (s) (from Column B)	Average velocity in each 10m interval (m/s) (10m/Column C)	Mid-point Time (s) ie. average time between each interval) (from Column B)		Column C Instructions (Click Here)	Column D Instructions (Click Here)	Column E instructions (Click Here)
4	0	0	-	0	0
5	10	1.85	1.85 – 0 = 1.85	10/1.85 = 5.41	(1.85+0)/2=0.925	← Delete the text in C5, D5, and E5 before you begin.
6	20	2.87
7	30	3.78
8	40	4.65
9	50	5.5
10	60	6.32
11	70	7.14
12	80	7.96
13	90	8.79
14	100	9.69
15
16			(a) Draw a graph of Distance vs Time (Column A vs Column B). Distance should be shown on the y-axis (the vertical axis).
17			(b) Draw a graph of Velocity vs Time (Column D vs Column E). Velocity should be shown on the y-axis (the vertical axis).
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100