[SOLVED] Recall the car data set you identified in Week 2. You will want to calculate the average for your data set (see instructions)

I’m working on a Statistics question and need guidance to help me study.

Recall the car data set you identified in Week 2. 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 forum. This will give you a step by step example to follow and show you how to find probabilities using Excel.

Instructions: Your initial post should be at least 150 words. You must also respond to at least 2 other students. Responses should be a minimum of 50 words and may include direct questions. In your peer posts, compare the probabilities that you found with those of your classmates. Were they higher/lower and why? In your responses, refer to the specific data from your classmates’ posts. Make sure you include your data set in your initial post as well.