ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Steps to performing R2 function with excel (https://www.excelbanter.com/excel-worksheet-functions/188124-steps-performing-r2-function-excel.html)

ICP Jon

Steps to performing R2 function with excel
 
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[_2_]

Steps to performing R2 function with excel
 

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"
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

Steps to performing R2 function with excel
 
Thanks, very helpful. Any that can do least squares regression?

"Jim Cone" wrote:


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"
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?


Jim Cone[_2_]

Steps to performing R2 function with excel
 

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"
wrote in message
Thanks, very helpful. Any that can do least squares regression?



"Jim Cone" wrote:
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"
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?



All times are GMT +1. The time now is 04:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com