1. Welcome to TechPowerUp Forums, Guest! Please check out our forum guidelines for info related to our community.

Extrapolating in excel

Discussion in 'General Software' started by kwchang007, Oct 25, 2007.

  1. kwchang007

    kwchang007 New Member

    Joined:
    Jan 27, 2007
    Messages:
    3,979 (1.35/day)
    Thanks Received:
    185
    Location:
    Severn, MD, USA.
    Does anyone know how to extrapolate a graph in excel :confused:
     
  2. Thermopylae_480

    Thermopylae_480 New Member

    Joined:
    May 27, 2005
    Messages:
    3,686 (1.03/day)
    Thanks Received:
    393
    Location:
    Little Rock Arkansas, United States
    Extrapolate what? Can you be more specific? Are you trying to make a graph?
     
  3. Kreij

    Kreij Senior Monkey Moderator Staff Member

    Joined:
    Feb 6, 2007
    Messages:
    13,881 (4.71/day)
    Thanks Received:
    5,622
    Location:
    Cheeseland (Wisconsin, USA)
    Not sure what you are doing exactly, but here is a little booklet that explains very simple interpolation and extrapolation (on graphs) using regression calculations in excel.
     
    kwchang007 says thanks.
  4. DanTheBanjoman SeƱor Moderator

    Joined:
    May 20, 2004
    Messages:
    10,553 (2.68/day)
    Thanks Received:
    1,383
    Not sure, if the structure of the formula remains the same you could fill in the formula with data and then make a graph out of the formula instead of data?

    If it's random data I wouldn't know.
     
  5. kwchang007

    kwchang007 New Member

    Joined:
    Jan 27, 2007
    Messages:
    3,979 (1.35/day)
    Thanks Received:
    185
    Location:
    Severn, MD, USA.
    Given a set of related data that are related in some way (linear or quadratic...in this case it's quadratic) finding an unknown value (say on the x you know 1,2,3..I'm looking for 4)

    EDIT: Kreij gave me the right stuff...thanks you guys.
     
    Last edited: Oct 25, 2007
  6. rheged

    Joined:
    Nov 5, 2006
    Messages:
    25 (0.01/day)
    Thanks Received:
    7
    Location:
    UK
    This may sound daft as I'm not sure about the accuracy of the excel trendlines, but what you could try is right clicking on the line of the data you want to extrapolate from, making an appropriate trendline (I dont know what sort of line ur dealing with, so pick from the options whichever type of trendline most closely fits your data), then in the options on the same menu as from where you choose ur trendline, in the box marked "Forward" or "Backward", enter how many data points forward or backward you wish to extrapolate. It <i>should</i> be reasonable accurate, but I havnt come across any software yet which can extrapolate decently, so you may be better off working it manually, then include the extrapolated data in your graph data range.

    Apologies for the poorly worded explanation and the utter lack of full stops, I couldnt think of how to word this better :ohwell:
     
  7. kwchang007

    kwchang007 New Member

    Joined:
    Jan 27, 2007
    Messages:
    3,979 (1.35/day)
    Thanks Received:
    185
    Location:
    Severn, MD, USA.
    Yeahh that's what I ended up doing. Also I figured out that if you need an extrapolated piece of data at a certain point you could get excel to give you an equation for the trendline and use that.
     
  8. rheged

    Joined:
    Nov 5, 2006
    Messages:
    25 (0.01/day)
    Thanks Received:
    7
    Location:
    UK
    Good stuff mate. Glad it went all right. What were you extrapolating btw (curious from the perspective of a physics student)?
     
  9. kwchang007

    kwchang007 New Member

    Joined:
    Jan 27, 2007
    Messages:
    3,979 (1.35/day)
    Thanks Received:
    185
    Location:
    Severn, MD, USA.
    I forget tbh, but it was something with a chem project.
     

Currently Active Users Viewing This Thread: 1 (0 members and 1 guest)

Share This Page