From the course: Excel: Sales Forecasting
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
What do the results mean?
- [Instructor] Now that we've gone through and created a cleaned up data set, we're ready to actually start getting into the meat of our analysis. So let's take a look at how we actually perform regressions and begin to understand the relationships between variables which will set the stage for our forecast. I'm in the zero three zero five begin Excel file. Now you'll see that we've got a set of data here related to car sales, jobless claims, oil prices and CPI data. We might want to understand at the outset, is there some sort of a relationship between these variables? We've been gathering this data on the assumption that jobless claims oil prices and CPI will let us actually forecast car sales, but is there a relationship there to capture? Well, let's find out. Okay, now if we look at the correlations tab, what we're going to do here is go through and establish the correlation between each variable and the other…
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.