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
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…
Practica mientras aprendes con los archivos de ejercicios.
Descarga los archivos que el instructor utiliza para enseñar el curso. Sigue las instrucciones y aprende viendo, escuchando y practicando.
Contenido
-
-
-
-
-
-
-
-
-
-
-
(Bloqueado)
Extending formula capabilities with array formulas5 min 7 s
-
(Bloqueado)
Counting unique entries in a range with an array formula5 min 51 s
-
(Bloqueado)
Determining frequency distributions with the FREQUENCY function3 min 53 s
-
(Bloqueado)
Flipping row and column orientation with TRANSPOSE5 min 10 s
-
(Bloqueado)
Building analysis via regression techniques with TREND and GROWTH2 min 59 s
-
(Bloqueado)
Using array formulas and the MATCH function for complex lookups5 min 30 s
-
(Bloqueado)
-
-
-
-