Question: Need help on question this please Question 14 1 pts (Lesson 3.7: Spreadsheet Simulation.) I stole this problem from the Banks, Carson, Nelson and Nicol
Need help on question this please

Question 14 1 pts (Lesson 3.7: Spreadsheet Simulation.) I stole this problem from the Banks, Carson, Nelson and Nicol text (5th edition). Expenses for Joey's college attendance next year are as follows (in $): Tuition = 8400 Dormitory = 5400 Meals ~- Unif(900,1350) Entertainment ~- Unif(600,1200) Transportation ~ Unif(200,600) Books ~- Unif(400,800) Here are the income streams the student has for next year: Scholarship = 3000 Parents = 4000 Waiting Tables ~ Unif(3000,5000) Library Job ~ Unif(2000,3000) Use Monte Carlo simulation to estimate the expected value of the loan that will be needed to enable Joey to go to college next year. O a. $2500 O b. $3250 O c. $3325 O d. $3450 O e. $4000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
