Analysis Tool: Basic Linear Correlation and Regression (Direct-Entry Version)

The following pages calculate r, r-squared, regression constants, Y residuals, and standard error of estimate for a set of N bivariate values of X and Y, and perform a t-test for the significance of the obtained value of r. Values of X and Y are entered directly into individual data cells. This page will also work with samples of any size, though it will be rather unwieldy with samples larger than about N=50. As the page opens, you will be prompted to enter the value of N.