Posted to microsoft.public.excel.worksheet.functions

Biocellguy Biocellguy is offline

external usenet poster

Posts: 14

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Nonlinear R-squared (R2)	Biocellguy	Excel Worksheet Functions	0	July 23rd 07 08:24 PM
Solve nonlinear systems of equations?	Eck	Excel Discussion (Misc queries)	1	April 14th 07 01:05 PM
nonlinear regression	Student in need of DESPERATE HELP	Excel Discussion (Misc queries)	1	February 3rd 07 02:30 PM
Nonlinear regression	Jeremy	Excel Worksheet Functions	0	February 14th 06 07:35 PM
nonlinear regression/ curve fits	geocalc	Excel Discussion (Misc queries)	4	December 30th 05 08:18 PM

All times are GMT +1. The time now is 06:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us