• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Correlation in Excel, separate for different countries (Solve)

Excel_beginner

New Member
Since correlation analysis isn't available in pivot tables, how would I go about showing Pearson r (correlation coefficient) for every country in my dataset? Imagine it as a pivot table in Excel where country would be used as a filter.

=CORREL(x,y). How can change this formula in order to calculate the correlation for let's say USA?
My data looks like the this, it's a big file with many counties. Here is just an example.

Country name------Var X------Var Y


 
Back
Top