Algorithm of EXCEL Lottery Problem

The first few items can be achieved, but what does "probability distribution of winning times" mean?

As shown in the figure:

A2 input =B 1

B2 input = if ((a2

A3 input = if (and (a2 >; 2、A2 & lt& gt"")，A2-3+ISNUMBER(B2)，"")

C3 input = sum (B 1: B 1000

D3 input = COUNTIF(b 1:b 1000，" Prize ")

Pull down B2 and A3 and fill them separately.

In this way, just enter the original number of coupons in B 1.