Whole document tree 14.12. Regression ToolThe regression tool performs a multiple regression analysis. Enter a range or list of ranges containing the independent variables into the "X Variables:" entry. These ranges can be grouped into the various independent variables by columns, by rows, or by areas. Select the appropriate option. Enter a single range containing the dependent variable into the "Y Variable:" entry. If the ranges for the independent and dependent variables also contains labels in the first field of each row, column or area, select the " Labels" option. Specify the confidence level in the "Confidence Level:" entry. The default is 95%. To force the regression line or plane to pass through the origin, select the "Force Intercept To Be Zero" option. Specify the output options as described above. If the output is directed into a specific output range, that range should contain at least seven columns and 17 rows more than there are independent variables. Example 14-12. Using the Regression Tool Suppose you want to perform a regression analysis on the data given in Figure 14-43 using v and y as independent variables and u as dependent variable.
The output of this regression analysis is shown in Figure 14-45. |