do not try to finish this homework assignment without understanding the concepts involved with forecasting using statistical regression. Once you know how regression works, download the attached Excel Template onto your computer. You will utilize this template for your assignment . Begin by opening the Excel File and reading through the Scenario at the top of the page. Then, notice the 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, look at each section in the Excel book and scroll down through the Spreadsheet; you will notice in the far left column that there are several tasks for you to complete on each Tab. Pace yourself and finish some assignments in the first week; leaving all this homework for week seven can be dangerous.
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 begin 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 the 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)
Instructions:
- Download the template attached below onto your computer.
- You must complete the reading assignments first before you tackle this assignment.
- There are several “Tasks” in the workbook on separate Tabs. Look over the tasks and make sure you understand the Scenario, the data you are given, and the parameters for the regression analysis. If you get lost and can’t figure out how to proceed, message your instructor; we are always glad to help. Before submitting this assignment, scroll down each Tab in succession and ensure you have completed all of the tasks described in the Spreadsheet.
- This week’s assignment is best completed in order while watching the videos above. It is recommended that you have the video open on one side (1/2) of your screen and the homework template on the second half of the screen. That way, you can watch the video and complete the assignment synchronously. Make sense?
- You must use formulas to calculate every answer. No credit will be given if a number is inserted.
- please make sure you cite your references in APA format. Always follow APA formatting and style guidelines (7th edition) to ensure your work is formatted correctly.
- The you tube links below will help. video 1
- video 2
- video 3
- video 4
