E​‌‍‍‍‌‍‍‍‌‍‍‍‌‌‌‌‌‌‍‍​xcel spreadsheet (submitted in “Assignments” section of blackboard not as e-mail attachment) We are at 100% electronic submission of assignments. Everything is on BlackBoard, so assignments can be submitted like that…. You would deposit assignments on BB. smartly created document, include a cover page with your name, date, section information, assignment #, and problem # answer questions, create model as we worked in class/youtube. Create Excel models (3 graphs): 

1. Follow steps in YouTube lecture on Dow Jones Index: See Assign 03 tab in excel file posted to BB Fill in distribution tables and perform average, variance and standard deviation computations Create 3 graphs, time series, values distribution, z score distribution 

2. ​‌‍‍‍‌‍‍‍‌‍‍‍‌‌‌‌‌‌‍‍​Define Market Capitalization, Dow Divisor, Dow Jones Industrial Average (a few lines for each term) 

3. Answer these questions, use any source for your well thought out answers. a) Which Is the Best Investment: the S&P 500, the Nasdaq Composite, or the Dow?

 b) What is the difference among the S&P 500, the Nasdaq Composite, and the Dow Jones Industrial Average? 

c) Which is the best investment: the S&P 500, the Nasdaq Composite, or the Dow? 

d) What is the difference between a price-weighted index and a market cap-weighted index? The YouTube video shows how this all happens, just follow the steps in the videos. Submit as a pdf, using excel. Same cover page (use excel to create this). There is a video that explains what I want ​‌‍‍‍‌‍‍‍‌‍‍‍‌‌‌‌‌‌‍‍​here.