PDA

View Full Version : Solved: How to test statistical signifiance of correlation in Excel



Hamond
02-21-2011, 10:02 AM
Hi,

I have ran some correlation analysis and obtained correlation coefficents against series Y:

series X 0.82
series M 0.89

I would like to test that correlation for series M is statistically signifciantly different from the correlation for series X at the 95% confidence level.

Does anyone know what statistical function to use excel to do this and what parameters I need to enter?

Thanks,

Hamond

IBihy
02-21-2011, 10:34 AM
Hello Hamond,

hope I'm not completely off on this, one test for independence I know the Chi-Square test. There is a worksheet function in Excel for that.
Search in Excel help for CHI, and it'll display the results (CHITEST, CHIINV, CHIDIST).

HTH,
Isabella

IBihy
02-21-2011, 10:36 AM
Addendum: Or rather, FTEST? I'm not too good at statistics.

Hamond
02-23-2011, 03:09 PM
Hi Isabella,

I don't think it is either of these, defo not chi sqaure as this is a non parametric test.

Could be f-test or t-test or something else!

mancubus
02-23-2011, 03:31 PM
may help...

http://www.mathkb.com/Uwe/Forum.aspx/statistics/9700/Comparing-Two-Correlation-Coefficients