stats help correlations please

[lukefallon]

Hello All - i am using excel and analyse it for my project. I am looking to find correlations between 30 columns of data. I have found a nice tool in excel 2007 which analyses the whole data set and produces a table which is a 30 by 30 grid showing the Pearson coefficient for all the columns obviously only half of the table is filled with data. This has saved me about a weeks work as i dont have to run a test for 30 x 30 variables, however this information is not much good to me unless i can get the same for the p values aswell. Does anyone know how i can do this to save me running nearly 1000 tests??????

[elnaz]

Hello

please do that by SPSS , i am not sure but i hope it will answer to you .

[abel]

There are some solutions:
1) use VBA in Excel, it would save many time for you;
2) change a package, such as R, you can get result so quickly!