USA: +1(669)289-8683 
Sign in
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 |
||||||
|
8 |
11 |
|||||
|
12 |
||||||
|
4 |
||||||
|
3 |
||||||
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.
|
Calculated the required statistical values using the correct steps and the correct commands in the spreadsheet software. |
|
Interpreted the results of the statistical analysis. |
|
Predicted the value of a variable using the statistical analysis. |
|
Wrote in a clear, concise, and organized manner; demonstrated ethical scholarship in accurate representation and attribution of sources; and displayed accurate spelling, grammar, and punctuation. |
