All posts 100% original work. no plagiarism.
Recall the car data set you identified in Forum 2 excel.  You will want to calculate the average for your data set.  (Be sure you use the numbers without the supercar outlier)  Once you have the average count how many of your data points fall below the average. You will take that number and divide it by 10.  This will be your p or “success” in your problem.  Once you have p, calculate q.
If you were to find another random sample of 10 cars based on the same data, what is the probability that exactly 4 of them will fall below the average?  Make sure you interpret your results.
If you were to find another random sample of 10 cars based on the same data, what is the probability that fewer than 5 of them will fall below the average?  Make sure you interpret your results.
If you were to find another random sample of 10 cars based on the same data, what is the probability that more than 6 of them will fall below the average?  Make sure you interpret your results.
If you were to find another random sample of 10 cars based on the same data, what is the probability that at least 4 of them will fall below the average?  Make sure you interpret your results.
I encourage you to review the Week 3 Binomial probabilities PDF at the bottom of the discussion.  This will give you a step by step example to follow and show you how to find probabilities using Excel.