In cell B1 type the word “Prob.” and enter the probabilities in cells B2:B6. In cell Cl type the word “Rain” and enter the number of days with rain in cells C2:C6. In cell A1 type the word...

In cell B1 type the word “Prob.” and enter the probabilities in cells B2:B6. In cell Cl type the word “Rain” and enter the number of days with rain in cells C2:C6. In cell A1 type the word “Cumulative” for cumulative probability. In cell A2 enter 0, meaning the probability of up to but not including two days of rain is 0. In cells A2:A6 write formulas using cell values already in column A and in column B to model the cumulative probabilities of rain up to but not including the number of days in column C. Hint: The value in cell A6 should be .92

Q25

Simulate a November month in San Antonio as follows, a. In cell A10 enter the formula RAND() to generate a random number between 0 and 1.

b. Note that if you make other entries on the spreadsheet the number in cell A10 will change. To fix this value, COPY cell A10. Then with the cursor still in A10, go to Edit—Paste Special and put a bullet in Values and click OK. The number will not change now.

c. In cell A11 use the VLOOKUP command to generate the number of days using the random number in A10 and the table in cells A2:C6. Note that days of rain is the third column of this table. The result is a simulated number of days of rain in San Antonio in November.