|
Oct 25, 2007, 09:57 PM
|
#1 |
 
Join Date: Jan 2007
Location: Severn, MD, USA.
Posts: 2,949 (2.66/day)
Thanks: 72
Thanked 190 Times in 186 Posts
 |
Extrapolating in excel
Does anyone know how to extrapolate a graph in excel
__________________
Power User Teenager Club Laptop Overclocking club Thanks button....hit it if someone helped you, not a difficult concept really. [img disabled]http://www.hwbot.org/signature.img?t=1&uid=8351&iehack=.jpg[/img] |
|
|
|
Oct 25, 2007, 10:01 PM
|
#2 |
Join Date: May 2005
Location: Fayetteville Arkansas, United States
Posts: 2,643 (1.54/day)
Thanks: 39
Thanked 413 Times in 284 Posts
 |
Extrapolate what? Can you be more specific? Are you trying to make a graph?
__________________
We're here to help. If you need anything, please contact a moderator. All, too, will bear in mind this sacred principle, that though the will of the majority is in all cases to prevail, that will to be rightful must be reasonable; that the minority possess their equal rights, which equal law must protect, and to violate would be oppression. visit our sister site GamePowerUp! |
|
|
|
|
Oct 25, 2007, 10:06 PM
|
#3 |
|
TPU Hit Squad Member
Join Date: Feb 2007
Location: Cheeseland (Wisconsin, USA)
Posts: 3,787 (3.45/day)
Thanks: 118
Thanked 951 Times in 712 Posts
|
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.
__________________
TPU Coders : Helping students with their homework since 1985.
Hundreds gather to protest global warming |
|
|
|
| The Following User Says Thank You to Kreij For This Useful Post: |
|
Oct 25, 2007, 10:07 PM
|
#4 |
|
Seņor Moderator
Join Date: May 2004
Location: Utrecht, Utrecht, The kingdom of the Netherlands
Posts: 7,391 (3.53/day)
Thanks: 27
Thanked 1,041 Times in 801 Posts
 |
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. |
|
|
|
|
Oct 25, 2007, 10:10 PM
|
#5 | |
|
Join Date: Jan 2007
Location: Severn, MD, USA.
Posts: 2,949 (2.66/day)
Thanks: 72
Thanked 190 Times in 186 Posts
|
Quote:
EDIT: Kreij gave me the right stuff...thanks you guys.
__________________
Power User Teenager Club Laptop Overclocking club Thanks button....hit it if someone helped you, not a difficult concept really. [img disabled]http://www.hwbot.org/signature.img?t=1&uid=8351&iehack=.jpg[/img] Last edited by kwchang007; Oct 25, 2007 at 10:17 PM. |
|
|
|
|
|
Jun 25, 2008, 08:58 PM
|
#6 |
 |
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  |
|
|
|
|
Jun 25, 2008, 09:20 PM
|
#7 |
|
Join Date: Jan 2007
Location: Severn, MD, USA.
Posts: 2,949 (2.66/day)
Thanks: 72
Thanked 190 Times in 186 Posts
|
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.
__________________
Power User Teenager Club Laptop Overclocking club Thanks button....hit it if someone helped you, not a difficult concept really. [img disabled]http://www.hwbot.org/signature.img?t=1&uid=8351&iehack=.jpg[/img] |
|
|
|
|
Jun 25, 2008, 09:49 PM
|
#8 |
|
|
Good stuff mate. Glad it went all right. What were you extrapolating btw (curious from the perspective of a physics student)?
|
|
|
|
|
Jun 25, 2008, 10:30 PM
|
#9 | |
|
Join Date: Jan 2007
Location: Severn, MD, USA.
Posts: 2,949 (2.66/day)
Thanks: 72
Thanked 190 Times in 186 Posts
|
Quote:
__________________
Power User Teenager Club Laptop Overclocking club Thanks button....hit it if someone helped you, not a difficult concept really. [img disabled]http://www.hwbot.org/signature.img?t=1&uid=8351&iehack=.jpg[/img] |
|
|
|
|
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
|
|
System Specs
