Data for problems 1 &2 must be based on the closing prices on Friday, Nov. 12. Create a spreadsheet workbook to solve the problems below. 1. Identify the 30 stocks that make up the Dow Jones Industrial Average and collect their closing stock prices from Friday, November 12 after 3pm. Data can be found on numerous websites - Marketwatch, Barrons, CNN Business, etc. Identify the closing price of the DJIA and compute the divisor used in calculating the price-weighted index (DJIA) (Note: your divisor answer will differ slightly from what is published due to rounding) If Walgreen is replaced by CVS in the Dow Jones Index after the market closes on Friday, what is the new divisor when the market opens on Monday, Nov. 15? 2. 3. Utilize a separate tab for question 3. Given the quotes below, calculate the index value and the percentage daily change for the daily scenarios listed below using a price-weighted index, value-weighted index, and arithmetic equal-weighted index. Security 1 2 3 Price 50 25 15 Number of Shares Outstanding 500 1000 750 Daily Scenarios Day 1: Day 2: Day 3: Day 4: Day 5: Price-weighted divisor is 3; Base index value is 100 (except for the Price Weighted Index): Day 1 is base year. All three stocks increase by 4% Security 1 increases by 4% Security 2 increases by 4% Security 3 increases by 4%