How do I respond to this post:Hello class, This weeks lesson was very interesting to me especially because I got to learn about a new function and practice it in excel. The average for my data set is $22,453. I then had 6 cars that fell below that average, leaving me with p = .60 and q = 1 - .60 = .40 To find the probability of exactly 4 of them falling below the average (P(x=4)), I entered the function =BINOM.DIST(4,10,0.6,FALSE) and got 11.15%. To find the probability of fewer than 5 of them falling below the average (P(x < 5)), I entered the function =BINOM.DIST(4,10,0.6,TRUE) and got 16.62%. To find the probability of more than 6 of them falling below the average (P(x > 6)), I entered the function =1-BINOM.DIST(6,10,0.6,TRUE) and got 38.23%. To find the probability of at least 4 of them falling below the average (P (x 4), I entered the function =1-BINOM.DIST(3,10,0.6,TRUE) and got 94.52%. - Moriah