1. Construct an Excel-compatible worksheet for a Monte Carlo simulation of rolling a pair of dice.
HINT: The Excel function RANDBETWEEN(x, y) generates a pseudorandom number between x and y.
You'll need to compute and display the probabilities for all possible outcomes of an experiment consisting of THE SUM OF ROLLING TWO DICE. Make sure to include enough labels/comments so that a user can understand what you've done.
2. Research an application of Fuzzy Sets/Fuzzy Logic. Write a brief paragraph describing the application (what is the problem it addresses; why was a Fuzzy System chosen as a solution; pros and cons of the Fuzzy solution; etc.).
To get credit for this question you may NOT rely solely on the online Course Content as your only source of information (and you must properly cite your sources)
3. Research an application of Monte Carlo (MC) Methods. Write a brief paragraph describing the application (what is the problem it addresses; why was Monte Carlo chosen as a solution; pros and cons of MC; etc.).
To get credit for this question you may NOT rely solely on the online Course Content as your only source of information (and you must properly cite your sources)
4. The worksheet should contain 27 rows (4 through 30) with formulas; the column headings should be "X", "Y", "Distance from (0, 0)", and "Point in Circle?", respectively. Check the formulas for rows 4 through 30 in columns A through D and write down the four Excel formulas from columns A through D in row 5 of the "MC Pi" worksheet Now continue adding more and larger numbers of iterations three separate times, and record the new estimate of Pi for each of the three Now try deleting iterations from the simulation three separate times and record the new estimate of Pi for each of the three