ExcelBanter - Nonlinear R-squared (R2)

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Nonlinear R-squared (R2) (https://www.excelbanter.com/excel-worksheet-functions/151367-nonlinear-r-squared-r2.html)

Biocellguy

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.

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