“During Week 5, using your actual scores for Weeks 1, 2, 3, and 4 and your forecast values, calculate a
regression equation, r, and R2 for this data.
Prepare a case study document to answer the following questions. The case study should have a cover page,
intro, and body that follows APA format. If a reference is used, such as our text, then a reference page should
be included, and appropriate citation(s) should appear in the body of your case study. See the sample case
study above for guidance.
- What data did you use in your regression equation? Which is the independent and dependent variable?
- What are the regression equation, r, and R2 for your data?
- Statistically, what do r and R2 tell you?
- Based on your empirical evidence, how well did you forecast your results? Justify your response.
You can use any method you like to complete this assignment; however, you need to show your work. Two
items in Excel are useful. The correl function will return the correlation coefficient and add-in called “Data
Analysis” has a function called regression that will provide all the rest of the information you should need.