statistical help
Missed-Run Anxiety
A sport psychology researcher wants to examine the relationship between the number of missed long runs for a marathon and cognitive anxiety prior to the marathon for runners. The data is as follows:
|
No. of Missed Long Runs |
Cognitive Anxiety Scores |
|
1 |
5 |
|
6 |
10 |
|
2 |
5 |
|
8 |
11 |
|
5 |
12 |
|
1 |
4 |
|
4 |
3 |
|
6 |
2 |
|
5 |
6 |
|
2 |
1 |
Tasks:
Using the data in the table, run a correlation and then a regression analysis in Microsoft Excel to answer the sport psychology researcher’s questions. Do the following:
· Identify the r value and the r-squared value. Explain what these values mean.
· Predict the anxiety score for a marathon runner if he missed 3 long runs.
Submission Details:
· Show the statistical analysis in a Microsoft Excel worksheet and write the comments in 1 page in a Microsoft Word document.