Making the Vel. vs Time chart
#1
AudiWorld Super User
Thread Starter
Join Date: Apr 2000
Posts: 3,849
Likes: 0
Received 0 Likes
on
0 Posts
Making the Vel. vs Time chart
Creating the chart w/ Excel.
1) Set up four columns under A,B,C,D with the respective labels; Time, TimeSqd, TimeCube, Dist
2) List the times recorded, in seconds, under the Time column. Distance in feet under the Dist column
3) Use Excel to create columns of squared and cubed times under the appropriate label
Time TimeSqd TimeCube Dist
0.0 0.0 0.0 0.0
2.2 4.9 10.7 60.0
6.3 39.1 244.8 330.0
9.6 92.4 888.3 660.0
14.8 219.8 3258.2 1320.0
4) Select the Regression tool from the Data Analysis package.
5) Input Y Range: this should be the Dist column, including the label
6) Input X Range: this should include the first three columns (Time, TimeSqd, TimeCube) with labels
7) Select the labels check box and New Worksheet Ply options
8) Click OK to generate data sheet
9) Plug the results into the following formulas
Dist = Intercept + Time * (t) + TimeSqd * (t) ^ 2 + TimeCube * (t) ^ 3
For this ex.
Dist = -1.09 + 14.35 * (t) + 6.86 * (t) ^ 2 - 0.12 * (t) ^ 3
Vel = Time + 2 * TimeSqd * (t) + 3 * TimeCube * (t) ^ 2
For this ex.
Vel = 14.35 + 13.71 * (t) - 0.37 * (t) ^ 2
Note: The distance formula isn't necessary.
10) Now you can create a new table with columns of Time and Velocity. Plug in time values (in sec) to the velocity equation to get the velocity at that point in time (in feet/sec. I multiplied that by 3600/5280 to convert to mph) Use the chart function to create the chart. I selected the smooth line function when plotting the data.<p>2001 S4
D Status
6 spd/Sport Interior
Santorin Blue
Silver Alcantara<ul><li><a href="https://www.audiworld.com/forum/m/s4/msgs/87522.phtml">https://www.audiworld.com/forum/m/s4/msgs/87522.phtml</a</li></ul>
1) Set up four columns under A,B,C,D with the respective labels; Time, TimeSqd, TimeCube, Dist
2) List the times recorded, in seconds, under the Time column. Distance in feet under the Dist column
3) Use Excel to create columns of squared and cubed times under the appropriate label
Time TimeSqd TimeCube Dist
0.0 0.0 0.0 0.0
2.2 4.9 10.7 60.0
6.3 39.1 244.8 330.0
9.6 92.4 888.3 660.0
14.8 219.8 3258.2 1320.0
4) Select the Regression tool from the Data Analysis package.
5) Input Y Range: this should be the Dist column, including the label
6) Input X Range: this should include the first three columns (Time, TimeSqd, TimeCube) with labels
7) Select the labels check box and New Worksheet Ply options
8) Click OK to generate data sheet
9) Plug the results into the following formulas
Dist = Intercept + Time * (t) + TimeSqd * (t) ^ 2 + TimeCube * (t) ^ 3
For this ex.
Dist = -1.09 + 14.35 * (t) + 6.86 * (t) ^ 2 - 0.12 * (t) ^ 3
Vel = Time + 2 * TimeSqd * (t) + 3 * TimeCube * (t) ^ 2
For this ex.
Vel = 14.35 + 13.71 * (t) - 0.37 * (t) ^ 2
Note: The distance formula isn't necessary.
10) Now you can create a new table with columns of Time and Velocity. Plug in time values (in sec) to the velocity equation to get the velocity at that point in time (in feet/sec. I multiplied that by 3600/5280 to convert to mph) Use the chart function to create the chart. I selected the smooth line function when plotting the data.<p>2001 S4
D Status
6 spd/Sport Interior
Santorin Blue
Silver Alcantara<ul><li><a href="https://www.audiworld.com/forum/m/s4/msgs/87522.phtml">https://www.audiworld.com/forum/m/s4/msgs/87522.phtml</a</li></ul>
Thread
Thread Starter
Forum
Replies
Last Post
jetinder
A8 / S8 (D4 Platform) Discussion
0
10-28-2014 11:08 PM
Gumbo
Florida Discussion
3
11-03-2004 04:37 AM
Auto Union Jack
A6 / S6 (C5 Platform) Discussion
2
02-14-2002 09:22 PM