• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Projecting Trends

On occasion, you might have a range of data and need to make a projection. For instance, in creating a projected profit and loss for next year, you want to estimate revenue based on projected sales. In this case, you have to project the trend that your data is displaying using Excel.

You can create a linear trend that generates a “best fit” straight-line projection, or a growth trend which extends an exponential projection into the future. A simple way to create a trend is as follows.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint