Question

Use the Eli Orchid data to extend your regression model in P2 with the dummy variable representing the weekend.

 1. In column B calculate the values of the dummy variable representing weekend (w). The dummy variable w is set to 1 for Saturday or Sunday. Otherwise it is set to 0. DO NOT type the values in - you must build a formula.

2. Run the regression multiple analysis. Generate the regression output in a yellow cell below.

3. Use the estimated regression equation y^ = b0 + b1*t + b2*w to calculate the predicted demand for Monday, 6/24/2019 (day 57). Use the designated cells below.

Can you show in excel how to do it like formulas for each column etc.