This assignment focuses on using statistical regression to
forecast future demand. Begin your studies in the Content section
of the classroom by completing the reading and viewing assignments.
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 for you to work on over the next two weeks. 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. Pace
yourself and get some of the assignment done in the first week; it can be
dangerous to leave all of this homework for week 7.
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)
(Linear) Regression Equation Excel 2016 (4:35 Minutes)
Multiple Linear Regression Equation using Excel 2016 (7:15 Minutes)
Regression with a Dummy Variable using Excel (7:23 Minutes)
