Can you send it to me as Excel file

SIMULATION HOMEWORK The homework is due 24.12.2021. You need to upload your homework before the day ends. I plan the weight of this homework as 20%, but I will decide after I see your results. Solve the simulation by using Excel, since you will be able to upload excel files only. At the top of your excel file please paste the table shared here and write your results there: Name, Surname: Student ID: Tokyo Shop expected value Kyoto Shop first simulation expected value Kyoto Shop second simulation expected value Kyoto Shop third simulation expected value Kyoto Shop fourth simulation expected value Kyoto Shop fifth simulation expected value Leila Brooks is a computer shop owner in Tokyo. She wishes to open a new shop in Kyoto. For several years in the business she has kept her sales data incase she wishes to open a new shop. She plans to use the data she has and run a simulation about the number of laptop sales per week to guess possible number of sales in Kyoto. She assumes the markets are the same and the simulation will be useful. Perform the simulation for her. Processed Data for Tokyo shop of the last 500 days. 6 7 8 9 10 11 Number of sales Occurances 34 89 132 165 61 19 a) Find the expected number of sales for Tokyo Shop. b) Simulate for Kyoto Shop for 40 days and repeat the process 5 times using Monte Carlo Simulation. c) Find expected number of sales of Kyoto shop for every simulation run (you need 5 results) d) Comment on the results. Solve the simulation by using Excel