Module 8: Data Science
Review:
- Module 7
- Grades
Presentation:
Assignment:
- Complete Data Science for Business (entire course) on datacamp.com
Final Project:
- Advanced Retirement Simulation
- Expand and refine your spreadsheet simulation of annual stock+bond returns to generate estimates of retirement savings.
- Simulation Features:
- 40-year time horizon
- Simulation count, n=100
- Ability to set/modify simulation parameters by changing cell values (not by editing formula)
- initial balance
- annual contribution
- stock/bond % allocation
- financial target, e.g., $1,000,000
- Functional start button to launch automation of simulation
- Display at end of simulation
- probability (%) of reaching financial target
- distribution of end balances on a histogram
- calculation of Max, Min, Mean, Median and Standard Deviation of end balances
- Video Presentation:
- Each student will create a video in one of 2 formats
- Zoom style screen recording (like my lectures), or
- Homemade video (use your phone)
- Provide a tour of your simulation spreadsheet
- Demonstrate each of the “features” listed above
- Explain what you learned about both simulation methods and retirement savings
- Post your video on YouTube or upload and share on Google Drive (or use your preferred video platform).
- Post a link to your video on Bb.
- Each student will create a video in one of 2 formats