Instructions

Please complete the required tasks in each of the worksheets provided. You may add calculation or check cells but you may NOT add/change positions/delete input and output cells. input cell enter data only (no formulas) output cell enter formulas only (no data) The cell highlited yellow indicates the cell where the analysis output should be generated. See example below. [insert regression output in a yellow cell below] Do not change the names of the tabs (P1, P2, ...); DO NOT ADD any worksheets. Do not use the following tools in any sheets: File Home Insert Pag X Near Te Rexply Sort Filter Advanced c PivotTable Recommended Table Sort & Filter Pivot Tables TablesDaily Date Demand Eli Orchid has designed a new pharmaceutical product, Orchid Relief, which improves the night sleep. Before 4/29/2019 Mon 297 4/30/2019 Tue initiating mass production of the product, Eli Orchid has been market-testing Orchid Relief in Orange County 293 over the past 8 weeks. The daily demand numbers are recorded in the table to the left. 5/1/2019 Wed 327 5/2/2019 Thu 315 Build a model that returns the daily demand corresponding to the date provided. 5/3/2019 Fri 348 5/4/2019 Sat 447 5/5/2019 Sun 431 5/6/2019 Mon 283 5/7/2019 Tue 326 5/8/2019 Wed 317 5/9/2019 Thu 345 Date Daily Demand 5/10/2019 Fri 355 5/8/2019 build the formula and test it on different dates 5/11/2019 Sat 428 5/12/2019 Sun 454 hint: use one of the formulas covered in Chapter 10 5/13/2019 Mon 305 5/14/2019 Tue 310 5/15/2019 Wed 350 5/16/2019 Thu 308 5/17/2019 Fri 366 5/18/2019 Sa 460 5/19/2019 Sun 427 5/20/2019 Mon 291 5/21/2019 Tue 325 5/22/2019 Wed 354 5/23/2019 Thu 322 5/24/2019 Fri 405 5/25/2019 Sat 442 5/26/2019 Sun 454 5/27/2019 Mon 318 5/28/2019 Tue 298 5/29/2019 Wed 355 5/30/2019 Thu 355 5/31/2019 Fri 374 6/1/2019 Sat 447 6/2/2019 Sun 463 6/3/2019 Mon 291 6/4/2019 Tue 319 6/5/2019 Wed 333 6/6/2019 Thu 339 6/7/2019 Fri 416 6/8/2019 Sat 475 6/9/2019 Sun 459 6/10/2019 Mon 319 6/11/2019 Tue 326 6/12/2019 Wed 356 6/13/2019 Thu 340 6/14/2019 Fri 395 6/15/2019 Sat 465 6/16/2019 Sun 453 6/17/2019 Mon 307 6/18/2019 Tue 324 6/19/2019 Wec 350 6/20/2019 Thu 348 6/21/2019 Fri 384 6/22/2019 Sat 474 6/23/2019 Sun 485