How to find the trend line equation using Excel.

preview_player
Показать описание
For a given data that has a linear trend, with a few clicks, we can find their trend line equation.
Рекомендации по теме
Комментарии
Автор

Did you like this video? Why?
What do you expect to watch in another video?

AlJazariedu
Автор

Amazing! Any idea how to reference the slope of the trendline equation in a separate cell? For example, I'd like to incorporate the slope of the trendline into a separate formula, but don't know how to refer to it so that it updates with any changes to the trendline.

JasonActualization
Автор

How do you use the equation to project the next period(s)??

nicksoltero
Автор

Thank you. You saved me a lot of time.

barboramalikova
Автор

any way to ignore one data point (outlier)

tejas.a