Question
Continuous Probability Distribution: Normal Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste
Continuous Probability Distribution: Normal | ||||
Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, unless otherwise directed, as you will not receive full credit for your answers. | ||||
According to the Environmental Protection Agency (EPA), the 2018 Toyota Camry L drives an average of 420.5 miles on a full tank of gas. Assume the mileage follows a normal distribution with a standard deviation of 50 miles. Answer the following questions: | ||||
1-2. | What is the population mean ()? Choose your answer from the dropdown menu in cell C4. | 420.5 | ||
3. | What is the population standard deviation ()? Choose your answer from the dropdown menu in cell C5. | 50 | ||
4. | In cell C6, find the z-score for x = 380. | |||
5. | In cell C7, find the z-score for x = 500. | |||
6. | In cell C8, find the z-score for x = 420.5. | |||
7. | In cell C9, find the probability that a Camry L will travel between 380 and 500 miles on a full tank of gas using the values in cells C6 and C7. Hint: use the NORM.S.DIST function. | |||
8. | In cell C10, find the probability that a Camry L will travel less than 400 miles on a full tank of gas. Hint: use the NORM.DIST function. | |||
9. | In cell C11, find the probability that a Camry L will travel more than 410 miles on a full tank of gas. | |||
10. | In cell C12, find the probability that a Camry L will travel less than 420.5 miles on a full tank of gas. | |||
11. | In cell C13, find the probability that a Camry L will travel exactly 410 miles on a full tank of gas. Hint: an Excel function cannot be used to find the answer. | |||
12. | In cell C14, find the probability that a Camry L will travel between 400 and 450 miles on a full tank of gas. | |||
13. | In cell C15, find the probability that a Camry L will travel between 320 and 380 miles on a full tank of gas. | |||
14. | In cell C16, find the probability that a Camry L will travel between 430 and 490 miles on a full tank of gas. | |||
15. | In cell C17, determine the number of miles that the car will travel with 90% probability on a full tank of gas. Hint: use the NORM.INV function. | |||
16. | In cell C18, determine the number of miles that the car will travel with 30% probability on a full tank of gas. | |||
17. | In cell C19, determine the number of miles that the car will travel with 50% probability on a full tank of gas. | |||
18. | In cell C20, determine the lower value for the interval of miles traveled on a full tank of gas around the mean that includes approximately 68% of miles for this car. | |||
19. | In cell C21, determine the upper value for the interval of miles traveled on a full tank of gas around the mean that includes approximately 68% of miles for this car. | |||
20. | In cell C22, determine the lower value for the interval of miles traveled on a full tank of gas around the mean that includes approximately 95% of miles for this car. | |||
21. | In cell C23, determine the upper value for the interval of miles traveled on a full tank of gas around the mean that includes approximately 95% of miles for this car. | |||
22. | In cell C24, determine the lower value for the interval of miles traveled on a full tank of gas around the mean that includes approximately 99.7% of miles for this car. | |||
23. | In cell C25, determine the upper value for the interval of miles traveled on a full tank of gas around the mean that includes approximately 99.7% of miles for this car. | |||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started