Eli Orchid plans to use the data to predict the demand for the upcoming week. An accurate forecast would be helpful in making arrangements for the company's production processes and designing promotions.

The COO of the company approved the initial analysis (Mini Case 1) and asked for the following extensions.

Use the Eli Orchid data to fit a new multiple regression model with dummy variables for days of the week (Mon, Tue, etc.): y^ = b0+ b1x1 + b2x2 + b3x3 + b4x4 + b5x5 + b6x6 + b7t.

1. In columns E-J calculate the values of the dummy variables representing days of the week. DO NOT type in the values - you must build the formulas.

2. Run the multiple regression analysis for this model. Generate the regression output in a yellow cell below (L22). Note that the variable t is also included in the model.

Date Weekday Daily Demand t x1 (Mon) x2 (Tue) x3 (Wed) x4 (Thu) x5 (Fri) x6 (Sat) 4/29/19 Mon 297 1       4/30/19 Tue 293 2       5/1/19 Wed 327 3       5/2/19 Thu 315 4       5/3/19 Fri 348 5       5/4/19 Sat 447 6       5/5/19 Sun 431 7       5/6/19 Mon 283 8       5/7/19 Tue 326 9       5/8/19 Wed 317 10       5/9/19 Thu 345 11       5/10/19 Fri 355 12       5/11/19 Sat 428 13       5/12/19 Sun 454 14       5/13/19 Mon 305 15       5/14/19 Tue 310 16       5/15/19 Wed 350 17       5/16/19 Thu 308 18       5/17/19 Fri 366 19       5/18/19 Sat 460 20       5/19/19 Sun 427 21       5/20/19 Mon 291 22       5/21/19 Tue 325 23       5/22/19 Wed 354 24       5/23/19 Thu 322 25       5/24/19 Fri 405 26       5/25/19 Sat 442 27       5/26/19 Sun 454 28       5/27/19 Mon 318 29       5/28/19 Tue 298 30       5/29/19 Wed 355 31       5/30/19 Thu 355 32       5/31/19 Fri 374 33       6/1/19 Sat 447 34       6/2/19 Sun 463 35       6/3/19 Mon 291 36       6/4/19 Tue 319 37       6/5/19 Wed 333 38       6/6/19 Thu 339 39       6/7/19 Fri 416 40       6/8/19 Sat 475 41       6/9/19 Sun 459 42       6/10/19 Mon 319 43       6/11/19 Tue 326 44       6/12/19 Wed 356 45       6/13/19 Thu 340 46       6/14/19 Fri 395 47       6/15/19 Sat 465 48       6/16/19 Sun 453 49       6/17/19 Mon 307 50       6/18/19 Tue 324 51       6/19/19 Wed 350 52       6/20/19 Thu 348 53       6/21/19 Fri 384 54       6/22/19 Sat 474 55       6/23/19 Sun 485 56