Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Algebra and Its Applications

Authors: David C. Lay

4th edition

321791541, 978-0321388834, 978-0321791542

More Books

Students also viewed these Mathematics questions

Question

What are some guidelines for preparing a budget for a proposal?

Answered: 1 week ago