Jump to content
Sign in to follow this  
Frizzl

Excel Trendlines

Recommended Posts

I don't THINK this should go in Windows, but I couldn't really see where else it would go...

 

Anyhow, what I am currently doing is graphing a set of data. Lets say the data is voltage versus resistance.

 

If I have say, 4 voltages, 5V, 7.5V 9V and 10V and I graph the corresponding resistances, then I want to also plot a trendline for forwards extrapolation...

 

How can I find the extrapolated value of a voltage (say 12V?). I can see a trendline, and could follow the gridline across to find the resistance, but this isn't as accurate as it should be.

 

 

 

If this doesn't make sense, or more clarification required just let me know :)

Share this post


Link to post
Share on other sites

Right click on the data series on the graph & click "Add Trendline" :)

Oh I know how to add a trendline, I'm just wondering if it's possible to find the 'forecasted' value for a particular number.

 

Say the data only goes to 10V, I want to find the resistance at 12V using the trend?

Share this post


Link to post
Share on other sites

Tsk tsk tsk. You haven't specified what version of Excel.

 

In 2007:

 

Right Click Trendline -> Format Trendline -> Forecast Boxy Thing -> Forward/Backward periods.

 

Rob.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×