correlation p values
 

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

correlation p values
 

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

correlation p values
 

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

correlation p values
 

Thanks Jerry, i give that a go


--
becd
------------------------------------------------------------------------
becd's Profile: http://www.excelforum.com/member.php...o&userid=35896
View this thread: http://www.excelforum.com/showthread...hreadid=556848