Results 1 to 3 of 3

Math Help - Finding constant for gravity problem

  1. #1
    Member
    Joined
    Oct 2006
    From
    Toronto
    Posts
    86

    Finding constant for gravity problem

    Question:
    Find a numerical value for g based on this table using excel. (The function is x = 0.5gt^2 where g represents gravity and t represents time).
    Table:
    Distance, (x) Time, (s)
    0.1 .148
    0.2 .196
    0.3 .244
    0.4 .290

    I donít know how to go about doing this with excel and how Iíd estimate the value of g. Maybe taking the ln of both sides or something?
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Forum Admin topsquark's Avatar
    Joined
    Jan 2006
    From
    Wellsville, NY
    Posts
    9,888
    Thanks
    326
    Awards
    1
    Quote Originally Posted by SportfreundeKeaneKent View Post
    Question:
    Find a numerical value for g based on this table using excel. (The function is x = 0.5gt^2 where g represents gravity and t represents time).
    Table:
    Distance, (x) Time, (s)
    0.1 .148
    0.2 .196
    0.3 .244
    0.4 .290

    I donít know how to go about doing this with excel and how Iíd estimate the value of g. Maybe taking the ln of both sides or something?
    That would be one way.

    You could take the simple way out: Solve the equation for g and calculate it for each data point. Then take the average.

    The better way is more along the lines you were thinking of. Calculate t^2 from the time for each data point. Then make a graph with t^2 as your horizontal axis and distance for your vertical axis. The slope of the resulting best fit line will be equal to 0.5g.

    -Dan
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by SportfreundeKeaneKent View Post
    Question:
    Find a numerical value for g based on this table using excel. (The function is x = 0.5gt^2 where g represents gravity and t represents time).
    Table:
    Distance, (x) Time, (s)
    0.1 .148
    0.2 .196
    0.3 .244
    0.4 .290

    I donít know how to go about doing this with excel and how Iíd estimate the value of g. Maybe taking the ln of both sides or something?
    Create a cell to hold the guess for g, then create a new column next to the
    time column and put 0.5*r*t^2 in that column, were the t is from the
    next cell. NOw you need to form another new coumn with the square of the
    difference between the right most and left most column, and sum this new column.

    Now adjust the value in g untill the sum is minimised (or use solver to do this for you.

    RonL
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Finding a Common centre of gravity
    Posted in the Advanced Math Topics Forum
    Replies: 7
    Last Post: October 6th 2010, 09:28 AM
  2. Equilibrium and Gravity problem #4
    Posted in the Math Topics Forum
    Replies: 0
    Last Post: November 26th 2009, 12:09 PM
  3. Equilibrium and Gravity problem #2
    Posted in the Math Topics Forum
    Replies: 0
    Last Post: November 25th 2009, 02:12 PM
  4. Interesting gravity problem.
    Posted in the Calculus Forum
    Replies: 2
    Last Post: November 21st 2009, 06:35 PM
  5. Physics Gravity Problem
    Posted in the Math Topics Forum
    Replies: 1
    Last Post: February 4th 2008, 07:16 PM

Search Tags


/mathhelpforum @mathhelpforum