Project Description: The present study shows the data for the miles driven by the 2018 Toyota Camry L. According to the Environmental Agency (EPA), the 2018 Toyota Camry L drives an average of 420.5 miles on a full tank of gas. A researcher is inter analyzing the data and finding z-scores and probabilities based on the given data. We will use cell referencing and Excel functions to find standardized z-scores and probabilities. We will apply the en to find intervals around the mean that include approximately 68%, 95%, and 99.7% of the data. Assume the mileage normal distribution with a standard deviation of 50 miles. Use a cell reference or a single formula where appropriate receive full credit. Do not copy and paste values or type values, unless otherwise directed, as you will not receive fu your answers. Steps to Perform: Step Instructions Poin Pos 1 Start Excel. Download and open the workbook named: 0 Continuous_Probability_Distribution_Normal_Start 2 What is the population mean (H)? Choose your answer from the 3 dropdown menu in cell C4. What is the population standard deviation (s)? Choose your answer 3 from the dropdown menu in cell C5. In cell C6, find the z-score for x = 380. 5 5 In cell C7, find the z-score for x = 500. 5 6 In cell C8, find the z-score for x = 420.5. 5 In cell C9, find the probability that a Camry L will travel between 380 5 and 500 miles on a full tank of gas using the values in cells C6 and C7. Hint: use the NORM.S.DIST function. In cell C10, find the probability that a Camry L will travel less than 400 5 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 5 miles on a full tank of gas. 10 In cell C12, find the probability that a Camry L will travel less than 5 420.5 miles on a full tank of gas. 11 In cell C13, find the probability that a Camry L will travel exactly 410 5 miles on a full tank of gas. Created On: 07/05/2019 Continuous Probability Distribu