| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel regression for more than 16 entries
I am trying to run a regression but I have more than 16 entries. Are there
any programs that I can download to fix this? Or what are your suggestions. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel regression for more than 16 entries
According to this site:
http://www.jeremymiles.co.uk/regress...pendix2/excel/ the Excel Add-In Analysis Tool-Pack will allow this funtionality. - KC -- Please remember to indicate when the post is answered so others can benefit from it later. "jesslor" wrote: I am trying to run a regression but I have more than 16 entries. Are there any programs that I can download to fix this? Or what are your suggestions. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel regression for more than 16 entries
jesslor -
The Regression tool (and the LINEST worksheet function used by the Analysis ToolPak Regression tool) are limited to sixteen explanatory ("x" or independent) variables. I am not aware of a downloadable program with more capacity, but you could try your own search at www.google.com. Commercial statistical software includes Minitab and SPSS. - Mike http://www.mikemiddleton.com "jesslor" wrote in message ... I am trying to run a regression but I have more than 16 entries. Are there any programs that I can download to fix this? Or what are your suggestions. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel regression for more than 16 entries
You could roll your own along the lines of
http://groups.google.com/group/micro...446fa2eb605d5b The direct limit on MINVERSE is 52 columns (including the column of 1's for the constant term), but unless your x columns are orthogonal, it is quite likely that you would need much more than the available numeric precision to get meaningful results, which is probably why LINEST has a much smaller limit. For example http://groups.google.com/group/micro...9a2bb33e6cdbb8 gives an example where trying to fit a 6th degree polynomial by these direct matrix formulas would fail to give a single correct figure for any coefficient, without more precision than is available in IEEE double precision (used by Excel and almost all other general purpose software). A freely downloadable statistics package that uses a better numeric algorithm than direct matrix formulas is R, which is a dialect of the S language http://www.r-project.org Jerry "jesslor" wrote: I am trying to run a regression but I have more than 16 entries. Are there any programs that I can download to fix this? Or what are your suggestions. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Excel Form Deleting Entries | Excel Discussion (Misc queries) | |||
| Excel: Clear all cell entries EXCEPT formulas? | Excel Discussion (Misc queries) | |||
| How do I perform multiple regression in Excel using two independe | Excel Worksheet Functions | |||
| Duplicate entries in an excel list? | Excel Discussion (Misc queries) | |||
Linear Mode
