6. A researcher in animal behavior was interested increasing veterinarian care for dogs. He was particularly interested in the effect of the time spent in the waiting room of a vet's office on the dog's heart rate when first taken in the examination room.
Use the following data to:
compute a correlation coefficient using Excel.
create a scatterplot using Excel.
explain in words what the correlation coefficient tells you about the relationship between time in the waiting room and heart rate. What does it not tell you?
Time in Waiting Room Heart Rate
14 116
15 104
10 102
21 98
11 103
16 114
12 116
18 90
16 103
10 123
7. Which type of correlation would be appropriate to calculate for each of the following sets of data?
- Correlating gender and whether one is a college graduate (yes/no)
- Correlating rank in a graduating class (1st, 2nd, 3rd, etc.) and score on a test of optimism
- Correlating gender and score on a test of optimism.
- Correlating scores on a test of optimism and scores on a test of subjective well-being
- Correlating rank in a graduating class of traditional college students and rank in initial salary offering for first job after graduating