The attached file contains hypothetical data for working this problem. Goodman Corporation’s and Landry Incorporated’s stock prices and dividends, along with the Market Index, are shown in the file. Stock prices are reported for December 31 of each year, and dividends reflect those paid during the year. The market data are adjusted to include dividends. Construct a scatter diagram graph that shows Goodman’s and Landry’ returns on the vertical axis and the Market Index’s returns on the horizontal axis.

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
icon
Concept explainers
Topic Video
Question
The attached file contains hypothetical data for working this problem. Goodman Corporation’s and Landry Incorporated’s stock prices and dividends, along with the Market Index, are shown in the file. Stock prices are reported for December 31 of each year, and dividends reflect those paid during the year. The market data are adjusted to include dividends.
  1. Construct a scatter diagram graph that shows Goodman’s and Landry’ returns on the vertical axis and the Market Index’s returns on the horizontal axis. 
A
C
D
F
1
2 a. Use the data given to calculate annual returns for Goodman, Landry, and the Market Index, and then
calculate average returns over the five-year period. (Hint: Remember, returns are calculated by subtracting
the beginning price from the ending price to get the capital gain or loss, adding the dividend to the capital
5 gain or loss, and dividing the result by the beginning price. Assume that dividends are already included in the
index. Also, you cannot calculate the rate of return for 2015 because you do not have 2014 data.)
4
7
8
Data as given in the problem are shown below:
9.
Goodman Industries
Landry Incorporated
Market Index
10
Year
Stock Price
Dividend
Stock Price
Dividend Includes Divs.
$30.32
$2.23
$2.65
$2.73
$2.57
$2.23
$2.25
$85.12
$79.32
$74.32
$87.12
$95.12
$84.25
$3.52
$3.65
$3.45
$3.47
$3.55
$3.25
11
2020
18,475.97
12,174.55
12,019.97
10,743.05
9,455.42
8,163.96
2019
$23.53
$28.61
$15.21
$12.63
$13.21
12
13
2018
14
2017
15
2016
16
2015
17
18 We now calculate the rates of retun for the two companies and the index:
19
20
Goodman
Landry
Index
21
2020
22
2019
23
2018
24
2017
25
2016
26
27 Average
28
29 Note: To get the average, you could get the column sum and divide by 5, but you could also use the function
30 wizard, fx. Click fx, then statistical, then Average, and then use the mouse to select the proper range. Do this for
31 Goodman and then copy the cell for the other items.
32
Transcribed Image Text:A C D F 1 2 a. Use the data given to calculate annual returns for Goodman, Landry, and the Market Index, and then calculate average returns over the five-year period. (Hint: Remember, returns are calculated by subtracting the beginning price from the ending price to get the capital gain or loss, adding the dividend to the capital 5 gain or loss, and dividing the result by the beginning price. Assume that dividends are already included in the index. Also, you cannot calculate the rate of return for 2015 because you do not have 2014 data.) 4 7 8 Data as given in the problem are shown below: 9. Goodman Industries Landry Incorporated Market Index 10 Year Stock Price Dividend Stock Price Dividend Includes Divs. $30.32 $2.23 $2.65 $2.73 $2.57 $2.23 $2.25 $85.12 $79.32 $74.32 $87.12 $95.12 $84.25 $3.52 $3.65 $3.45 $3.47 $3.55 $3.25 11 2020 18,475.97 12,174.55 12,019.97 10,743.05 9,455.42 8,163.96 2019 $23.53 $28.61 $15.21 $12.63 $13.21 12 13 2018 14 2017 15 2016 16 2015 17 18 We now calculate the rates of retun for the two companies and the index: 19 20 Goodman Landry Index 21 2020 22 2019 23 2018 24 2017 25 2016 26 27 Average 28 29 Note: To get the average, you could get the column sum and divide by 5, but you could also use the function 30 wizard, fx. Click fx, then statistical, then Average, and then use the mouse to select the proper range. Do this for 31 Goodman and then copy the cell for the other items. 32
A
В
C
E
F
43 c. Construct a scatter diagram graph that shows Goodman's and Landry' returns on the vertical axis and the
44 Market Index's returns on the horizontal axis.
45
46 It is easiest to make scatter diagrams with a data set that has the X-axis variable in the left column,
47 so we reformat the retums data calculated above and show it just below.
48
49 Year
Index
Goodman
Landry
0.0%
0.0%
50
2020
0.0%
0.0%
51
2019
0.0%
0.0%
52
2018
0.0%
0.0%
0.0%
53
2017
0.0%
0.0%
0.0%
54
2016
0.0%
0.0%
0.0%
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72 To make the graph, we first selected the range with the returns and the column heads, then clicked the chart wizard,
73 then choose the scatter diagram without connected lines. That gave us the data points. We then used the drawing
74 toolbar to make free-hand ("by eye") regression lines, and changed the lines color and weights to match the dots.
75
76
Transcribed Image Text:A В C E F 43 c. Construct a scatter diagram graph that shows Goodman's and Landry' returns on the vertical axis and the 44 Market Index's returns on the horizontal axis. 45 46 It is easiest to make scatter diagrams with a data set that has the X-axis variable in the left column, 47 so we reformat the retums data calculated above and show it just below. 48 49 Year Index Goodman Landry 0.0% 0.0% 50 2020 0.0% 0.0% 51 2019 0.0% 0.0% 52 2018 0.0% 0.0% 0.0% 53 2017 0.0% 0.0% 0.0% 54 2016 0.0% 0.0% 0.0% 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 To make the graph, we first selected the range with the returns and the column heads, then clicked the chart wizard, 73 then choose the scatter diagram without connected lines. That gave us the data points. We then used the drawing 74 toolbar to make free-hand ("by eye") regression lines, and changed the lines color and weights to match the dots. 75 76
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Knowledge Booster
Centre, Spread, and Shape of a Distribution
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.
Similar questions
  • SEE MORE QUESTIONS
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