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?

1. Correlating gender and whether one is a college graduate (yes/no)
2. Correlating rank in a graduating class (1^st, 2^nd, 3^rd, etc.) and score on a test of optimism
3. Correlating gender and score on a test of optimism.
4. Correlating scores on a test of optimism and scores on a test of subjective well-being
5. Correlating rank in a graduating class of traditional college students and rank in initial salary offering for first job after graduating