Description:

Refer to the table on page 221 in the text.

Page 1. Using the numbers in Part (a) of the table, use Excel to compute the group means, the difference between the means, and the results of a t test showing the statistical significance of the difference between the means.

Page 2. Using the numbers in Part (b) of the table, make a scatter plot showing the relationship between self-esteem and academic performance. Be sure to label your axes. You can make the scatter plot by hand or you can use Excel. If you use Excel, you can label the axes by hand. However you make the chart, write on the chart by hand an arrow pointing to the point for participant A, and a second arrow pointing to the point for participant B, and label the arrows so I know which is which.

Page 3. Using the same numbers from Part (b) of the table, use Excel to calculate a correlation coefficient.

Part 4. I described this in class as extra credit, but I'd like you to try it. Try to figure out whether the correlation you computed is statistically signficant. There are several ways to do that. Here is one way. Go to the course home page and click on websites and resources, then use #5 and/or #6 to find out whether the correlation you computed is statistically significant. Note: we should use a two-tailed test, but the chart in #5 shows the probabilities for a one-tailed test, so you need to double the numbers in that chart to get the probability for a two-tailed test.