| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nonlinear R-squared (R2)
I know for linear trend lines I can use the RSQ function (e.g.
=RSQ(B1:B4,A1:A4)) to calculate R-squared, but is it possible to calculate R-squared for nonlinear trend lines (i.e. logarithmic, polynomial, power, exponential) ? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Solve nonlinear systems of equations? | Excel Discussion (Misc queries) | |||
| nonlinear regression | Excel Discussion (Misc queries) | |||
| Chi squared test | Excel Discussion (Misc queries) | |||
| Nonlinear regression | Excel Worksheet Functions | |||
| nonlinear regression/ curve fits | Excel Discussion (Misc queries) | |||
Linear Mode
