stats help correlations please

#1
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??????
 

abel

New Member
#3
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!