it was required for you to do a simulation with the Probability table below.

Demand per month	Probability
0	0.02
1	0.02
2	0.40
3	0.26
4	0.16
5	0.12
6	0.02

Run 1000 values for a simulation in an Excel file created by you, and:

1. Calculate real expected value and standard deviation of the Demand per month
2. Calculate the expected value, and standard deviation of the Demand per month for your 1000 values simulation.
3. Determine the % error from the Real Demand and your Simulated Demand.

If posible in excel format please