Steps to performing R2 function with excel

[ICP Jon]

I have instrumentation data that i want to calculate r2 regression statistics
but do not have the time to research the steps. Any help out there?

 

[Jim Cone]

See the Pearson and RSQ functions in Excel help.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"ICP Jon" <[email protected]>
wrote in message
I have instrumentation data that i want to calculate r2 regression statistics
but do not have the time to research the steps. Any help out there?

 

[ICP Jon]

Thanks, very helpful. Any that can do least squares regression?

 

[Jim Cone]

The Trend function does that.
Look up "Statistical Functions" in Excel help to see all.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"ICP Jon" <[email protected]>
wrote in message
Thanks, very helpful. Any that can do least squares regression?