Mathematics Homework Help
Marymount University Calculate the Average for Your Data Set Excel Task
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 discussion. This will give you a step by step example to follow and show you how to find probabilities using Excel. You can also use this PDF in the Quizzes section.
There are additional PDFs that were created to help you with the Homework, Lessons and Tests in the Quizzes section. While they won’t be used to answer the questions in the discussion, they are just as useful and beneficial. I encourage you to review these ASAP! These PDFs are also located at the bottom of the discussion.
Once you have posted your initial discussion, you must reply to at least two other learner’s post. Each post must be a different topic. So, you will have your initial post from one topic, your first follow-up post from a different topic, and your second follow-up post from one of the other topics. Of course, you are more than welcome to respond to more than two learners.”
Instructions: You must respond to at least 2 other students. Responses 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.