regression input data

T

Teresa

On the Regression dialogue box, I get different results whenever select and
deselect the Label option.

Can someone please tell me why or explain that variable? Thanks!
 
M

Mike Middleton

Teresa -

If you click the Help button of the Regression dialog box, you'll see:

"Labels: 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."

For example, if your data input range has n values, and if you select
Labels, the first data value will be used as a label, and the remaining n-1
values will be used for the regression.

- Mike
www.mikemiddleton.com
 
Top