Compute the beta of AMZN using the SLOPE function What does the beta of AMZN tell...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Compute the beta of AMZN using the SLOPE function What does the beta of AMZN tell you about the stock's sensitivity to market fluctuations? Week 1 2 3 4 5 9 10 11 12 13 BHKKDB9 012B2425 26 27 28 29 30 35 36 3 38 39 14 15 16 17 18 19 23 31 32 33 34 37 40 41 42 43 44 45 46 47 100000 48 49 50 51 52 Weekly adj. closing prices (S) MCK AMZN 1,915.01 2,003.00 1,889.65 1,788.61 1,764.03 1,642 81 1,665.53 1,712.43 1,593.41 1,502.06 1,690.17 1,629.13 1,591.91 1,377.45 1,478.02 1,575.39 1,640.56 1,696.20 1,670.57 1,626.23 1,588.22 1,607.95 1,631.56 1,671.73 1,620.80 1,712.36 1,764.77 1,780.75 1,837.28 1,843.06 1,861.69 1,950.63 1,962.46 1,889.98 1,869,00 1,823.28 1,775.07 1,804,03 1,869.67 1,911.30 1,893.63 1,942.91 2,011.00 1,964.52 1,943.05 1,823 24 1,807.58 1,792.57 1,749.62 1,776.29 1,833.51 1,839.34 133.30 131.03 132.44 129.19 130.78 116.95 123.88 129.21 122.38 119.68 122.98 123.80 115.59 107.35 109.03 113.28 121.04 125.51 125.89 126.16 127.31 134.32 130.29 123.39 111.18 118.53 117.82 116.34 115.99 115.34 113.40 116.86 122.73 130.06 124.24 129.13 121.39 129.89 132.73 132.66 133.99 139.61 144.17 138.49 138.54 147.69 139.77 144.86 144.42 137.86 143.60 143.53 KR 29.30 28.48 28.44 26.34 26.97 26.98 29.52 30.71 29.59 29.18 29.15 28.67 29.04 26.93 27.11 27.18 27.94 28.92 27.64 27.59 27.35 28.99 28.17 27,67 24:17 24.06 24.04 24.29 23.60 25 35 25.46 24.69 25.42 2551 23.92 23.56 22.65 23.76 24.09 22.09 21.56 21.60 21.74 21.54 21.33 22.09 23.16 22.50 23.29 23.68 24.70 26.23 Weekly returns S&P 500 -0.54% -0.97% 4.106 0.02% -3.94% 2.42% 2:13% -1.61% -3.79% 4,85% -4.60% -1.26% -7,05% 2.86% 1.86 % 2.54% 2.87% -0.22% 1.57% 0.05% 2.50% 0.61% 0.39% -2.16% 2.89% -0.77% 1.20% 2.06% 0.51% -0.08% 1.20% 0.20% -2.18% -0.76% -1.17% -2.62% 4.41% 0.47% 2:20% -0.29% 1.65% 0,78% -1.23% 1.65% -3.10% -0.46% -1.03% -1.44% 2,79% 1.79% 0.96% 1 morith T-billl 0.04% 0.04% 0.04% 0.04% 0.04% 0.04% 0.04% 0.04% 0.05% 0.05% 0.05% 0.05% 0.04% 0.04% 0.04% 0.04% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0,05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0,05% 0.0594 I301 0.05% 0.05% ons? Q12 Create a visual representation of the beta of AMZN using a scatterplot with a linear trendline Compute the beta of AMZN using the SLOPE function What does the beta of AMZN tell you about the stock's sensitivity to market fluctuations? Week 1 2 3 4 5 9 10 11 12 13 BHKKDB9 012B2425 26 27 28 29 30 35 36 3 38 39 14 15 16 17 18 19 23 31 32 33 34 37 40 41 42 43 44 45 46 47 100000 48 49 50 51 52 Weekly adj. closing prices (S) MCK AMZN 1,915.01 2,003.00 1,889.65 1,788.61 1,764.03 1,642 81 1,665.53 1,712.43 1,593.41 1,502.06 1,690.17 1,629.13 1,591.91 1,377.45 1,478.02 1,575.39 1,640.56 1,696.20 1,670.57 1,626.23 1,588.22 1,607.95 1,631.56 1,671.73 1,620.80 1,712.36 1,764.77 1,780.75 1,837.28 1,843.06 1,861.69 1,950.63 1,962.46 1,889.98 1,869,00 1,823.28 1,775.07 1,804,03 1,869.67 1,911.30 1,893.63 1,942.91 2,011.00 1,964.52 1,943.05 1,823 24 1,807.58 1,792.57 1,749.62 1,776.29 1,833.51 1,839.34 133.30 131.03 132.44 129.19 130.78 116.95 123.88 129.21 122.38 119.68 122.98 123.80 115.59 107.35 109.03 113.28 121.04 125.51 125.89 126.16 127.31 134.32 130.29 123.39 111.18 118.53 117.82 116.34 115.99 115.34 113.40 116.86 122.73 130.06 124.24 129.13 121.39 129.89 132.73 132.66 133.99 139.61 144.17 138.49 138.54 147.69 139.77 144.86 144.42 137.86 143.60 143.53 KR 29.30 28.48 28.44 26.34 26.97 26.98 29.52 30.71 29.59 29.18 29.15 28.67 29.04 26.93 27.11 27.18 27.94 28.92 27.64 27.59 27.35 28.99 28.17 27,67 24:17 24.06 24.04 24.29 23.60 25 35 25.46 24.69 25.42 2551 23.92 23.56 22.65 23.76 24.09 22.09 21.56 21.60 21.74 21.54 21.33 22.09 23.16 22.50 23.29 23.68 24.70 26.23 Weekly returns S&P 500 -0.54% -0.97% 4.106 0.02% -3.94% 2.42% 2:13% -1.61% -3.79% 4,85% -4.60% -1.26% -7,05% 2.86% 1.86 % 2.54% 2.87% -0.22% 1.57% 0.05% 2.50% 0.61% 0.39% -2.16% 2.89% -0.77% 1.20% 2.06% 0.51% -0.08% 1.20% 0.20% -2.18% -0.76% -1.17% -2.62% 4.41% 0.47% 2:20% -0.29% 1.65% 0,78% -1.23% 1.65% -3.10% -0.46% -1.03% -1.44% 2,79% 1.79% 0.96% 1 morith T-billl 0.04% 0.04% 0.04% 0.04% 0.04% 0.04% 0.04% 0.04% 0.05% 0.05% 0.05% 0.05% 0.04% 0.04% 0.04% 0.04% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0,05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0.05% 0,05% 0.0594 I301 0.05% 0.05% ons? Q12 Create a visual representation of the beta of AMZN using a scatterplot with a linear trendline
Expert Answer:
Answer rating: 100% (QA)
Beta of AMZN The beta of a stock is a measure of its volatility relative to the market A beta of 1 m... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
What does the Fitbit Force incident tell you about Fitbits ethical culture?
-
What does Descartes' rule of signs tell you about the number of positive real zeros and the number of negative real zeros of the function? 1. f(x) = 3x5 - 2x2 + x - 1 2. g(x) = 5x6 - 3x3 + x2 - x 3....
-
What does Descartes' rule of signs tell you about the number of positive real zeros and the number of negative real zeros of each of the following polynomial functions? a. f (x) = 2x6 - 7x3 + x2 - x...
-
Refer to the information in Exercise 16-11. Using the direct method, prepare the statement of cash flows for the year ended June 30, 2017. IKIBAN INC. Comparatlve Balance Sheets June 30, 2017 and...
-
Netflix has made thousands of streaming videos available to its unlimited subscribers. How does this strategy demonstrate a strategic window for the company?
-
When should we use this Supply and Demand model in deciding the market price, and the change of the market price? Tell us about your daily experience. Do you think you can solve real-world problems...
-
For each of the following sets of numbers, calculate a \(95 \%\) confidence interval for the mean ( \(\sigma\) not known); before going through the steps in calculating the confidence interval, the...
-
Professors Adams and Brown make up the entire demand side of the market for summer research assistants in the economics department. If Adamss demand curve is P = 50 - 2QA and Browns is P = 50 - Q B ,...
-
Question 1 of 42\ Use the following T-Account for "Income Taxes Payable," a liability for income tax that a company owes to the government, to solve for how much the company paid in cash taxes over...
-
Frame the Mattco case using the factors set forth in this chapter. Specific areas that should be addressed in this exercise include: a. Type of case b. Jurisdiction c. Professional standards d....
-
Use synthetic division to divide and Solve it: 4x (3)- 7x + 8x (2) - 14x+2.
-
The State Company currently has 11% coupon paying annual bonds of $1,000 face value outstanding in the market with 10 years of maturity with the yield to maturity being 11.21%. They also have common...
-
XYZ Ltd operates a chain of vegetarian restaurants for healthy eating. Its services have been in great demand in recent years and its profits have soared. XYZ Ltd has just paid an annual dividend of...
-
You purchase 100 shares of IBM at $100. The stock pays an annual dividend of $4.00. In three years, the stock is trading at $140.00. (this is not a margin problem) a) What is your annualized time...
-
Wally West, a 23-year-old college graduate, wishes to retire at age 65. To supplement other sources of retirement income, he can deposit $8,000 each year into a self-managed superannuation fund,...
-
Calculate Jensen's alpha using the following information for an asset: Asset Return: 1 2 % Risk - Free Rate: 3 % Beta: 1 . 2 Market Return: 1 0 % B . Explain the difference between active return...
-
. . FastCars is debating whether its next car model should be a gas or electric car. Due to factory limitations, FastCars will only be able to introduce one new model in the next five years . Both...
-
Using the theoretical sampling strategy, how many samples of size 4 (n = 4) can be drawn from a population of size: (a) N = 5? (b) N = 8? (c) N = 16? (d) N = 50?
-
Clarita is a single taxpayer with two dependent children, ages 10 and 12. Clarita pays $3,000 in qualified child care expenses during the year. If her adjusted gross income (all from wages) for the...
-
Yolanda earns $112,000 in 2012. Calculate the FICA tax that must be paid by: Yolanda:.....................Soc.Sec..................$__________...
-
Carl and Jenny adopt a Russian orphan. The adoption takes 2 years and two trips to Russia and is final in 2012. They pay $6,000 in 2011 and $7,500 in 2012 of qualified adoption expenses, and have AGI...
-
The data in Table 2 represent the length (in seconds) of a random sample of songs released in the 1970s. Find the median length of the songs. Approach Follow the steps listed above. Table 2 Song Name...
-
Find the median score of the data in Table 1. Approach Follow the steps listed on the previous page. Table 1 Student Score 1. Michelle 82 2. Ryanne 77 3. Bilal 90 4. Pam 71 5. Jennifer 62 6. Dave 68...
-
Yolanda wants to know how much time she typically spends on her cell phone. She goes to her phones website and records the call length for a random sample of 12 calls, shown in Table 3. Find the mean...
Study smarter with the SolutionInn App