Question

Microsoft Excel functions are required: visit https://dar.vin/nDAMO for Excel assistance Solve the following question by designing a computer simulation in the columns adjacent to this text box. We randomly pick two numbers from [0,1], denote the larger one as X and smaller one as Y. What is the expected value of (X-Y)? Once you're done, insert a text box 'into this sheet' and report your findings by not falling short of 250 and not exceeding 400 words. Make sure you've deleted the recitation sheets & you've renamed the file properly before you submit your work. In your report, clearly explain why/how your simulation yields a good/reliable result. In addition, try to come up with a theoretical solution to the given problem. Write your solution neatly on an A4-size sheet, take a photo of your solution and paste the photo on this sheet.

Fig: 1