• We've upgraded our forums. Please post any issues/requests in this thread.

Extrapolating in excel

Joined
Jan 27, 2007
Messages
3,962 (1.00/day)
Likes
184
Location
Severn, MD, USA.
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
#1
Does anyone know how to extrapolate a graph in excel :confused:
 
Joined
May 27, 2005
Messages
3,651 (0.80/day)
Likes
341
Location
Little Rock Arkansas, United States
System Name Monolith
Processor Intel Xeon E3110 Wolfdale@3.5GHz
Motherboard MSI P35-Neo
Cooling Active Air
Memory 4GB DDR2 800
Video Card(s) Sapphire HD 3850 512MB PCI-E
Storage 1 x 80GB Internal, 1 x 250GB Internal, 1 x 40GB External
Display(s) Acer X203w
Case Generic black case with locking front bezel
Audio Device(s) Creative SB Audigy 2 ZS
Power Supply 500 Watt Seasonic M12
Software Windows 7 Ultimate x64
#2
Extrapolate what? Can you be more specific? Are you trying to make a graph?
 

Kreij

Senior Monkey Moderator
Staff member
Joined
Feb 6, 2007
Messages
13,817 (3.49/day)
Likes
5,524
Location
Cheeseland (Wisconsin, USA)
Processor Intel Core 2 Quad QX9650 Extreme @ 3.0 GHz
Motherboard Asus Rampage Formula
Cooling ZeroTherm Nirvana NV120 Premium
Memory 8GB (4 x 2GB) Corsair Dominator PC2-8500
Video Card(s) 2 x Sapphire Radeon HD6970
Storage 2 x Seagate Barracuda 320GB in RAID 0
Display(s) Dell 3007WFP 30" LCD (2560 x 1600)
Case Thermaltake Armor w/ 250mm Side Fan
Audio Device(s) SupremeFX 8ch Audio
Power Supply Thermaltake Toughpower 750W Modular
Software Win8 Pro x64 / Cat 12.10
#3
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.
 

DanTheBanjoman

Señor Moderator
Joined
May 20, 2004
Messages
10,488 (2.12/day)
Likes
1,331
#4
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.
 
Joined
Jan 27, 2007
Messages
3,962 (1.00/day)
Likes
184
Location
Severn, MD, USA.
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
#5
Extrapolate what? Can you be more specific? Are you trying to make a graph?
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:
Joined
Nov 5, 2006
Messages
25 (0.01/day)
Likes
7
Location
UK
System Name Home Desktop
Processor AMD FX-6300 Piledriver 3.5GHz
Motherboard Gigabyte G8-78LMT-S2P
Cooling Out-of-the-box cooler
Memory 4GB of Corsair VS2GB 1333D3
Video Card(s) Saphire R7 250 1GB GDDR5
Storage Seagate Barracuda ST500DM002 SATA 3
Display(s) ACER V173 17"
Case Novatech
Audio Device(s) Onboard
Power Supply Novatech 750W
Software Windows 7 Home Premium 64bit
#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 :ohwell:
 
Joined
Jan 27, 2007
Messages
3,962 (1.00/day)
Likes
184
Location
Severn, MD, USA.
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
#7
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.
 
Joined
Nov 5, 2006
Messages
25 (0.01/day)
Likes
7
Location
UK
System Name Home Desktop
Processor AMD FX-6300 Piledriver 3.5GHz
Motherboard Gigabyte G8-78LMT-S2P
Cooling Out-of-the-box cooler
Memory 4GB of Corsair VS2GB 1333D3
Video Card(s) Saphire R7 250 1GB GDDR5
Storage Seagate Barracuda ST500DM002 SATA 3
Display(s) ACER V173 17"
Case Novatech
Audio Device(s) Onboard
Power Supply Novatech 750W
Software Windows 7 Home Premium 64bit
#8
Good stuff mate. Glad it went all right. What were you extrapolating btw (curious from the perspective of a physics student)?
 
Joined
Jan 27, 2007
Messages
3,962 (1.00/day)
Likes
184
Location
Severn, MD, USA.
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
#9
Good stuff mate. Glad it went all right. What were you extrapolating btw (curious from the perspective of a physics student)?
I forget tbh, but it was something with a chem project.