PC Review


Reply
Thread Tools Rate Thread

array formula for max of Pearson correlation

 
 
Mika
Guest
Posts: n/a
 
      9th Sep 2007
HI,

IŽd like to "compact" the following column in a single cell value
using array formulas, if that is possible.

The columa A is filled with results of a certain function, and column
B has the Pearson correlation of that column in this way.

b1: =pearson(a1:a5,a2:a6)
b2: = pearson(a1:a5,a3:a7)
..
..
b100=pearson(a1:a5,a101:a105)

Then, what I really need is the max of those b cells, so
c1=max(b1:b100). The question is, can I avoid the creation of column
b, with something like :
c1={max(pearson(a1.....))}, if it is possible I canŽt find the right
sintax...

Thanks in advance for your time
Mika

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pearson Chi Square Formula for split testing tbh Microsoft Excel Discussion 0 14th Apr 2009 06:14 PM
Chip Pearson's NewWorkDays formula Pete Rooney Microsoft Excel Misc 9 9th Aug 2008 01:57 AM
how i calculate pearson correlation coefficient for excel graph =?Utf-8?B?dW5pdmVyc2l0eSBzdHVkZW50IHRoYXQgaXMgbG9z Microsoft Excel Charting 11 18th Sep 2006 04:04 PM
How do I set up a correlation formula? =?Utf-8?B?Q3Jvdzk4NzU=?= Microsoft Excel Worksheet Functions 1 13th Apr 2005 01:02 PM
Array formula based on Chip Pearson's lookup data samples gregork Microsoft Excel Misc 1 8th Feb 2004 10:03 AM


Features
 

Advertising
 

Newsgroups
 


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