Monte Carlo Assignment - 810:025


  1. New example - Monday, November 2nd - Area between two functions estimated using Monte Carlo. Screen snapshots include the Excel IF() and RAND() and SUM formulas that are used.

  2. New email note - Monday, November 2nd - Printing, Formulas, new example within 18 by 20 area rectangle. How to switch from Portrait to Landscape using Print Preview window.


  1. New example - Monday, November 2nd - Area between two functions estimated using Monte Carlo. Screen snapshots include the Excel IF() and RAND() and SUM formulas that are used.

  2. New email note - Monday, November 2nd - Printing, Formulas, new example within 18 by 20 area rectangle. How to switch from Portrait to Landscape using Print Preview window.

  3. Turn in a printout of your Excel spreadsheet screen snapshot with the formulas showing. The first JPG file shown below is an example of what a spreadsheet looks like with the formulas showing.
  4. Turn in a printout of the Excel spreadsheet screen snapshot with the results showing. Your simulation should take at least 1,000 rows of random x and random y values. Each randomX and randomY point represents a point within the larger rectangle that you have decided to use as the enclosing rectangle.
  5. Both of the above printouts can come from one document. Use the PrintScreen or the Alt+PrintScreen technique to get your Excel worksheet on the windows clipboard. Then Paste the contents into a Word or PhotoShop or whatever type of document. You can crop the screen snapshot.
  6. Email your Excel workbook as an attachment to jacobson@cs.uni.edu also. Put Monte Carlo assignment in the Subject: line of your email note.

  7. Due date: Tuesday, November 3rd by 10 p.m. so it does NOT have to be done by class time, if you still have questions or problems.