Question

USING FORMULAS IN EXCEL! Please help with 20,21,22,23 and 16

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 un u full funk 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 (H)? Choose your answer from the dropdown menu in cell C4. 420.5 3. What is the population standard deviation (a)? Choose your answer from the dropdown menu in cell CS. 50 4. In cell C, find the Z-score for x = 380. -1.81 5. In cell C7, find the Z-score for x = 500. 1.50 6. In cell C8, find the Z-score for x = 420.5. 0.00 7. In cell 09, find the probubility that a Camry L will travel between 380 and 500 miles on a full tunk of gas using the values in cells C6 and C7. 73.5% 8. In cell C10, find the probability that u Camry L will travel less than 400 miles on a full tank of gas. 34.1% 9. In vell C11, find the probability that a Camry L will travel more than 410 miles on a full tank of yus. 58.3% 10. In cell C12, find the probability that a Camry L will travel less than 420.5 triles on a full tank of gas. 50.0% 11. In cell C13, find the probability that a Camry L will travel exactly 410 miles on a full tank of gas, 0.8% 12. In cell CI 4, find the probability that a Camry L will travel between 400 and 450 miles on a full tank of gas. 38.2% 13. In cell CI 5, find the probability that a Camry L will travel between 320 and 380 miles on a full tank of gas. 18.7% 14. In cell C16, find the probability that a Camry L will travel between 430 and 490 miles on a full tank of gas. 34.2% 15. In cell CI 7, determine the number of miles that the car will travel with 90% probability on a full tank of gas. 484.6 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. 420.5 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. 370.5 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. 470.5 20. In cell C22. determine the lower value for the interval of miles traveled on a full tunk of gas around the mean that includes approximately 95% of miles for this cur. 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. 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 rules for this car.

Answer 1

16)

car travel with 30% probability

=NORM.INV(0.3,420.5,50)

= 394.28 (394.3)

20)

lower value for 95%

=NORM.INV(0.0025,420.5,50)

=280.15

21)

upper value for 95%

=NORM.INV(0.9975,420.5,50)

=560.85

22)

lower value for 99.7%

=NORM.INV(0.0015,420.5,50)

=272.11

23)

upper value for 99.7%

=NORM.INV(0.9985,420.5,50)

=568.89

please revert back if any doubt

thanks

please rate