RISKBIMONIAL function from Palasades @RISK for pooling and not pooling?

[moe10134]

The Business School at State University currently has three parking lots, each containing 155 spaces. Two hundred faculty members have been assigned to each lot. On a peak day, an average of 70% of all lot 1 parking sticker holders show up, an average of 72% of all lot 2 parking sticker holders show up, and an average of 74% of all lot 3 parking sticker holders show up.

a. Given the current situation, estimate the probability that on a peak day, at least one faculty member with a sticker will be unable to find a spot. Assume that the number who show up at each lot is independent of the number who show up at the other two lots. Compare two situations: (1) each person can park only in the lot assigned to him or her, and (2) each person can park in any of the lots (pooling). (Hint: Use the RISKBINOMIAL function.) If needed, round your answer to a whole percentage and if your answer is zero, enter "0".

 

[shg]

I dunno anything about @Risk, but ...

	A​	B​	C​
1​	Prob(show)​	Prob(no spot)​	​
2​	70%​	0.72%​	B2: =1 - BINOM.DIST(155, 200, A2, TRUE)
3​	72%​	3.28%​
4​	74%​	11.20%​