regression input data

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!

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


"Teresa" <Teresa@discussions.microsoft.com> wrote in message
news:82123B6C-E160-434A-879D-182855B3B5E3@microsoft.com...
> 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!