Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1
536

Input Y Range


Enter a single column of values that will be the response variable in the lin-
ear regression.

Input X Range


Enter up to 16 contiguous columns of values that will be the predictor vari-
ables in the regression.

Labels


Indicate whether the fi rst row of the Y range and that of the X range include
header information.

Constant is Zero


Click to include an intercept term in the linear regression or to assume that
the intercept term is zero.
Free download pdf