correlation p values

[becd]

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

Thanks

[JonR]

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



"becd" wrote:

>
> Hi
> I've used the correlation function on excel to compare two sets of data
> for my thesis. to be able to include this in my write up i need to be
> able to quote a p value but i have no idea how to find out what it is.
> Any ideas?
>
> Thanks
>
>
> --
> becd
> ------------------------------------------------------------------------
> becd's Profile: http://www.excelforum.com/member.php...o&userid=35896
> View this thread: http://www.excelforum.com/showthread...hreadid=556848
>
>

[Jerry W. Lewis]

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" wrote:

>
> Hi
> I've used the correlation function on excel to compare two sets of data
> for my thesis. to be able to include this in my write up i need to be
> able to quote a p value but i have no idea how to find out what it is.
> Any ideas?
>
> Thanks
>
>
> --
> becd
> ------------------------------------------------------------------------
> becd's Profile: http://www.excelforum.com/member.php...o&userid=35896
> View this thread: http://www.excelforum.com/showthread...hreadid=556848
>
>

[becd]

Thanks Jerry, i give that a go