6. Do research on the internet and a) explain clearly in a paragraph how Monte Carlo...

Transcribed Image Text:

6. Do research on the internet and a) explain clearly in a paragraph how Monte Carlo method can be used to approximate the value of 7. [3] b) Use Microsoft Excel to approximate by generating 50 (x,y) coordinates. You may need to use rand() and Countif operators. Please watch the video on creating random numbers in Excel. Rand() generates a number between 0 and 1. You should include all your work including screenshot of your Excel work to get full marks. [3] 6. Do research on the internet and a) explain clearly in a paragraph how Monte Carlo method can be used to approximate the value of 7. [3] b) Use Microsoft Excel to approximate by generating 50 (x,y) coordinates. You may need to use rand() and Countif operators. Please watch the video on creating random numbers in Excel. Rand() generates a number between 0 and 1. You should include all your work including screenshot of your Excel work to get full marks. [3]