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
=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