Following is information on the price per share and the dividend for a sample of 30 companies. Company Price per Share Dividend 1 $21.00 $ 3.34 2 23.12 3.56 . . . . . . . . . 39 81.90 18.55 40 84.09 18.26 Click here for the Excel Data File Required: a. Calculate the regression equation that predicts price per share basedon the annual dividend. (Round your answers to 4 decimal places.) b-1. State the null and alternate hypotheses. H0: β = 0 and H1: β ≠ 0 H0: β = 0 and H1: β = 0 H0: β ≠ 0 and H1: β ≠ 0 H0: β ≤ 0 and H1: β > 0 b-2. State the decision rule. Use the 0.05 significance level. (Round your answer to 3 decimal places ) Price = 28.2064 + 2.4060 dividend b-2. State the decision rule. Use the 0.05 significance level. (Round your answer to 3 decimal places.) Reject H0 if t is not between ± 2.048 b-3. Compute the value of the test statistic. (Round your answer to 4 decimal places.) The test statistic is 7.3285 b-4. What is your decision regarding H0? Decision: Reject H0 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.) R2 0.6573 d-1. Determine the correlation coefficient. (Round your answer to 4 decimal places.) Correlation coefficient 0.8107 d-2. Can you conclude that it is greater than 0 using the 0.05 significance level? Reject H0. We can conclude that the correlation in the population e. If the dividend is $10, what is the predicted price per share? (Round your answer to 4 decimal places.) Price $ 52.2664 f. What is the 95% prediction interval of price per share if the dividend is $10? (Round your answers to 4 decimal places.) I need help answering part F I included the excel in the attachment

Following is information on the price per share and the dividend for a sample of 30 companies. Company Price per Share Dividend 1 $21.00 $ 3.34 2 23.12 3.56 . . . . . . . . . 39 81.90 18.55 40 84.09 18.26 Click here for the Excel Data File Required: a. Calculate the regression equation that predicts price per share basedon the annual dividend. (Round your answers to 4 decimal places.) b-1. State the null and alternate hypotheses. H0: β = 0 and H1: β ≠ 0 H0: β = 0 and H1: β = 0 H0: β ≠ 0 and H1: β ≠ 0 H0: β ≤ 0 and H1: β > 0 b-2. State the decision rule. Use the 0.05 significance level. (Round your answer to 3 decimal places ) Price = 28.2064 + 2.4060 dividend b-2. State the decision rule. Use the 0.05 significance level. (Round your answer to 3 decimal places.) Reject H0 if t is not between ± 2.048 b-3. Compute the value of the test statistic. (Round your answer to 4 decimal places.) The test statistic is 7.3285 b-4. What is your decision regarding H0? Decision: Reject H0 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.) R2 0.6573 d-1. Determine the correlation coefficient. (Round your answer to 4 decimal places.) Correlation coefficient 0.8107 d-2. Can you conclude that it is greater than 0 using the 0.05 significance level? Reject H0. We can conclude that the correlation in the population e. If the dividend is $10, what is the predicted price per share? (Round your answer to 4 decimal places.) Price $ 52.2664 f. What is the 95% prediction interval of price per share if the dividend is $10? (Round your answers to 4 decimal places.) I need help answering part F I included the excel in the attachment

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

b-1. State the null and alternate hypotheses.
H0: β = 0 and H1: β ≠ 0
H0: β = 0 and H1: β = 0
H0: β ≠ 0 and H1: β ≠ 0
H0: β ≤ 0 and H1: β > 0
b-2. State the decision rule. Use the 0.05 significance level. (Round your answer to 3 decimal places )
Price = 28.2064 + 2.4060 dividend

b-2. State the decision rule. Use the 0.05 significance level. (Round your answer to 3 decimal places.) Reject H0 if t is not between ± 2.048

b-3. Compute the value of the test statistic. (Round your answer to 4 decimal places.) The test statistic is 7.3285
b-4. What is your decision regarding H0?
Decision: Reject H0
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.) R2 0.6573

d-1. Determine the correlation coefficient. (Round your answer to 4 decimal places.) Correlation coefficient 0.8107
d-2. Can you conclude that it is greater than 0 using the 0.05 significance level? Reject H0. We can conclude that the correlation in the population
e. If the dividend is $10, what is the predicted price per share? (Round your answer to 4 decimal places.) Price $ 52.2664
f. What is the 95% prediction interval of price per share if the dividend is $10? (Round your answers to 4 decimal places.)

I need help answering part F

I included the excel in the attachment

23
24
25
26
27
28
29
30
68.06
68.27
69.83
71.66
73.11
78.73
81.90
84.09
14.46
11.04
22.25
15.00
25.67
12.14
18.55
18.26
32.14

D
I
2
3
1
5
5
7
3
}
D
I
2
B
Obs
1
NT
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Price
21.00
23.12
32.99
35.28
37.69
37.97
38.01
39.93
40.84
41.68
45.66
51.60
56.48
57.18
57.93
59.99
60.34
61.27
62.56
63.70
67.27
67.96
Dividend
3.34
3.56
0.46
8.39
0.77
8.86
8.02
8.43
6.63
8.36
9.43
10.11
11.71
13.98
10.72
10.03
13.23
10.93
8.37
9.69
17.33
16.90

Expert Solution

Step by step

Solved in 4 steps with 8 images

SEE SOLUTION Check out a sample Q&A here