| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
r2 result in LINEST Excel 97 v Excel 2003
I use LINEST to derive a multiple regression formula in Excel 2003.
I have to share this with a client who uses Excel 97. While the results for the gradients (m) are the same, the coefficient of determination (r2) in Excel 97 is lower than that given in Excel 2003. The results are 0.87 and 0.97 respectively. Does anyone know why the two versions give different answers? Which if any is the more reliable calculation? Regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert number into words | Excel Discussion (Misc queries) | |||
| Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
| How do I open a Quattro Pro 7.0 file in Excel 2003 | Excel Discussion (Misc queries) | |||
| Conversion | Excel Worksheet Functions | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
