Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how can I model newton's falling body equation in excel
how can I model newton's falling body equation in excel
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
how can I model newton's falling body equation in excel
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. -- David Biddulph "groovay" wrote in message ... how can I model newton's falling body equation in excel |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
how can I model newton's falling body equation in excel
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!) -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "groovay" wrote in message ... how can I model newton's falling body equation in excel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting an Excel Model into a Function | Excel Worksheet Functions | |||
How do I model a Paretian Distribution in Excel? | Excel Worksheet Functions | |||
why is the zero falling off a zip code in excel? | Excel Worksheet Functions | |||
VBA: Where to find Excel Object model? | Excel Discussion (Misc queries) | |||
"Excel.Application" Object Model | Charts and Charting in Excel |