Exam 3

April 17, 2016 at 10:10 pm  •  Posted in s16-busad360 by  •  4 Comments

Exam 3 on Mon, Apr 25

Part 1 Take Home Instructions:

  • Software: Python or Sheets/Excel
  • DataS&P 500 Historical Returns
  • Simulation: Stock Market Investment Returns
    • Randomly sample the S&P 500 Historical Returns to simulate stock market returns. Assume the historical return data are normally distributed.
    • Use a 40-year investment time horizon.
    • Start with a $10,000 balance.
    • Run a Monte Carlo simulation to generate 500 ending investment balances.
    • Find the mean and standard deviation of your ending balances.
    • Generate a histogram displaying the distribution of your ending balances.
  • Print 1 Page with your (1) name, (2) section, (3) mean and standard deviation of ending balances, and (4) the histogram displaying the distribution of your ending balances. Bring your 1-page print out to your demo.
  • Demo: You must demonstrate your Python program or Sheets/Excel worksheet to me in person. Be prepared to explain your simulation, answer questions and make (or allow me to make) modifications to your program or worksheet to test alternative parameters (e.g., different investment time horizon, different starting balance, different number of simulations, etc).
  • Due Date: Yesterday. Just kidding. But in business clients always want everything yesterday and prefer to pay tomorrow. So get used to it. Demo with 1-page printout due on or before class on Apr 27. Demo as soon as you’re ready. This week is better than next week. I will have additional office hours TTh 2:30-4:30pm this week and next. Regular office hours are MW 12:30-2:30, 4:00-4:30pm.



  1. Pingback: Lesson 19: Random Sampling from a Normal Distribution | Geographical Perspectives

  2. Paul / April 18, 2016 at 8:45 am / Reply

    “Due Date: Yesterday.” This gave me anxiety.

    • Justin / April 18, 2016 at 8:47 am / Reply

      Sorry! 🙂

  3. Pingback: Exam 3 Review | Geographical Perspectives

Leave a Reply