page will calculate the intercorrelations (r
) for any number of variables (V1, V2, V3, etc.) and for any number of observations per variable.
[The logic and computational details of correlation and regression are described in Chapter 3 of Concepts and Applications.]
- Importing Data via Copy & Paste:T
When importing data from a spreadsheet, the values of V1, V2, V3, etc., must be in the form of adjacent columns with no missing values in any of the cells of the columns. (An entry from an empty cell will be interpreted as a zero.) Within the spreadsheet application, select and copy the adjacent columns of data. Then return to this page, click the cursor into the data-entry field and perform the 'Paste' operation. Do not be alarmed if the result of the 'Paste' operation appears to be an incoherent jumble; your computer will be able to sort it all out.T
Note that there is also a field into which you can optionally enter identifying names of the variables V1, V2, V3, etc. To do this, click the cursor into the name field, type in the name of Variable 1, press the carriage return key; then type in the name of Variable 2, press the carriage return key; and so forth.T
- Data Check:T
Make sure that the final line in the data-entry field is not followed by a carriage return. (An extra carriage return at the end of the list will be interpreted as an extra data entry whose value is zero. Importing data via the copy and paste procedure will almost always produce an extra carriage return at the end of the pasted values.) After the columns from the spreadsheet have been pasted into the data-entry field, click the cursor immediately to the right of the final entry in the list, then press the down-arrow key. If an extra line is present, the cursor will move downward. Extra lines can be removed by pressing the down arrow key until the cursor no longer moves, and then pressing the 'Backspace' key (on a Mac platform, 'delete') until the cursor stands immediately to the right of the final entry.T
- After verification of data entry, click the button labeled «Calculate.» The results of the calculation will be displayed on a new page in the current browser frame. To return from there to the present page, click the «Back» button on your browser.
||Click this link only if you did not arrive here via the VassarStats main page.
©Richard Lowry 2001-
All rights reserved.