From the course: Financial Forecasting with Big Data

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Use Excel for regressions

Use Excel for regressions - Microsoft Excel Tutorial

From the course: Financial Forecasting with Big Data

Start my 1-month free trial

Use Excel for regressions

“

- [Instructor] It's time to use a hedonic prediction. I'm in the 03_04 folder looking at the begin employee theft file. We've got a basic question. Jack has assigned employees one, three, six and seven to work today in the store. Manager three is also working. What should we expect the over/under on the register to be at the end of the day? In other words, should we expect the register to have more cash in it versus sales? Or should we expect the register to have less cash? We're going to use the regression that we ran previously to answer this question. So, I'm going to set up our variables as follows. Cash in register is going to be the variable that we're trying to predict. Employee one, employee three, employee six and employee seven are all working. And manager three is working. Now, I've got my values. I'm going to use my Y and my Xs here. In this case, employee one, three, six and seven and manager three are all working so each of them get a one. I'm not showing this, but if we…

Contents