Linear Correlation and Regression
DataImport Version
For a sample of N bivariate values of X and Y, this page will calculate:
_{T}
 r = the Pearson productmoment correlation coefficient;_{T}
 r^{2} = the coefficient of determination;_{T}
 the slope of the regression line;_{T}
 the Y intercept of the regression line;_{T}
 the standard error of estimate;_{T}
 the value of t associated with the calculated value of r, along with the corresponding one and twotailed probabilities;_{T}
 the residual for each value of Y, calculated as
residual = Y—(intercept+[slope(X)])_{T}
 the lower and upper limits of the .95 and .99 confidence intervals for the correlation coefficient (rho) that exists within the bivariate population from which the sample is drawn; and_{T}
 the lower and upper limits of the .95 and .99 confidence intervals for the slope of the regression.

 Importing Data via Copy & Paste:_{T}
When importing data from a spreadsheet, the paired values of X and Y must be in the form of two adjacent columns. Within the spreadsheet application, select and copy the two columns of data. Then return to this page, click the cursor into the dataentry field and perform the 'Paste' operation._{T}
 Direct Entry into Data Field:_{T}
Click the cursor into the empty dataentry field, enter the first value of X; then press the space bar one (and only one) time; then enter the value of Y; then press the carriage return key. Do the same for subsequent paired values of X and Y, except that the final entry should not be followed by a carriage return._{T}
 Data Check:_{T}
Make sure that the final line in the dataentry field entry 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 a column.) After the bivariate list has been pasted into the dataentry field, click the cursor immediately to the right of the final entry in the list, then press the downarrow 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».
Data Entry
 Data Report 


Please remember to perform
the Data Check procedure. 
Column 1: X
Column 2: Y
Column 3: Residual


Data Summary_{T}
0.95 and 0.99 Confidence Intervals for rho_{Q}
0.95 and 0.99 Confidence Intervals for the Slope of the Regression_{Q}
Home
 Click this link only if you did not arrive here via the VassarStats main page.

©Richard Lowry 2001
All rights reserved.