I need a simple way to create a set of correlations based on a
criteria. For instance, lets say column A is STATE, column B is INCOME
and column C is EDUCATION LEVEL. There are thousands of records but
only 50 states. To calculate the overall correlation between INCOME
and EDUCATION LEVEL, I'd use the formula CORREL(INCOME, EDUCATION
LEVEL). But I need to calculate the correlation for each state in a
table. How could I incorporate this into my formula?

Thanks.

- John