From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Building analysis via regression techniques with TREND and GROWTH

Building analysis via regression techniques with TREND and GROWTH

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Building analysis via regression techniques with TREND and GROWTH

“

- In this worksheet called TREND we're seeing a chart to the right depicting the sales. That's from the data in column B. And we're tracking sales over a multi-year period, month by month, all the way to the end of 2015. Now, if you're familiar with regression techniques, you might want to add a trend line. And you can do this by right-clicking the line in the chart, as I'm doing right now, and choosing Add Trendline. And as soon as you do this, you will automatically get what's called a linear trendline. You see that off to the right. And if you know something about regression analysis, you would know probably by looking at the r-squared number, you could add that to the chart if you wanted to, display the r-squared value on the chart. You could do that. And let me momentarily move this dialog box out of the way by dragging at the title bar. And we see that's 0.85, fair. Those who are in the know, know what that means. We could change this to be exponential. We'll get a different…

Contents