ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   regression input data (https://www.excelbanter.com/excel-discussion-misc-queries/101192-regression-input-data.html)

Teresa

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!

Mike Middleton

regression input data
 
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" wrote in message
...
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!





All times are GMT +1. The time now is 02:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com