Correlation

G

Guest

I have many columns of data that i would like to measure the correlations between (a total of 146 columns of data). Below the data, I want to create a correlation matrix using the "=correl" function. Is there an efficient way to type this formula and have it anchor correctly for copying and pasting across the 146 rows and columns? Obviously in a cell that is measuring the correlation between the same two columns, the number will equal 1 (which will create a downward diagonal value of 1 across the matrix). If my question makes sense to anyone, I would appreciate a suggestion. Thanks.
 
J

Jerry W. Lewis

Using the CORREL function on a matrix that large could be rather
painful, but the Analysis ToolPak has a Correlation tool that will
calculate the matrix for you.

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Three variable correlation 2
Three Variable Correlation 1
easy correlation computations with lags 1
Help on creating a correlation matrix in Excel 0
How to create a correlation matrix in excel? 6
How to determine the optimized correlation between 2 sets of data? 1
Correlation matrix 7
Automating Calculation of Lagged Cross Correlations between Variables 1

Top