| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need furmula of R-squared by polynomial regression
urgent to know the furmula of R-squared calculation for polynomial regression.
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need furmula of R-squared by polynomial regression
A Google with search term: polynomial regression "r squared" ; gave 37,000
hits This one look useful for your purpose http://www.stat.wisc.edu/courses/st333-larget/poly.pdf best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Xiaoyoy Yun" <Xiaoyoy wrote in message ... urgent to know the furmula of R-squared calculation for polynomial regression. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need furmula of R-squared by polynomial regression
=LINEST(ydata,xdata^{1,2,3},const,TRUE) returns R^2 in the 3rd row, 1st
column. You can use the INDEX() function to return a value from a specific location of an array. If you want to calculate it from first principles, then R^2 = SSR/SSE While not the numerically best approach (which is not closed form), SSR = SUMSQ(predicteds)-n*AVERAGE(ydata)^2 SSE = SUMSQ(ydata)-SUMSQ(predicteds) If you are not fitting a constant term, then do not subtract the correction term n*AVERAGE(ydata)^2 Jerry "Xiaoyoy Yun" wrote: urgent to know the furmula of R-squared calculation for polynomial regression. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Polynomial Regression with Dates | Excel Discussion (Misc queries) | |||
| Polynomial Regression with Dates | New Users to Excel | |||
| Excel error in R-squared computation in exponential regression | Excel Discussion (Misc queries) | |||
| how to get coefficients for Polynomial regression as for rgp() | Excel Worksheet Functions | |||
| example of a polynomial regression analysis | Excel Programming | |||
Linear Mode
