(which equals R 2 given in the regression Statistics table). R 2 = 1 - Residual SS / Total SS (general Where yhat i is the value of y i predicted = Residual (or error) sum of squares + Regression (or explained) sum The ANOVA (analysis of variance) table splits the sum of It is not to be confused with the standard error of y itself (fromДescriptive statistics) or with the standard errors of the regression It is sometimes called the standard error of the regression. The standard error here refers to the estimated standard deviation (when squared gives correlation squared = 0.8 = R 2 ).Дiscussed later under multiple regression. The Regression Statistics Table gives the overall goodness-of-fit Number of observations used in the regression (n) This is the sample estimate of the standard deviation of the The regression output has three components:ДЄdjusted R 2 used if more than one x variable Regression of CARS on HH SIZE led to the following Excel output: This requires the Data Analysis Add-in: see Excel 2007: Access and Activating theДў007: Two-Variable Regression using Data Analysis Add-in REGRESSION USING THE DATA ANALYSIS ADD-IN This handout is the place to go to for statistical inference for Fitted values and residuals from regression line.Predicting y given values of regressors.

Testing overall significance of the regressors.

Testing hypothesis of slope parameter equal to a particular value.

Testing hypothesis of zero slope parameter.

Confidence interval for the slope parameter.

Interpreting the regression coefficients table.

Interpreting the ANOVA table (often this is skipped).

Interpreting the regression statistics.

This January 2009 help sheet gives information on EXCEL 2007: Statistical Inference for Two-variable Regression EXCEL 2007: Statistical Inference for Two-variable Regression A.

How does excel calculate standard error