Question

a) Calculate the Pearson Correlation Coefficient for these two variables and b) test whether the correlation is significantly different from 0. Run the test at a 5% level of significance. Give each of the following for part b to receive full credit: 1) the appropriate null and alternative hypotheses; 2) the appropriate test; 3) the decision rule; 4) the calculation of the test statistic; and 5) your conclusion including a comparison to alpha or the critical value. You MUST show your work to receive full credit. Partial credit is available. Either 1. upload an image or pdf with your handwritten work or 2. upload an Excel file with your work in Excel. Refer to the instructions at the beginning of the quiz. If the instructions are not followed, you will receive a 0 for this question. ID 1 2 3 4 5 6 Length of Total Stay Charge (x) (y) 5 6 7 5 9 7.2 10 8 12 9.4 15 7.9

Answer 1

PAGE NO.: DATE: / / Answer • Here we have given Length of stay c«) - Toral charge ay 9.4 7.9. a) we have to és Syntax compute, pearson correlation compule conrelativa in coefficient excel to r = CORREL ( array to array 21 8. r = 0.74 Now we different need from to a test, at correlation is significantly 5% significance. on Hypothesis : Ho & rzo Hirto 8. The formula for computing test statistic - t= rx Jn-2 Sloga 1. t= 0.74 6-2 51-0.742 ABHIJEET

PAGE NO: DATE: 1 Lt: 2.20 __Here degrees of freedom an- 2 = 6-2 = 4 We compute p-value from test statistic t - Syntax in Excel - - P-value = TDISI CX deg freedom tails - E IDISI(2.2014+27 | p- value = 0.09 o.o5 Here 80 p-value z Accept to condusion - Correlation not is i significantly different from ie Ho : ro