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
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