How to calculate the probability using excel.?

How to calculate the probability using excel.?
In a certain store, there is a 0.03 probability that the scanned price in the bar code scanner will not match the advertised price. The cashier scans 800 items.

Required:

a.Expected number of mismatches

b.Standard deviation

c.Probability of at least 20 mismatches

d.Probability of more than 30 mismatches

I got 4.8 for the standard deviation and 24 for the expected number of mismatches. Those are right but I can’t figure out how to do c and d.

Best answer:

Check if the tutorial at the site bellow helps

canterbury.ac.uk/support/student-support-services/students/sssu/using-excel-for-data-analysis.asp

Tags: calculate, Excel, probability, using

Under Forum