Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
Generating Correlated Random Values in Excel | Excel Discussion (Misc queries) |