• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Charting in reverse?

S

Shaun

Member
Hi All


Lets say we prepare a basic XY line chart plotting anything over time in the usual fashion, say average temp per day.


Once the chart has been created, is it the possible to work in reverse? If there is an obvious visual upward trend, is there a way that I could somehow draw the trend, which excel then take the data points and adds then to the data table.


The alternative, would be to somehow get excel to find trends for me and create the data but that would require me to define what a trend is and then get excel to find the trends...is that possible? How could I go about doing this?


Anyway I would be interested in thoughs or opinions anyone may have.


Cheers


Shaun
 
Shaun


Excel can find the trends of your data for you

and you can then apply that trend to a new set of data


Trends remove variability in data by typically modelling them as a line/curve made up of a few variables


Typically Y=mX+c for a line of best fit


You can add variability back in by adding random numbers which are representative of the real data


Using Y=mX+rand

where Rand is a function that will return a values within x Standard Deviations based on the original distribution of the data


I'd suggest having a read of:

http://chandoo.org/wp/2011/01/24/trendlines-and-forecasting-in-excel/

http://chandoo.org/wp/2011/01/26/trendlines-and-forecasting-in-excel-part-2/

+

http://chandoo.org/wp/2011/01/27/trendlines-and-forecasting-in-excel-part-3/
 
You must log in or register to reply here.
Back
Top