View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biocellguy Biocellguy is offline
external usenet poster
 
Posts: 14
Default 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.