Enter the reference for the range of dependent data. The range must consist of a single column of data.
Enter the reference for the range of independent data. Microsoft Excel orders independent variables from this range in ascending order from left to right. The maximum number of independent variables is 16.
Select if the first row or column of your input range or ranges contains labels. Clear if your input has no labels; Excel generates appropriate data labels for the output table.
Select to include an additional level in the summary output table. In the box, enter the confidence level you want applied in addition to the default 95 percent level.
Select to force the regression line to pass through the origin.
Enter the reference for the upper-left cell of the output table. Allow at least seven columns for the summary output table, which includes an anova table, coefficients, standard error of y estimate, r2 values, number of observations, and standard error of coefficients.
Click to insert a new worksheet in the current workbook and paste the results starting at cell A1 of the new worksheet. To name the new worksheet, type a name in the box.
Click to create a new workbook and paste the results on a new worksheet in the new workbook.
Select to include residuals in the residuals output table.
Select to include standardized residuals in the residuals output table.
Select to generate a chart for each independent variable versus the residual.
Select to generate a chart for predicted values versus the observed values.
Select to generate a chart that plots normal probability.