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...

please show all steps
USING EXCEL ONLY FORMULAS

Extracted 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 חר