From the course: Excel Data Analysis for Supply Chain: Forecasting

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Preparing data for multiple regression in Excel

Preparing data for multiple regression in Excel - Microsoft Excel Tutorial

From the course: Excel Data Analysis for Supply Chain: Forecasting

Start my 1-month free trial Buy for my team

Preparing data for multiple regression in Excel

“

- [Instructor] Now, Excel's going to do a lot of the hard work, pretty much all of the hard work, in multiple regression. But it's very particular about what the data is going to look like. So what we're going to need to do is we're going to need to clean up this data. And really, it's not a whole lot that we need to do, but it does need to be done in a particular way. And so the first thing that we're going to do is we have to realize that we're going to be working with things that are lagging. And so when you're living in quarter two, you don't know what the revenues and unemployment and interest rates are in your particular period. So very often what's happening is that the numbers are lagging. These numbers will be reported to you when you are in quarter two. And so that's what this lag over here is about, the fact that we're going to be taking these numbers, and we're going to shift them over one period when we will actually be experiencing them in real life. And I can go ahead…

Contents