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. al Number of sales Occurances 6 34 7 89 8 132 9 165 10 61 11 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, 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. al Number of sales Occurances 6 34 7 89 8 132 9 165 10 61 11 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, 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
