In cell Cl6, use an IF statement that compares Ann’s profit using the new method proposed in problem 33 (given in cell Cl 5) with that of the old method proposed in problem 27 (given in cell H6). If...

In cell Cl6, use an IF statement that compares Ann’s profit using the new method proposed in problem 33 (given in cell Cl 5) with that of the old method proposed in problem 27 (given in cell H6). If the new profit is higher, “NEW” should be printed in cell C16; otherwise, “OLD” should be printed in the cell.

27.  a.  In cell B2 enter a formula to determine the probability that it will take the professor more than one hour to travel from his home to his office, b. Verify this by hand using the Table of Normal Probabilities in Appendix A.