Del curso: Excel 2016: Advanced Formulas and Functions

Accede al curso completo hoy mismo

Únete hoy para acceder a más de 23.100 cursos impartidos por expertos del sector.

Building analysis via regression techniques with TREND and GROWTH

Building analysis via regression techniques with TREND and GROWTH

Del curso: Excel 2016: Advanced Formulas and Functions

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…

Contenido