Question

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	1300

a.Identify and state the null and alternate hypothesis,

b. find the test statistic

c. decide whether to reject the null hypothesis

d. form an analysis of your findings.

Answer 1

a. H0: there is no correlation between score and price vs H1: not H0

b.to test the above-mentioned hypotheses, we use the test statistic

   follows distribution under H0.

here observed t=1.685

c)critical value of t=

=2.22

Hence |observed t|=1.685<2.22

hence we do not reject null hypothesis.

d)Hence price does not depend on quality based score of the computer.