Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,549
Default 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?
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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?

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,549
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How many steps of Macros is support in Office Excel?? Chip Pearson Excel Discussion (Misc queries) 0 January 4th 08 08:25 PM
Copy function with Excel 2003 not performing correctly wtztips Excel Worksheet Functions 2 June 11th 07 05:06 PM
Performing a function on visible cells only in a range creative Excel Discussion (Misc queries) 2 April 9th 07 05:14 PM
Steps to deleting decimel in excel-ex. 3.24 to 324 using excel Excel Discussion (Misc queries) 2 November 5th 05 02:28 AM
Performing a function on a column of variable length BeenThereGotLost Excel Worksheet Functions 3 July 1st 05 02:50 PM


All times are GMT +1. The time now is 07:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"