Investigate cause-and-effect relationships utilizing regression analysis Prompt: Your studies focus on using statistical regression to forecast future demand. Do not try to complete this homework assignment without understanding the concepts involved with forecasting using statistical regression. Once you have a good understanding of how regression works, download the attached Excel Template onto your computer. You will use this template for your assignment. Begin by opening the Excel File and read through the Scenario at the top of the page, then notice there are tabs at the bottom of the workbook that constitute your homework assignment. There are three different Task-groups. Next, take a look at each section in the Excel book and scroll down through the spreadsheet, you will notice in the far left column, there are several tasks for you to complete on each tab. Next, hyperlinked directly below are several YouTube videos that will aid you in completing the assignment tasks. They are all short (under 10 minutes), so watch them all in succession before you start your homework. Then, as you start each Tab in the Excel Workbook, keep a copy of the appropriate video handy, each assignment almost exactly mirrors these videos; albeit with different scenarios. Regression Forecasting Resources: -Using Excel to calculate a correlation coefficient || interpret relationship between variables (5:21 Minutes) https://www.youtube.com/watch?v=sGlsdHD-lcA -(Linear) Regression Equation Excel 2016 (4:35 Minutes) https://www.youtube.com/watch?v=_QnsH74zXhA -Multiple Linear Regression Equation using Excel 2016 (7:15 Minutes) https://www.youtube.com/watch?v=icipgz8T7dw -Regression with a Dummy Variable using Excel (7:23 Minutes) https://www.youtube.com/watch?v=TBJsEb2UCPs
