Hint before you get started: You will have to reorganize your data into the appropriate groups for both problems to run your analysis! SO pay attention to how many groups there are in each! :)
PROBLEM 1
Using the data below and Excel, compute the F ratio for a comparison between the three levels representing the average amount of time that swimmers practice weekly (Pracctice 1 = less than 15 hour, Practice 2 = 15-25 hours, and 3 = greater than 25 hours) with the outcome variable being their time for the 100-yard freestyle.
Answer the question: Does practice time make a difference? Support your answer with your findings.
Here is an online resources to help if you need it: VIDEO HERELinks to an external site.
If you prefer to Download this lab, click HERE Download HERE.
Practice | Time | Practice | Time |
1 | 58.7 | 2 | 54.6 |
1 | 55.3 | 2 | 51.5 |
1 | 61.8 | 2 | 54.7 |
1 | 49.5 | 2 | 61.4 |
1 | 64.5 | 2 | 56.9 |
1 | 61.0 | 3 | 68.0 |
1 | 65.7 | 3 | 65.9 |
1 | 51.4 | 3 | 54.7 |
1 | 53.6 | 3 | 53.6 |
1 | 59.0 | 3 | 58.7 |
2 | 64.4 | 3 | 58.7 |
2 | 55.8 | 3 | 65.7 |
2 | 58.7 | 3 | 66.5 |
2 | 54.7 | 3 | 56.7 |
2 | 52.7 | 3 | 55.4 |
2 | 67.8 | 3 | 51.5 |
2 | 61.6 | 3 | 54.8 |
2 | 58.7 | 3 | 57.2 |
PROBLEM 2
Using the data below and Excel, answer the following questions:
- Compute the correlation between motivation and GPA.
- Test for the significance of the correlation coefficient at the .05 level using a two-tailed test.
- True or false? The more highly you are motivated, the more you will study. Which did you select and why?
Here is an online resource if you need it: VIDEO HERELinks to an external site.
Motivation | GPA | Motivation | GPA |
1 | 3.4 | 6 | 2.6 |
6 | 3.4 | 7 | 2.5 |
2 | 2.5 | 7 | 2.8 |
7 | 3.1 | 2 | 1.8 |
5 | 2.8 | 9 | 3.7 |
4 | 2.6 | 8 | 3.1 |
3 | 2.1 | 8 | 2.5 |
1 | 1.6 | 7 | 2.4 |
8 | 3.1 | 6 | 2.1 |
6 | 2.6 | 9 | 4.0 |
5 | 3.2 | 7 | 3.9 |
6 | 3.1 | 8 | 3.1 |
5 | 3.2 | 7 | 3.3 |
5 | 2.7 | 8 | 3.0 |
6 | 2.8 | 9 | 2.0 |
[Image unavailable: image.png]
Rubric
Some Rubric (4)
| Criteria | Ratings | Pts | ||
|---|---|---|---|---|
This criterion is linked to a Learning OutcomeCompleted Problem 1 |
| 50 pts | ||
This criterion is linked to a Learning OutcomeCompleted Part 2 |
| 50 pts | ||
Total Points: 100 |
Previous
Next