statistics

profileLmessiah
CopyofCarListw2.xlsx

Sheet1

Vehicle Type/Class Year Make Model Price MPG City MPG Highway Engine Week 4 OCT27
Sedan 2022 Toyota Camry XSE Hybrid $33,420 44 47 Hybrid 2.5L 4-Cyl New SD 10211.1342586033
Crossover 2022 Toyota Corolla SE Hatchback $23,165 32 41 4-Cyl P(x < Mean - 500$) = 52,568 0.4804731252 Q1
SUV 2023 Toyota 4Runner TRD PRO $53,270 16 19 4.0L V6 53068 + 1000 = 54,608 0.4400605011 Q2
Sedan 2022 Dodge Charger SRT Hellcat Widebody $81,135 12 21 6.2L Supercharged HEMI V8 0.0000390694 Q3
SUV 2022 Dodge Durango SRT 392 AWD $71,390 13 19 6.4L V8 SRT HEMI 0.1167878888 Q4
Sedan 2022 Dodge Charger GT AWD $37,785 18 27 3.6L V6 24VVT
Truck 2022 Ram Warlock Crew Cab 4x4 5'7" Box $51,695 16 23 5.7L V8 HEMI
Truck 2022 Ram TRX Crew Cab 4x4 5'7" Box $82,485 10 14 6.2L Supercharged HEMI V8
Sedan 2021 Nissan Maxima $38,140 20 30 3.5L V6
SUV 2022 Tesla Model Y $58,190 328E 371E Dual Motor AWD
Qualitative Quantitative Qualitative Qualitative Quantitative Quantitative Quantitative Quantitative
Descriptive Statistics
Mean $53,068
Median $52,483 p = .4 q = .6 0.250822656 25.08
Standard Deviation 20422.2685172066 0.8337613824 83.37
Sample 10 0.9452381184 94.52
0.3822806016 38.22
Vehicle Type/Class Year Make Model Price MPG City MPG Highway Engine
Sedan 2022 Toyota Camry XSE Hybrid $33,420 44 47 Hybrid 2.5L 4-Cyl
Crossover 2022 Toyota Corolla SE Hatchback $23,165 32 41 4-Cyl
SUV 2023 Toyota 4Runner TRD PRO $53,270 16 19 4.0L V6
Sedan 2022 Dodge Charger SRT Hellcat Widebody $81,135 12 21 6.2L Supercharged HEMI V8
SUV 2022 Dodge Durango SRT 392 AWD $71,390 13 19 6.4L V8 SRT HEMI
Sedan 2022 Dodge Charger GT AWD $37,785 18 27 3.6L V6 24VVT
Truck 2022 Ram Warlock Crew Cab 4x4 5'7" Box $51,695 16 23 5.7L V8 HEMI
Truck 2022 Ram TRX Crew Cab 4x4 5'7" Box $82,485 10 14 6.2L Supercharged HEMI V8
Sedan 2021 Nissan Maxima $38,140 20 30 3.5L V6
SUV 2022 Tesla Model Y $58,190 328E 371E Dual Motor AWD
Supercar 2022 SSC Tuatara $1,600,000,000 9 12 Mid-Engine SSC V8
Qualitative Quantitative Qualitative Qualitative Quantitative Quantitative Quantitative Quantitative
Descriptive Statistics
Mean $145,502,789
Median $53,270
Standard Deviation 482402151.260199
Sample 11

Sheet2

Price
Mean 53067.5
Standard Error 6458.0883501922
Median 52482.5
Mode ERROR:#N/A
Standard Deviation 20422.2685172066
Sample Variance 417069051.388889
Kurtosis -1.1577765838
Skewness 0.2060150608
Range 59320
Minimum 23165
Maximum 82485
Sum 530675
Count 10
Confidence Level(95.0%) 14609.210819371

Sheet3

Price
Mean 145502788.636364
Standard Error 145449721.253668
Median 53270
Mode ERROR:#N/A
Standard Deviation 482402151.260199
Sample Variance 2.32711835540468E+17
Kurtosis 10.9999999527
Skewness 3.3166247805
Range 1599976835
Minimum 23165
Maximum 1600000000
Sum 1600530675
Count 11
Confidence Level(95.0%) 324082174.935872