Analyzing existing and future data with trendlines


show more Analyzing existing and future data with trendlines provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth show less
please wait ...

Analyzing existing and future data with trendlines

Excel has quite a few different analytical tools, and one that's associated specifically with charts is what we call a trendline. Now you don't have to be a statistical expert to understand regression analysis, or anything like that, although we will get into that territory a bit. If you're trying to analyze the existing data and possibly even trying to make predictions about where the sales might head in the future, right-click on the line chart entry--and you can also do this with column charts as well--and choose Add Trendline, and immediately you'll see a line there. It's called a linear regression line.

Now you probably at this point do need to know a little bit about regression analysis, and we are not going to be talking about that in any depth here. But if you're familiar with the idea of regression, you might choose Exponential. Usually that's a curved line. Associated with this is also an equation, and if you're familiar with why you have an equa...

Analyzing existing and future data with trendlines
Video duration: 4m 2s 3h 36m Intermediate

Viewers:

Analyzing existing and future data with trendlines provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...