Description:

1. Open an Excel spreadsheet.

2. Write a table of data. There should be 10 participants and 2 variables being measured for each participant, for a total of 20 observations. Your table of data will be 2 x 10 = 20 cells, with numbers that you have made up appearing in each cell.

3. Create a scatter plot showing this data, as follows:

- highlight the data.
- click the chart icon and follow directions to create an XY Scatter plot.
- Note: the standard scatter plot in Excel has horizontal grid lines. Please remove them as follows: Right-click on a blank area of the chart; click on Chart Options; click on Gridlines; uncheck Major Gridlines.

4. Compute a correlation coefficient showing the correlation between your two sets of numbers, as follows:

- highlight a blank cell.
- use the function command to create a correlation coefficient.
- follow the instructions to enter the locations for the two arrays of numbers and produce the correlation coefficient.
- for clarity, enter a descriptive label in the cell above or to the left of the correlation coefficient that describes what it is (e.g., Pearson Correlation Coefficient between scores on X and scores on Y).

5. Arange your spreadsheet so the data, the chart, and the correlation coefficient will all print on one page. Print this page.

6. Revise your numbers to make a higher correlation; compute the correlation coefficient (it will probably re-compute by itself); print this page; hand-write on the page what numbers you changed and how the correlation changed.

7. Revise your numbers to make a lower correlation; compute a correlation coefficient (it will probably re-compute by itself); print this page; hand-write on the page what numbers you changed and how the correlation changed.

8. Rrevise your numbers to make a negative correlation; compute a correlation coefficient (it will probably re-compute by itself); print this page; hand-write on the page what numbers you changed and how the correlation changed.

9. Staple the FOUR pages together and submit them with the standard heading on the top page.

10/5/04