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