08-16-2007, 02:43 PM
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??????