= 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.