Calculate Pearson Correlation Coefficient R Using Excel T Test Statistic Testing H0 Popu Q30570398

.

. Calculate the Pearson correlation coefficient r (using Excel),and the t-test statistic for testing

H0 Population correlation=0        VS      Ha    PopulationCorrelation ? 0 using formula

T=r/Sqrt ((1 – r^2)/(n-2)) for the following data

Answer:    r=                                                      T=

Test Conclusion:

Note: If the T value is between -2 and 2 we do not reject H0,otherwise we reject H0