Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 524
Default PEARSON versus CORREL

The help text for these two functions sure looks similar (in Excel
2003). Are they in fact the same function, or is there some
difference between them that I'm missing?

Thanks!

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: PEARSON versus CORREL

Hi Stan,

While PEARSON and CORREL may seem similar, they are actually two different functions in Excel.

PEARSON is used to calculate the Pearson correlation coefficient between two sets of data. This coefficient measures the strength and direction of the linear relationship between two variables. The result of PEARSON will always be a value between -1 and 1, where -1 indicates a perfectly negative correlation, 0 indicates no correlation, and 1 indicates a perfectly positive correlation.

On the other hand, CORREL is also used to calculate the correlation coefficient between two sets of data, but it can handle multiple sets of data at once. The result of CORREL is also a value between -1 and 1, but it can be an array of values if multiple sets of data are used.

In summary, PEARSON is used for calculating the correlation coefficient between two sets of data, while CORREL can handle multiple sets of data at once.
  1. Use PEARSON to calculate the correlation coefficient between two sets of data.
  2. Use CORREL to calculate the correlation coefficient between multiple sets of data.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default PEARSON versus CORREL

Have a look here.

http://support.microsoft.com/kb/828129

Mike

"Stan Brown" wrote:

The help text for these two functions sure looks similar (in Excel
2003). Are they in fact the same function, or is there some
difference between them that I'm missing?

Thanks!

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 524
Default PEARSON versus CORREL

Fri, 9 Nov 2007 04:23:01 -0800 from Mike H
:
"Stan Brown" wrote:

The help text for these two functions sure looks similar (in Excel
2003). Are they in fact the same function, or is there some
difference between them that I'm missing?


Have a look here.

http://support.microsoft.com/kb/828129


Thank you.

I wonder: why there were two functions with different implementations
to do the same thing?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/
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
CORREL versus COVAR/STDEV^2.......why different? Mike Excel Discussion (Misc queries) 2 September 6th 06 08:25 PM
Excel Functions Correl and Pearson are identical DanR Excel Worksheet Functions 0 February 21st 06 07:35 AM
Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(. Emmanuel Excel Worksheet Functions 3 November 12th 05 04:33 PM
CORREL versus r-squared Shell Excel Worksheet Functions 3 March 24th 05 07:51 PM
Thank you Chip Pearson Michael Excel Discussion (Misc queries) 3 February 5th 05 09:35 PM


All times are GMT +1. The time now is 10:03 AM.

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

About Us

"It's about Microsoft Excel"