From the course: Financial Forecasting with Big Data
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Predict values with regression analysis - Microsoft Excel Tutorial
From the course: Financial Forecasting with Big Data
Predict values with regression analysis
- [Narrator] Let's talk about a specific example using regression analysis. In this case, we're looking at predicting the estimated home heating oil use by a particular customer, based on three different factors. A variable that we call the intercept, the temperature outside, and the level of insulation in the customer's house. Let's focus on these bottom three rows in the table, and in particular, focus on the column labeled Coefficients. These coefficients tell us the impact on home heating oil use in a particular month given the temperature outside and the insulation level of the person's house. Now, let's see how we would use this in a prediction. There's three steps to the prediction, run the regression, which I showed you the output from the previous slide, then we're going to save those coefficients. That was those last three rows of data. For example, this will help us to measure the impact for each additional inch of insulation in a person's house. And then, finally, we're…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.