Ebling_HybridSUV_Week3

xlsx

School

American Public University *

*We aren’t endorsed by this school

Course

302

Subject

Industrial Engineering

Date

Jan 9, 2024

Type

xlsx

Pages

4

Uploaded by walshawc

Report
Price Mean 31849 Standard Error 1414.62928 Median 30787.5 Mode #N/A Standard Deviation 4473.45057 Sample Variance 20011760 Kurtosis -0.48584406 Skewness 0.6981156 Range 13630 Minimum 26590 Maximum 40220 Sum 318490 Count 10 Confidence Level(95.0%) 3200.11376
27490 Mean 529100 Standard Error 496768.445 Median 32150 Mode #N/A Standard Deviation 1570919.76 Sample Variance 2.4678E+12 Kurtosis 9.99980312 Skewness 3.16223523 Range 4973410 Minimum 26590 Maximum 5000000 Sum 5291000 Count 10 Confidence Level(95.0%) 1123768.3
Vehicle Type Year Make Model Price MPG (City) Hybrid SUV 2023 Kia Sportage Hybrid $27,490 38 Hybrid SUV 2023 Hyundai Tucson Hybrid $31,350 37 Hybrid SUV 2023 Honda CR-V Hybrid $32,950 40 Hybrid SUV 2023 Hyundai Santa Fe Hybrid $35,660 33 Hybrid SUV 2023 Kia Sorento Hybrid $36,690 36 Hybrid SUV 2023 Toyota RAV4 Hybrid $30,225 41 Hybrid SUV 2023 Toyota Highlander Hybrid $40,220 35 Hybrid SUV 2023 Ford Escape Hybrid $29,345 26 Hybrid SUV 2023 Toyota Corolla Cross $27,970 45 Hybrid SUV 2023 Kia Niro Hybrid $26,590 53 Supercar 2024 Bugatti Mistral $5,000,000 Qualitative Quantitative Qualitative Qualitative Quantitative Quantitative Mean: $31,849 $31,849 p = 0.6 q = 0.4 Median: $30,788 SD: 4473.45057 Sample Size: 10 Mean: $483,499 Median: $31,350 SD: 1497959.9 Sample Size 11
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
MPG (Highway) Seating Capacity 38 5 36 5 34 5 30 5 33 6 38 5 34 7 32 5 38 5 45 5 2 Quantitative Quantitative P(x = 4) 11% P(x < 5) = P(x ≤ 4) 17% P(x > 6) = P(x ≤ 6) 38% P(x ≥ 4) = P (x ≤ 3) 95%