The Template for Project 3:
First, finish the “simulation” part (starting from row 12):
(a) Cells A14, A15, ... give the counting of the simulated calls.
(b) For cell B14, enter the function to generate a number randomly between 0 and 1, =RAND().
(c) For cell C14, enter the formula to determine the type of the call based on the randomly generated number in cell B14: =IF(B14<0.3, “Minor”, IF(B14<0.86,“Regular”, “Major”) ).
(d) Copy row 14 all the way down to the row of 84th call (row 97).
Second finish the “summary of simulation” part (row 3 to row 10):
(e) For cell D5, enter the formula to calculate total number of “Minor”s in the 84 calls simulated, =COUNTIF(C14:C97, “Minor”).
(f) Enter formulas in cells D6 and D7 to count number of “regular”s and “Major”s respectively, similar to item (e) above.
(g) For cell D8, enter the formula to calculate % of Minor type, =D5/D4. Put it as % format.
(h) For cells D9 and D10, enter formula to calculate % of Regular type and % of Major type respectively, similar to item (g) above.