how can I model newton's falling body equation in excel

  • Thread starter Thread starter groovay
  • Start date Start date
Which equation?
d=0.5*g*t^2
t=sqrt(2*d/g)
v=g*t
v=sqrt(2*g*d)

Whichever one you want, if you want to produce a chart from the equation,
put a range of x values in the left-hand column, then use the equation to
produce a corresponding range of y-values in the adjacent column. Put a y
label above the y-values (but not, at this stage, a label above the
x-values, so leave that top left-hand cell blank.). Select from that blank
top-left hand cell down to the bottom of the y values, then Insert/ Chart/
XY, choose an appropriate sub-type, & choose appropriate options to finish.
 
Let's say you want to model d=0.5*g*t^2
In A1 enter the text "time" and in B1 the text "Distance" - no quotes
In A2 enter 0, in A3 enter =A1+1
In B2 enter =0.5*10*A2^2 (I'm assuming you are using SI units, if not use
32 for g)
Copy B2 to B3
Copy A3:B3 down to say row 100
Put the cursor anywhere within A1:B100 and click the Chart Wizard. You want
an XY chart with smooth line.

You chart will show the distance dropped against time. If you want the
height then in B1 enter the starting value (say 100) and in B2 enter
=$B$1-0.5*10*A2^2 and copy this down the column.

best wishes (hope you get a good homework mark!)
 
Back
Top