From the course: Python in Excel: Data Outputs in Custom Data Visualizations and Algorithms

Unlock this course with a free trial

Join today to access over 25,400 courses taught by industry experts.

Determining trends for linear regression with Excel functions

Determining trends for linear regression with Excel functions

From the course: Python in Excel: Data Outputs in Custom Data Visualizations and Algorithms

Start my 1-month free trial Buy for my team

Determining trends for linear regression with Excel functions

“

- [Instructor] One way we can find trends in data is by running regression models. For example, if we have data points on a scatterplot, we can use these regression models to fit a line that best predicts future data points. Linear regression is when we run a straight line that fits these data points. The good news is that while we can calculate linear regression model coefficients in Python, we can also set them up directly in Excel. Especially from an Excel perspective, it's more efficient to use built-in Excel functions and functionalities to do this. There's also a scatterplot on the linear regression tab in Excel. This is a one-dimensional model because we're referencing the low temperature as the independent variable plus the interceptor bias as the other coefficient. Just to see how this works, let's say that we have the high temperature as this dependent Y variable and the low temperature as the independent X variable. We can calculate the intercept of a one-dimensional linear…

Contents