A В D E H. K L. M 1 Earning per share, x Dividends per share, y The following table shows the earnings per share and dividends per share for 10 electric utility companies in a recent year. 2.78 2.16 1.41 0.88 QUESTION B) 4 2.74 1.04 a) Graph the scatter plot 0.92 1.1 METHOD 1 (USE TABLE IN your formula booklet) 2.44 0.96 b) At a = 0.01, can you conclude that there is a significant linear r critical 7 3.5 2.18 correlation between earnings per share and dividends per share? abs r 3.68 METHOD 2 (USE THE P-VALUE APPROAH) 1.54 c) Find the equation of the regression line and interpret the coefficient. 1.97 1.39 Test statistic 10 1.95 1.41 11 12 13 14 2.07 2.88 d) Estimate the dividends per share when the earing per share is 3.07. P-value e) Compute the coefficient of determination and interpret. 15 16 17 18 Method 3) Use the critical value approach critical value 19 20 decision 21 22 23 24 conclusion

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

please show all steps USING EXCEL ONLY FORMULAS

A
В
C
E
F
G
H
K
L
M
1 Earning per share, x
Dividends per share, y
The following table shows the earnings per share and dividends per share
2
2.78
2.16
for 10 electric utility companies in a recent year.
3
1.41
0.88
QUESTION B)
4
2.74
1.04
a) Graph the scatter plot
METHOD 1 (USE TABLE IN your formula booklet)
r critical
0.92
1.1
6
2.44
0.96
b) At a = 0.01, can you conclude that there is a significant linear
7
3.5
2.18
correlation between earnings per share and dividends per share?
abs r
8
3.68
1.54
METHOD 2 (USE THE P-VALUE APPROAH)
c) Find the equation of the regression line and interpret the coefficient.
9
1.97
1.39
Test statistic
10
1.95
1.41
11
2.07
2.88
d) Estimate the dividends per share when the earing per share is 3.07.
12
13
P-value
e) Compute the coefficient of determination and interpret.
14
15
16
17
Method 3) Use the critical value approach
18
critical value
19
20
decision
21
22
conclusion
23
24
25
26
27
חר
Transcribed Image Text:A В C E F G H K L M 1 Earning per share, x Dividends per share, y The following table shows the earnings per share and dividends per share 2 2.78 2.16 for 10 electric utility companies in a recent year. 3 1.41 0.88 QUESTION B) 4 2.74 1.04 a) Graph the scatter plot METHOD 1 (USE TABLE IN your formula booklet) r critical 0.92 1.1 6 2.44 0.96 b) At a = 0.01, can you conclude that there is a significant linear 7 3.5 2.18 correlation between earnings per share and dividends per share? abs r 8 3.68 1.54 METHOD 2 (USE THE P-VALUE APPROAH) c) Find the equation of the regression line and interpret the coefficient. 9 1.97 1.39 Test statistic 10 1.95 1.41 11 2.07 2.88 d) Estimate the dividends per share when the earing per share is 3.07. 12 13 P-value e) Compute the coefficient of determination and interpret. 14 15 16 17 Method 3) Use the critical value approach 18 critical value 19 20 decision 21 22 conclusion 23 24 25 26 27 חר
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Exponents
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman