| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MAXIMUM # OF X VARIABLES USED FOR MULTIVARIATE REGRESSION?
When conducting a multivariate regression in excel, what is the maximum
number of x variables that can be used? Thanks for your assistance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MAXIMUM # OF X VARIABLES USED FOR MULTIVARIATE REGRESSION?
WA wrote...
When conducting a multivariate regression in excel, what is the maximum number of x variables that can be used? You'd think it should be mentioned in Excel's online help, but it ain't. Trial & error shows LINEST and LOGEST functions support 16 sets of independent variables but return errors when passed more than 16. As for the number of observations, it supports more than 1,000. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MAXIMUM # OF X VARIABLES USED FOR MULTIVARIATE REGRESSION?
Thanks for your rapid response - you mentioned over 1000 observations, do you
have a precise figure? "Harlan Grove" wrote: WA wrote... When conducting a multivariate regression in excel, what is the maximum number of x variables that can be used? You'd think it should be mentioned in Excel's online help, but it ain't. Trial & error shows LINEST and LOGEST functions support 16 sets of independent variables but return errors when passed more than 16. As for the number of observations, it supports more than 1,000. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MAXIMUM # OF X VARIABLES USED FOR MULTIVARIATE REGRESSION?
WA wrote...
Thanks for your rapid response - you mentioned over 1000 observations, do you have a precise figure? No. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MAXIMUM # OF X VARIABLES USED FOR MULTIVARIATE REGRESSION?
The limit appears to be 17 coefficients, which would be 16 x variables if an
intercept is estimated, or 17 x varaibles if no intercept is estimated. Jerry "Harlan Grove" wrote: WA wrote... When conducting a multivariate regression in excel, what is the maximum number of x variables that can be used? You'd think it should be mentioned in Excel's online help, but it ain't. Trial & error shows LINEST and LOGEST functions support 16 sets of independent variables but return errors when passed more than 16. As for the number of observations, it supports more than 1,000. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multivariate regression | Excel Worksheet Functions | |||
| How do I calculate maximum with variables. | Excel Worksheet Functions | |||
| Regression with text variables | Excel Discussion (Misc queries) | |||
| Regression with more than 16 variables | Excel Discussion (Misc queries) | |||
| How do you populate the X variables in Regression analysis for mo. | Excel Worksheet Functions | |||
Linear Mode
