Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Refer to the Dow Jones Industrial Average and Netflix monthly data. Based on the rate of return data, create an X-Y scatterplot to show the
Refer to the Dow Jones Industrial Average and Netflix monthly data. Based on the rate of return data, create an X-Y scatterplot to show the relationship between the two rates of return. Put Dow Jones rate of return to X-axis and Netflix rate of return to Y-axis. Add trend line and the linear equation that represents the relationship.
resents the relationship.
A A B D E F N 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Date 2021-11-01 2021-10-01 2021-09-01 2021-08-01 2021-07-01 2021-06-01 2021-05-01 2021-04-01 2021-03-01 2021-02-01 2021-01-01 2020-12-01 2020-11-01 2020-10-01 2020-09-01 2020-08-01 2020-07-01 2020-06-01 2020-05-01 2020-04-01 2020-03-01 2020-02-01 2020-01-01 2019-12-01 2019-11-01 2019-10-01 2019-09-01 2019-08-01 2019-07-01 2019-06-01 2019-05-01 2019-04-01 2019-03-01 2019-02-01 Dow Jones Rate of Return 35,913.84 35,819.56 0.26% 33,843.92 5.84% 35,360.73 -4.29% 34,935.47 1.22% 34,502.51 1.25% 34,529.45 -0.08% 33,874.85 1.93% 32,981.55 2.71% 30,932.37 6.62% 29,982.62 3.17% 30,606.48 -2.04% 29,638.64 3.27% 26,501.60 11.84% 27,781.70 -4.61% 28,430.05 -2.28% 26,428.32 7.57% 25,812.88 2.38% 25,383.11 1.69% 24,345.72 4.26% 21,917.16 11.08% 25,409.36 -13.74% 28,256.03 -10.07% 28,538.44 -0.99% 28,051.41 1.74% 27,046.23 3.72% 26,916.83 0.48% 26,403.28 1.95% 26,864.27 -1.72% 26,599.96 0.99% 24,815.04 7.19% 26,592.91 -6.69% 25,928.68 2.56% 25,916.00 0.05% Netflix Rate of Return 681.17 690.31 1.34% 610.34 -11.58% 569.19 -6.74% 517.57 -9.07% 528.21 2.06% 502.81 -4.81% 513.47 2.12% 521.66 1.60% 538.85 3.30% 532.39 -1.20% 540.73 1.57% 490.70 -9.25% 475.74 -3.05% 500.03 5.11% 529.56 5.91% 488.88 -7.68% 455.04 -6.92% 419.73 -7.76% 419.85 0.03% 375.50 -10.56% 369.03 -1.72% 345.09 -6.49% 323.57 -6.24% 314.66 -2.75% 287.41 -8.66% 267.62 -6.89% 293.75 9.76% 322.99 9.95% 367.32 13.72% 343.28 -6.54% 370.54 7.94% 356.56 -3.77% 358.10 0.43% 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 2019-01-01 2018-12-01 2018-11-01 2018-10-01 2018-09-01 2018-08-01 2018-07-01 2018-06-01 2018-05-01 2018-04-01 2018-03-01 2018-02-01 2018-01-01 2017-12-01 2017-11-01 2017-10-01 2017-09-01 2017-08-01 2017-07-01 2017-06-01 2017-05-01 2017-04-01 2017-03-01 2017-02-01 2017-01-01 2016-12-01 2016-11-01 24,999.67 23,327.46 25,538.46 25,115.76 26,458.31 25,964.82 25,415.19 24,271.41 24,415.84 24,163.15 24,103.11 25,029.20 26,149.39 24,719.22 24,272.35 23,377.24 22,405.09 21,948.10 21,891.12 21,349.63 21,008.65 20,940.51 20,663.22 20,812.24 19,864.09 19,762.60 19,123.58 3.67% 7.17% -8.66% 1.68% -5.07% 1.90% 2.16% 4.71% -0.59% 1.05% 0.25% -3.70% -4.28% 5.79% 1.84% 3.83% 4.34% 2.08% 0.26% 2.54% 1.62% 0.33% 1.34% -0.72% 4.77% 0.51% 3.34% 339.50 267.66 286.13 301.78 374.13 367.68 337.45 391.43 351.60 312.46 295.35 291.38 270.30 191.96 187.58 196.43 181.35 174.71 181.66 149.41 163.07 152.20 147.81 142.13 140.71 123.80 117.00 -5.19% -21.16% 6.90% 5.47% 23.97% -1.72% -8.22% 16.00% -10.18% -11.13% -5.48% -1.34% -7.23% -28.98% -2.28% 4.72% -7.68% -3.66% 3.98% -17.75% 9.14% -6.67% -2.88% -3.84% -1.00% -12.02% -5.49% BAStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started