| Vehicles Type/Class | Year | Make | Model | Price | MPG (City) | MPG (Highway) | Drive Type |
| Qualitative | Quantitative | Qualitative | Qualitative | Quantitative | Quantitative | Quantitative | Qualitative |
| SUV | 2021 | Hyundai | Genesis GV80 | $ 48,900.00 | 20 | 21 | All Wheel Drive |
| Hybrid/SUV | 2021 | Lexus | GX | $ 58,665.00 | 16 | 20 | All Wheel Drive |
| Coupe | 2017 | Honda | Accord EX | $ 16,791.00 | 27 | 36 | 2 Wheel Drive-Front |
| Coupe | 2014 | Chevrolet | Corvette | $ 38,990.00 | 15 | 23 | 2 Wheel Drive-rear |
| Coupe | 2020 | Toyota | Supra | $ 52,777.00 | 24 | 31 | 2 Wheel Drive-rear |
| SUV | 2021 | Volkswagen | Atlas | $ 43,320.00 | 16 | 22 | 2 Wheel Drive-Front |
| Sedan | 2020 | BMW | M340i | $ 50,998.00 | 22 | 30 | All Wheel Drive |
| Coupe | 2020 | Chevrolet | Camaro LT | $ 27,996.00 | 19 | 29 | 2 Wheel Drive-rear |
| Coupe | 2020 | BMW | M8 | $ 119,994.00 | 15 | 21 | All Wheel Drive |
| Coupe | 2020 | Nissan | GT-R | $ 109,706.00 | 16 | 22 | All Wheel Drive |
| Sports Car | 2006 | Maserati | BirdCage 75th | $ 3,000,000.00 | 7 | 12 | All Wheel Drive |
| Before Adding Outlier DATA |
| Mean: | $ 56,813.70 | 19 | 25.5 |
| Median: | $ 49,949.00 | 17.5 | 22.5 |
| STD: | 33061.4874137736 | 4.18993503 | 5.5226805086 |
| After Adding Outlier Data |
| Mean: | $ 324,376.09 | 17.9090909091 | 24.2727272727 |
| Median: | $ 50,998.00 | 16 | 22 |
| STD: | 887958.174169195 | 5.375026427 | 6.6346199453 |
| 56,813,70 | Average under 6 |
| p | 0.6 |
| q | 0.4 |
| P(x=4) | 11.15% | Exactly 4 |
| P(x<5) = P (x ≤ 5-1) = P(x ≤ 4) | 16.62% | Fewer than 5 | Hypothesis testing | Hypothesis Testing |
| P (x > 6)=1-p(x≤ 6)=1-p(x≤ 6) | 38.23% | More than 6 |
| P(x≥4)=1-P(x≤ 4-1)=1-P(x≤ 3) | 94.52% | At least 4 | Mean | 56813.7 | Ho: µ= 40th percentile | 46668 | <---=PERCENTILE.INC(E3:E12, 0.4) |
| Standard Error | 10454.9603060514 | H1: µ ˃ 40th percentile |
| Median | 49949 |
| Week 4 | Mode | ERROR:#N/A | Ho: µ= 46668 |
| New SD | 16530.7437068868 | Standard Deviation | 33061.4874137736 | H1: µ ˃ 46668 |
| 1 P(X< 56,313) mean minus $500 | 0.4879351629 | (= 48.79%) | Sample Variance | 1093061950.01111 |
| Kurtosis | 0.6212725883 | Standard Error | 10454.9603060514 | <----(S/SQRT(n)) |
| Skewness | 1.1655058341 |
| 2 P(X>57,813) mean Add $1000 | 0.4758982201 | (=47.58%) | Range | 103203 | Test Statics | 0.9704197532 | <---(Mean-40th Percentile)/SE |
| Minimum | 16791 |
| Maximum | 119994 | Degree of Freedom | 9 | <---- N-1 |
| 3 P(X=56,813) | 0.0000241334 | (= 0%) | Sum | 568137 |
| Count | 10 | P Value | 0.1785963689 | <----=T.DIS.RT(TEST STATICS, DF) |
| Confidence Level(95.0%) | 23650.7633431052 |
| 4 P(55,313 <X<58,313) | 0.0723008289 | (=7%) | ALPHA = α | 0.5 |
| $ 55,313.70 | (mean minus 1500) |
| $ 58,313.70 | (mean add 1500) |
| PROPORTIONAL CONFIDENCE INTERVAL |
| MEAN = 56,813.70 | T CONFIDENCE INTERVAL | Z- critical values |
| SD = 33061.48742 | T= | 2.2621571628 | p-hat * q-hat= | 1.9599639845 |
| n = 10 | SD/√n= | 10454.9603060514 | /n | 0.24 |
| P = 0.6 | 95% CONFIDENCE LEVEL= | 23650.7633431052 | SQRT (0.024) | 0.024 |
| Q = 0.4 | UPPER CONFIDENCE LEVEL= | $ 80,464.46 | Z = | 0.1549193338 |
| LOWER CONFIDENCE LEVEL= | $ 33,162.94 | UPPER CONFIDENCE LEVEL= | 0.3036363149 |
| ALPHA = α (1-0.25=0.975) | LOWER CONFIDENCE LEVEL= | 0.9036363149 | 90% |
| degrees of freedom (DF) (10-1=9) | 0.2963636851 | 30% |