Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I was comparing results given between linest() and logest() for the same
group of data. For linest(), I had a std error of 7.02 and an r squared of ..6906, for logest(), I had a std error of 1.2689 and r squared of .346. Does logest() report the numbers in another form? When I tested the real results against the formula y = b* (m1^x1) *....*(mn^xn), the std error should be higher. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using linest or logest for non-linear equations | Excel Discussion (Misc queries) | |||
LOGEST Function - explantion of calculations | Excel Worksheet Functions | |||
Calculating slope, intercept, LOGEST with empty cells in data | Excel Worksheet Functions | |||
Logarithmic curve formulas in charts and LOGEST fx values? | Excel Worksheet Functions | |||
LINEST, LOGEST, GROWTH or TREND?? | Excel Discussion (Misc queries) |