How to Get CORREL from Fourth Order Equation

[sdruley]

=LINEST(G148:G153,F148:F153^{1,2,3,4})

I used the above equation and it generated the coefficients and intercept for a fourth order polynomial and placed them on the worksheet. So far so good, but I can't remember how to get the R squared value for the same graph and put it on the worksheet as well.
Any clue, anyone?

 

[shg]

=LINEST(G148:G153, F148:F153^{1,2,3,4}, , TRUE)

First column in third row of output.

 

[sdruley]

shg,

Like a true Excel champion. I forgot all about the arguments. Your expertise is so appreciated. Thank you.

sdruley

 

[shg]

You're welcome, Steve.