Steps to performing R2 function with excel

ICP Jon · May 20, 2008

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 · May 20, 2008

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 · May 20, 2008

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

Jim Cone · May 21, 2008

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?