Obs Price Dividend 1234 21.00 3.34 23.12 3.56 32.99 0.46 35.28 8.39 5 37.69 0.77 6...

Transcribed Image Text:

Obs Price Dividend 1234 21.00 3.34 23.12 3.56 32.99 0.46 35.28 8.39 5 37.69 0.77 6 37.97 8.86 7 38.01 8.02 8 39.93 8.43 9 40.84 6.63 10 41.68 8.36 11 45.66 9.43 12 51.60 10.11 13 56.48 11.71 14 57.18 13.98 15 57.93 10.72 16 59.99 10.03 17 60.34 13.23 18 61.27 10.93 19 62.56 8.37 20 63.70 9.69 21 67.27 17.33 22 67.96 16.90 23 68.06 14.46 24 68.27 11.04 25 69.83 22.25 26 71.66 15.00 27 73.11 25.67 28 78.73 12.14 29 81.90 18.55 30 84.09 18.26 32.14 Following is information on the price per share and the dividend for a sample of 30 companies. Company Price per Share 1 2 $21.00 23.12 Dividend $ 3.34 3.56 39 81.90 40 84.09 pictureClick here for the Excel Data File 18.55 18.26 Required: a. Calculate the regression equation that predicts price per share based on the annual dividend. (Round your answers to 4 decimal places.) Price = dividend b-1. State the null and alternate hypotheses. OH: =0 and H: #0 OH B=0 and H: B=0 OH: #0 and H #0 OH: 0 and H: > 0 b-2. State the decision rule. Use the 0.05 significance level. (Round your answer to 3 decimal places.) Reject Ho if t is not between b-3. Compute the value of the test statistic. (Round your answer to 4 decimal places.) The test statistic is b-4. What is your decision regarding Ho? Decision: b-5. Can we conclude the slope is not equal to zero? Yes No c. Determine the coefficient of determination. (Round your answer to 4 decimal places.) R d-1. Determine the correlation coefficient. (Round your answer to 4 decimal places.) Correlation coefficient d-2. Can you conclude that it is greater than O using the 0.05 significance level? Ho. We conclude that the correlation in the population is Zero. e. If the dividend is $10, what is the predicted price per share? (Round your answer to 4 decimal places.) Price f. What is the 95% prediction interval of price per share if the dividend is $10? (Round your answers to 4 decimal places.) Obs Price Dividend 1234 21.00 3.34 23.12 3.56 32.99 0.46 35.28 8.39 5 37.69 0.77 6 37.97 8.86 7 38.01 8.02 8 39.93 8.43 9 40.84 6.63 10 41.68 8.36 11 45.66 9.43 12 51.60 10.11 13 56.48 11.71 14 57.18 13.98 15 57.93 10.72 16 59.99 10.03 17 60.34 13.23 18 61.27 10.93 19 62.56 8.37 20 63.70 9.69 21 67.27 17.33 22 67.96 16.90 23 68.06 14.46 24 68.27 11.04 25 69.83 22.25 26 71.66 15.00 27 73.11 25.67 28 78.73 12.14 29 81.90 18.55 30 84.09 18.26 32.14 Following is information on the price per share and the dividend for a sample of 30 companies. Company Price per Share 1 2 $21.00 23.12 Dividend $ 3.34 3.56 39 81.90 40 84.09 pictureClick here for the Excel Data File 18.55 18.26 Required: a. Calculate the regression equation that predicts price per share based on the annual dividend. (Round your answers to 4 decimal places.) Price = dividend b-1. State the null and alternate hypotheses. OH: =0 and H: #0 OH B=0 and H: B=0 OH: #0 and H #0 OH: 0 and H: > 0 b-2. State the decision rule. Use the 0.05 significance level. (Round your answer to 3 decimal places.) Reject Ho if t is not between b-3. Compute the value of the test statistic. (Round your answer to 4 decimal places.) The test statistic is b-4. What is your decision regarding Ho? Decision: b-5. Can we conclude the slope is not equal to zero? Yes No c. Determine the coefficient of determination. (Round your answer to 4 decimal places.) R d-1. Determine the correlation coefficient. (Round your answer to 4 decimal places.) Correlation coefficient d-2. Can you conclude that it is greater than O using the 0.05 significance level? Ho. We conclude that the correlation in the population is Zero. e. If the dividend is $10, what is the predicted price per share? (Round your answer to 4 decimal places.) Price f. What is the 95% prediction interval of price per share if the dividend is $10? (Round your answers to 4 decimal places.)