correlation p values

[becd]

Hi
I've used the correlation function on excel to compare two sets of dat
for my thesis. to be able to include this in my write up i need to b
able to quote a p value but i have no idea how to find out what it is
Any ideas?

Thank

 

[Guest]

Have you tried
=ZTEST(array,x,sigma)

 

[Guest]

If you want a p-value for the correlation, assume that
FISHER(CORREL(set1,set2))
is normally distributed with with mean =FISHER(hypothesizedCorrelation) and
standard error 1/SQRT(n-3).

Exact details would depend on what you are trying to show.

Jerry

P. S. FWIW, the ZTEST function rarely gives an appropriate test for equality
of means (which does not seem to be what you want to test anyway), because
you rarely know the population standard deviation, especially if you are
estimating it from data.

 

[becd]

Thanks Jerry, i give that a go