I need help with this data sheet!!! Statistics and probability question....I found the average.I found P=0.6, but can't get past that.I think q is just p=1-0.6 so q=0.4??I apologize its a lot. Grateful for any help and explanation that can be provided.I've been following the excel directions I have for this but seriously can't seem to get the functions to work correctly to find the other probabilities for the prompt below.Prompt:a) You will want to calculate the average for your data set.b) 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.c) Once you have p, calculate q.d) 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?e) 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?f) 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?g) 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?
