The CORREL function is used to find the correlation between two arrays. Because CORREL ignores text, you can use an array formula as one of the arguments of CORREL to limit it to a subset of the data.
To demonstrate, we’ll need some data. I fired up QuickSampleData to make fifty rows with a [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2011/09/02/conditional-correlation/
Posted
Sep 02 2011, 09:42 AM
by
Daily Dose of Excel