Question

In: Statistics and Probability

Test for correlation between Barley and Corn prices using Spearman's rank correlation method, at the 0.05...

Test for correlation between Barley and Corn prices using Spearman's rank correlation method, at the 0.05 significance level.

Barley Rank Corn Rank d d^2
4.89 4 3.21 1 3 9
4.52 1 3.22 2 -1 1
4.85 2 3.29 4 -2 4
4.97 6 3.23 3 3 9
5.12 9 3.33 5 4 16
4.91 5 3.4 6 -1 1
5.08 8 3.44 8 0 0
4.98 7 3.49 9 -2 4
4.87 3 3.43 7 -4 16

Solutions

Expert Solution

Spearman rank's correlation

n : Number of pairs of data = 9

Barley Rank Corn Rank d d2
4.89 4 3.21 1 3 9
4.52 1 3.22 2 -1 1
4.85 2 3.29 4 -2 4
4.97 6 3.23 3 3 9
5.12 9 3.33 5 4 16
4.91 5 3.4 6 -1 1
5.08 8 3.44 8 0 0
4.98 7 3.49 9 -2 4
4.87 3 3.43 7 -4 16
d2=60

Null hypothesis : Ho : = 0 ; Correlation coefficient = 0

Alternate hypothesis : Ha : ; Correlation coefficient 0

Test statistic :

Test Statistic = 1.5275

Degrees of freedom = n-2=9-2=7

For two tailed test,

For 7 degrees of freedom, P(t>1.5275) = 0.0852

Given level of significance = 0.05

As p-value : 0.1705 > : 0.05; Fail to reject the null hypothesis;

There is not sufficient evidence to conclude that the correlation coefficient not equal to zero.


Related Solutions

Use the Spearman's rank correlation coefficient at the 0.05 CI to investigate the relation between two...
Use the Spearman's rank correlation coefficient at the 0.05 CI to investigate the relation between two variables X and Y below. X Y 97 0 93 0 90 1 86 1 82 0 177 4 171 1 155 3 142 1 141 1 60 4 55 1 29 0 26 0 20 0 12 0 133 1 126 0 125 4 123 1 119 1 117 2
Using excel compute correlation coefficients, correlation matrix and test the significance of the correlation coefficients between...
Using excel compute correlation coefficients, correlation matrix and test the significance of the correlation coefficients between sales with price,  sales with advertisments using alpha 0.05 Sales Price Adver 19.98 14.10 15.19 19.98 18.65 15.19 19.98 18.65 13.87 19.98 18.65 12.83 19.98 18.65 13.16 19.98 18.65 15.19 19.98 18.65 13.92 20.10 18.73 14.42 20.12 18.75 13.83 20.13 18.75 14.50 20.14 18.75 13.87 20.12 18.75 13.64 20.12 13.87 14.31 20.13 14.27 13.85 20.14 18.76 14.20 20.14 18.77 13.64 20.13 13.87 14.33 20.13 14.14...
If you wanted to examine the correlation between rank in high school and rank in college,...
If you wanted to examine the correlation between rank in high school and rank in college, which procedure would you use? What is the difference between multiple regression and simple linear regression?
Test to see if the population correlation coefficient is not equal to zero using significance of 0.05. What are your conclusions?
Consider the following X:            4              7              2              6              6 Y:            6              9              5              5              7 Using XLS, calculate the correlation coefficient for this sample. Test to see if the population correlation coefficient is not equal to zero using significance of 0.05. What are your conclusions?
Using the Chi-Square test for the difference between two proportions, determine (?=0.05) if there is a...
Using the Chi-Square test for the difference between two proportions, determine (?=0.05) if there is a difference in population proportion between male patients using Medicare as their Payer versus female patients using Medicare as their Payer. Be sure to set up the null and alternate hypotheses.   Using the Patients dataset, determine if there is a relationship between length of stay and total charges. Your answer should include the following: Scatter Plot   Linear Regression Equation (with interpretation)   Coefficient of Determination (with...
For the following use the Spearman rank correlation coefficient to test the claim. The overall scores...
For the following use the Spearman rank correlation coefficient to test the claim. The overall scores and the prices for 10 randomly selected computers. The score is based on overall quality of the computer. At a .05 sig. can you conclude there is a correlation between price and score? Utilize excel to show your work. Score 91 94 99 89 86 81 72 85 94 98 86 Price (in dollars) 1250 1500 1495 1150 1195 1685 989 1175 1350 1425...
A researcher is looking at the correlation between depression and anxiety using a two-tailed test with...
A researcher is looking at the correlation between depression and anxiety using a two-tailed test with an alpha level of .05. The researcher finds the following correlation coefficient: r = .22, p = .04. What can the researcher conclude? a. There is a significant positive relationship between depression and anxiety in this sample. b. There is no statistically significant relationship between depression and anxiety in this sample. c. There is a significant negative relationship between depression and anxiety in this...
For each problem test the significance the Spearman Rank Correlation Coefficient. Show your calculation of the...
For each problem test the significance the Spearman Rank Correlation Coefficient. Show your calculation of the test statistic rs. Please show work so i understand how to do it! Exercise 1. Defense and wins. The data in the table below shows the wining percentage and the yards per game allowed in the 2014-15 season for a random sampling of teams. At α = 0.05, can you support the claim that there is a correlation between the winning percentage and the...
For each problem test the significance the Spearman Rank Correlation Coefficient. Show your calculation of the...
For each problem test the significance the Spearman Rank Correlation Coefficient. Show your calculation of the test statistic rs. Exercise 2. Income and commute time. The table below shows the median income ($1000s) and commuter times (minutes) for a random sample of 6 different places. At α = 0.05, can you reject the claim that there is no correlation between median income and commuting distance? City Family income Commute time Woodridge, Illinois 83 27.1 Urbandale, Idaho 82 17.0 La Palma,...
Using a = 0.05, test for a difference in the means.                         group         &nbs
Using a = 0.05, test for a difference in the means.                         group             n          mean             sample std dev                            1                   20       8.3                  3.0                         2                   20       7.2                  3.0             ttest m 1 = m 2 ( VS NE ) t = 1.16
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT