• Welcome to TechPowerUp Forums, Guest! Please check out our forum guidelines for info related to our community.
  • The forums have been upgraded with support for dark mode. By default it will follow the setting on your system/browser. You may override it by scrolling to the end of the page and clicking the gears icon.

Extrapolating in excel

kwchang007

kwchang007

New Member
Joined
Jan 27, 2007
Messages
3,962 (0.59/day)
Location
Severn, MD, USA.
System Specs
Processor C2D T7200@2 ghz vcore: .9875
Motherboard generic laptop board
Cooling fan control and antec notebook cooler
Memory 2 GBs@ 533 mhz ddr2
Video Card(s) x1400 mobile, overclocked: 526mhz core/ 882mhz ddr
Storage 120 GB@ 5400 rpm fujitsu
Display(s) 15.4" 1440x900
Audio Device(s) integrated
Software vista 32 bit home premium
Does anyone know how to extrapolate a graph in excel :confused:
 
Extrapolate what? Can you be more specific? Are you trying to make a graph?
 
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.
 
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.
 
Thermopylae_480 said:
Extrapolate what? Can you be more specific? Are you trying to make a graph?
Click to expand...

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:
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:
 
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.
 
Good stuff mate. Glad it went all right. What were you extrapolating btw (curious from the perspective of a physics student)?
 
rheged said:
Good stuff mate. Glad it went all right. What were you extrapolating btw (curious from the perspective of a physics student)?
Click to expand...
I forget tbh, but it was something with a chem project.
 
You must log in or register to reply here.
Back
Top