LC_Larrreal_Continuous_Probability_Distribution_Normal_Start (1)

xlsx

School

Eastern Kentucky University *

*We aren’t endorsed by this school

Course

890

Subject

Statistics

Date

Jan 9, 2024

Type

xlsx

Pages

11

Uploaded by PrivateInternetBarracuda38

Report
Sub This is a machine generated report of your submission document containing error Details of all points deducted in the submitted document are listed on this sheet. Assignment Details Submission ID 314213501 Assignment Name Submission Date 11 October, 2023 Report Generated on 11 October, 2023 Points Obtained 0/100 (0%) Worksheet: 'Questions' (Points Deducted: 100.000) Points Deducted Details 100.000 Cell level Incorrect Actions 0.000 Missing: Row 26
bmission MarkUp r details as annotations. Error Description 22 cell(s) commented inplace. Please check the sheet. This action did not result in any loss of points.
Contin Project D Steps to P Step 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 The prese of 420.5 m We will us approxima Use a cell full credit
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
21 22 23 24
nuous Probability Distribution: Normal Description: Perform: Instructions Start Excel. Download and open the workbook named: Continuous_Probability_Distribution_Normal_Start What is the population mean (µ)? Choose your answer from the dropdown menu in cell C4. What is the population standard deviation (σ)? Choose your answer from the dropdown menu in cell C5. 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 Hint: use the NORM.S.DIST function. 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. In cell C11, find the probability that a Camry L will travel more than 410 miles on a full tank of gas. In cell C12, find the probability that a Camry L will travel less than 420.5 miles on a full tank of gas. 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. In cell C14, find the probability that a Camry L will travel between 400 and 450 miles on a full tank of gas. In cell C15, find the probability that a Camry L will travel between 320 and 380 miles on a full tank of gas. In cell C16, find the probability that a Camry L will travel between 430 and 490 miles on a full tank of gas. 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. In cell C18, determine the number of miles that the car will travel with 30% probability on a full tank of gas. In cell C19, determine the number of miles that the car will travel with 50% probability on a full tank of gas. In cell C20, determine the lower value for the interval of miles traveled on a full tank of gas around the mean that includes a In cell C21, determine the upper value for the interval of miles traveled on a full tank of gas around the mean that includes a In cell C22, determine the lower value for the interval of miles traveled on a full tank of gas around the mean that includes a ent study shows the data for the miles driven by the 2018 Toyota Camry L. According to the Environmental Prote miles on a full tank of gas. A researcher is interested in analyzing the data and finding z-scores and probabilities se cell referencing and Excel functions to find standardized z-scores and probabilities. We will apply the empirica ately 68%, 95%, and 99.7% of the data. Assume the mileage follows a normal distribution with a standard devia l reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or for your answers. In cell C6, find the z-score for x = 380. In cell C7, find the z-score for x = 500. In cell C8, find the z-score for x = 420.5.
In cell C23, determine the upper value for the interval of miles traveled on a full tank of gas around the mean that includes a In cell C24, determine the lower value for the interval of miles traveled on a full tank of gas around the mean that includes a In cell C25, determine the upper value for the interval of miles traveled on a full tank of gas around the mean that includes a Save your file and submit it for grading.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Points Possible 0 3 3 5 5 5 5 5 5 5 5 5 5 5 5 5 5 4 4 4 n average receive
4 4 4 0 100
Con 1-2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. Use a your Accor devia
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ntinuous Probability Distribution: Normal 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 va In cell C10, find the probability that a Camry L will travel less than 400 miles on a full tank of gas. In cell C11, find the probability that a Camry L will travel more than 410 miles on a full tank of gas. In cell C12, find the probability that a Camry L will travel less than 420.5 miles on a full tank of gas. In cell C13, find the probability that a Camry L will travel exactly 410 miles on a full tank of gas. In cell C14, find the probability that a Camry L will travel between 400 and 450 miles on a full tank of gas. In cell C15, find the probability that a Camry L will travel between 320 and 380 miles on a full tank of gas. In cell C16, find the probability that a Camry L will travel between 430 and 490 miles on a full tank of gas. In cell C17, determine the number of miles that the car will travel with 90% probability on a full tank of gas. In cell C18, determine the number of miles that the car will travel with 30% probability on a full tank of gas. In cell C19, determine the number of miles that the car will travel with 50% probability on a full tank of gas. In cell C20, determine the lower value for the interval of miles traveled on a full tank of gas around the mean that inc In cell C21, determine the upper value for the interval of miles traveled on a full tank of gas around the mean that inc In cell C22, determine the lower value for the interval of miles traveled on a full tank of gas around the mean that inc In cell C23, determine the upper value for the interval of miles traveled on a full tank of gas around the mean that inc In cell C24, determine the lower value for the interval of miles traveled on a full tank of gas around the mean that inc In cell C25, determine the upper value for the interval of miles traveled on a full tank of gas around the mean that inc a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste valu answers. rding to the Environmental Protection Agency (EPA), the 2018 Toyota Camry L drives an average of 420.5 miles o ation of 50 miles. Answer the following questions: What is the population mean ( µ )? Choose your answer from the dropdown menu in cell C4. What is the population standard deviation ( σ )? Choose your answer from the dropdown menu in cell C5. In cell C6, find the z-score for x = 380. In cell C7, find the z-score for x = 500. In cell C8, find the z-score for x = 420.5.
420.5 50 -0.81 1.59 0.00 73.5% 34.1% 58.3% 50.0% 0.0% 38.2% 18.7% -149.3% 484.6 394.3 420.5 370.5 470.5 320.5 520.5 270.5 570.5 dit for standard