Excel - Reuse a trend line to apply to other data

Posted by milko on Super User See other posts from Super User or by milko
Published on 2014-05-28T15:00:34Z Indexed on 2014/05/28 15:33 UTC
Read the original article Hit count: 151

Filed under:

microsoft-excel-2007

|

trendlines

I've obtained a trend line from a particular set of data. What I'd like to do now is to reuse this trend line to predict values from a given pair (x,y) of coordinates.

To put it another way, I have one pair (x,y) that I know is correct for sure. I don't know any other point. Let's assume the behavior of this new set is similar to the one I've got the trend line from. Is there any way Excel could compute other points following this trend line?

© Super User or respective owner

Related posts about microsoft-excel-2007

Microsoft Excel 2007 constantly calculating sheets

as seen on Super User - Search for 'Super User'
I believe this happening for two weeks now: Excel 2007 (on Windows XP) is acting funny on my computer; any medium sized sheet with some formulas in it takes a significant amount of time recalculating. I can see this because the "calculating: 2 processors xx%" message was almost unseen before and… >>> More
To pull data into Microsoft Excel 2007 with web queries

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, How can i perform to enter username and password when want to pull data into Microsoft Excel with web queries??? Have any solution can be used to solve this kind of problem? >>> More
I want to move columns in a gradebook based on the column header title to another gradebook

as seen on Super User - Search for 'Super User'
I have to average grades based on each objective for a new report card we have to complete this year. For example Column one has students names, each additional column will have the objective associated with the assignment. I would like to move the entire column to another sheet for each objective… >>> More
Returning row values based on conditional formatting variables

as seen on Super User - Search for 'Super User'
I'm not entirely sure how to properly explain this, but here we go... I'm trying to create a single budgeting document that allows me to manage purchasing and reconciliation for multiple projects. I would like to create separate sheets per project and have purchased items populate on a master sheet… >>> More
How to convert a string to a binary, then hex, value?

as seen on Super User - Search for 'Super User'
In one column I have a bitstring encoded as a string type. In a different column I wish to have the same bits (potentially starting with a leading 0), but as a binary value type. Ultimately, I want to have it in hex representation (string or hex type, doesn't matter) in a third column. How is this… >>> More

Related posts about trendlines

How to antialias trendline in Excel?

as seen on Super User - Search for 'Super User'
I have created a couple of line charts in Excel 2011 for Mac. The actual data line looks good and is antialiased in a nice way but when I then add a trendline it is jagged and ugly: I have tried "all" options available under Format Trendline, to no avail. There is an option "Soft Edges" but it… >>> More
Excel trendline accuracy

as seen on Super User - Search for 'Super User'
This is a problem I have every once in a while, and it annoys me tremendously, beacuse I have always to recheck every trendline I get. An example: r L (mm) 30,00 97,0 60,00 103,2 90,00 106,0 110,00 101,0 125,00 88,0 140,00 62,0 148,00 36,7 152,50 17,0 Upon… >>> More
Apart from visually looking - is there a way of calculating when a trendline will cross another seri

as seen on Super User - Search for 'Super User'
That is to get a exact answer rather than a visual reading. >>> More
Excel - Reuse a trend line to apply to other data

as seen on Super User - Search for 'Super User'
I've obtained a trend line from a particular set of data. What I'd like to do now is to reuse this trend line to predict values from a given pair (x,y) of coordinates. To put it another way, I have one pair (x,y) that I know is correct for sure. I don't know any other point. Let's assume the behavior… >>> More