Question

In: Statistics and Probability

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

Solutions

Expert Solution

X Rank(X) Y Rank(Y)
97 11 0 4.5
93 10 0 4.5
90 9 1 13
86 8 1 13
82 7 0 4.5
177 22 4 21
171 21 1 13
155 20 3 19
142 19 1 13
141 18 1 13
60 6 4 21
55 5 1 13
29 4 0 4.5
26 3 0 4.5
20 2 0 4.5
12 1 0 4.5
133 17 1 13
126 16 0 4.5
125 15 4 21
123 14 1 13
119 13 1 13
117 12 2 18
Rank(X) Rank(Y) Rank(X)*Rank(Y) Rank(X)2 Rank(Y)2
11 4.5 49.5 121 20.25
10 4.5 45 100 20.25
9 13 117 81 169
8 13 104 64 169
7 4.5 31.5 49 20.25
22 21 462 484 441
21 13 273 441 169
20 19 380 400 361
19 13 247 361 169
18 13 234 324 169
6 21 126 36 441
5 13 65 25 169
4 4.5 18 16 20.25
3 4.5 13.5 9 20.25
2 4.5 9 4 20.25
1 4.5 4.5 1 20.25
17 13 221 289 169
16 4.5 72 256 20.25
15 21 315 225 441
14 13 182 196 169
13 13 169 169 169
12 18 216 144 324
Sum = 253 253 3354 3795 3691

Conclusion: There is sufficient evidence to conclude that there is a significant linear relationship between x and y because the correlation coefficient is significantly different from zero.


Related Solutions

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
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...
When examining the relation between two variables, when is it better to use the regression coefficient β (beta) instead of the correlation coefficient r to test for significant effects?
Answer the questions below based on the following table:                                         Fatigue                    Vigor                 Sleepiness      Tension                             .36*                     –.31*                       .08 Fatigue                                                          –.73***                   .57** Vigor                                                                                           –.49**         * p < .05, ** p < .01, *** p < .001 The strongest correlation is between _________________________ and ________________________. (Give variable names) The weakest correlation is between __________________________ and ________________________. (Give variable names) The correlation between sleepiness and fatigue is ___________________ (indicate direction) and ________________________ (indicate strength). 1. When examining the relation between two variables, when is it...
Homework Chapter 10: Compute the correlation coefficient State the hypothesis test the hypothesis at a=0.05. Use...
Homework Chapter 10: Compute the correlation coefficient State the hypothesis test the hypothesis at a=0.05. Use Table 1 Determine the regression line equation if r is significant Summarize the results Gestation x 105 285 151 238 112 Longevity y 5 15 8 41 10
Define correlation coefficient. Describe in your own words the difference between correlation coefficient and coefficient of...
Define correlation coefficient. Describe in your own words the difference between correlation coefficient and coefficient of determination.
6. What is the difference between the correlation coefficient and ?2? Why should the correlation coefficient...
6. What is the difference between the correlation coefficient and ?2? Why should the correlation coefficient be -1 and 1? 7. What is the utility of marginal effects in regression models? How are they obtained? 8. What is heterocedasticity and homocedasticity? Explain how to detect and correct the first.
For an inverse relationship between two variables, the sign of the correlation coefficient is "+" TRUE...
For an inverse relationship between two variables, the sign of the correlation coefficient is "+" TRUE OR FALSE
The correlation coefficient is a unitless measure of the strength of the linear relationship between two...
The correlation coefficient is a unitless measure of the strength of the linear relationship between two quantitative variables a unitless measure of the strength of the linear relationship between two categorical variables measured in the same units as the larger quantitative variable measured in the same units as the smaller quantitative variable A random sample of 15 weeks of sales (measured in $) and 15 weeks of advertising expenses (measured in $) was taken and the sample correlation coefficient was...
1. If the coefficient of determination is 25%, the correlation between two continuous variables is a)...
1. If the coefficient of determination is 25%, the correlation between two continuous variables is a) -5 b) 5 c) -.25 d) .25 e) a or b f) none of the above 2. To assess the correlation between height and weight, one should use a) spearman correlation b) regression equation c. pearson correlation d) point biserial correlation 3. For a computed r = -0.547, given a dataset of n = 16, alpha = .05, and two-tailed significance, one should fail...
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?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT