Question: i have already completed work. the second and third image is what i have. the first answer is correct. can anyone help me with what


Back Project 6 Instructions-3.docx Switch To Light Mode Dafa for problens l, 2 murt be based on ahe cloving mrices an Eriden. drar. 14. Create a spreadsheet workbook to solve the problems below. 1. Identify the 30 stocks that make up the Dow Jones Industrial Average and colloct their closing stock prices from Friday, April 14 after 4 pm. Data can be found on numerous websites - Marketwatch, Barrons. CNN Business, ete. Identify the closing price of the DJIA and compute the diviser used in calculating the price-weighted index (D)/A). (Note: yoar divisor answer will differ slightly from what is published due to rounding) 2. 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, Apr. 17? 3. Witiline a segarate tab for question 3. Given the quotes below, calculate the index value and the percentage daily change for the daily seenarios listed below using a price-wejghted index, value-weighted index, and arithmetic equal-weighted index. Daily Scenarios Day 1: Price-weighted divisor is 3 ; Base index value is 100 (except for the Price Weighted Index); Day I is base year: Day2:Day3:Day4:Day5:Allthreestocksincreaseby4%SecurityIincreasesby4%Security2incereasesby4%Security3increasesby4% Apr 19,2023 at 8:53 PM Deily hernarion Day 1 Day 2. All thece socks increase by 4 , Day 3 Security 1 increnses by 4% Dry 4 Socurity 2 increases thy 4 o Day 5 Security 3 increaes ty at
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
