This utility performs computations that determine the correlation and regression between two variables. To use this utility, you must provide the paired x (independent/predictor) and y (dependent/response) values in separate columns. You must also provide the significance level for the hypothesis test for correlation.
For correlation, the following values are computed:
, where t
is the inverse probability distribution of (1 - significance / 2)
in the Student's t distribution with n - 2
degress of freedomFor regression equation Y = b0 + b1 x, the y-intercept b0 and the slope b1 are calculated as follows:


The null hypothesis H0 for a hypothesis test for linear correlation is that there is no linear correlation (ρ = 0), and the alternative hypothesis H1 is that there is a linear correlation (ρ ≠ 0).
For variation, the following values are computed (
is the mean of the y variable values,
is the y value predicted by the regression
equation):




