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.
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.
There are several “Tasks” in the workbook and they are 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 quite 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 make sure you have completed all of the tasks described in the Spreadsheet.
This weeks assignment is best completed while watching the videos above; in order. 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 simply inserted.
Using Excel to calculate a correlation coefficient || interpret relationship between variables
(Linear) Regression Equation on Excel 2016
How to do Multiple Regression in Excel 2016 for Windows (Job Performance Example)
Creating a dummy variable for regression
