Imagine that you want to create your own stock index to measure the performance of the stock market over time. You decide to use a methodology similar to that used to calculate the DJIA (see Equation 3.1). Your index will contain 10 stocks carefully selected from different industries. The price of each stock on June 1, 2017, and June 1, 2018, is shown here. For simplicity, assume that during the year no stock splits or other events occurred that would require an adjustment to the index divisor, which is 13.5 on both dates. a. Calculate the percentage change in the stock price of each company over this 12-month period. Based on those calculations alone, would you guess that the overall stock market was up or down over this time? b. Now use Equation 3.1 to calculate the value of your stock index on each date and calculate the percentage change in the index over the period. Does your index indicate that the market was up or down? c. Are your findings from parts (a) and (b) consistent with each other? If not, why not? What does this have to say about how one should go about selecting stocks (or excluding stocks) from an index calculated in the same way as the Dow? S Data table (Click on the icon here in order to copy the contents of the date table below into a spreadsheet.) Stock Alphabet Apple Advance Auto Parts Berkshire Hathaway Price on 6/1/2018 $1,119.50 $190.24 Price on 6/1/2017 $966.95 $153.18 $128.34 $289,200.00 $137.10 $247,610.00 Campbel's Soup $33.28 $57.96 Comcast Dish $31.26 $41.66 $29.08 $65.21 Goodyear $24.44 $34.55 Molson Coors $61.61 $96.59 Southwest Airlines $50.96 $60.30 Print Done