Response2.xlsx
car stats with addition
| Price |
| Mean | 187812 |
| Standard Error | 171221.623025088 |
| Median | 17230 |
| Mode | ERROR:#N/A |
| Standard Deviation | 567877.879569895 |
| Sample Variance | 322485286104.8 |
| Kurtosis | 10.9990327989 |
| Skewness | 3.3164242674 |
| Range | 1889582 |
| Minimum | 10418 |
| Maximum | 1900000 |
| Sum | 2065932 |
| Count | 11 |
| Confidence Level(95.0%) | 381505.550562347 |
car stats
| Price |
| Mean | 16593.2 |
| Standard Error | 1086.9885494644 |
| Median | 16587.5 |
| Mode | ERROR:#N/A |
| Standard Deviation | 3437.35960683 |
| Sample Variance | 11815441.0666667 |
| Kurtosis | 0.0413190783 |
| Skewness | -0.11375321 |
| Range | 11533 |
| Minimum | 10418 |
| Maximum | 21951 |
| Sum | 165932 |
| Count | 10 |
| Confidence Level(95.0%) | 2458.9389330505 |
Car information
| Vehicle type | Year | Make | Model | Price | MPG (city) | MPG (highway) | Cylinders |
| Sedan | 2018 | Ford | Focus | $10,418 | 26 | 38 | 4 |
| Utility | 2017 | Nissan | Rogue | $13,405 | 26 | 33 | 4 |
| Sedan | 2017 | Subaru | Legacy | $14,385 | 25 | 34 | 4 | Average | $16,593 |
| Utility | 2018 | Honda | HR-V | $15,819 | 28 | 34 | 4 | P=5/10 | 0.5 |
| Sedan | 2019 | Hyundai | Sonata | $15,945 | 26 | 35 | 4 | q=1-0.5 | 0.5 |
| Utility | 2016 | Cadillac | SRX | $17,230 | 17 | 24 | 6 |
| Sedan | 2018 | Honda | Accord | $17,805 | 30 | 38 | 4 |
| Sedan | 2019 | Toyota | Camry | $17,935 | 28 | 39 | 4 |
| Utility | 2019 | Subaru | Crosstrek | $21,039 | 27 | 33 | 4 |
| Utility | 2019 | Toyota | RAV4 | $21,951 | 27 | 34 | 4 |
| qualitative | quantitative | qualitative | qualitative | quantitative | quantitative | quantitative | quantitative |
Probabilities
| Vehicle type | Year | Make | Model | Price | MPG (city) | MPG (highway) | Cylinders |
| Sedan | 2018 | Ford | Focus | $10,418 | 26 | 38 | 4 |
| Utility | 2017 | Nissan | Rogue | $13,405 | 26 | 33 | 4 |
| Sedan | 2017 | Subaru | Legacy | $14,385 | 25 | 34 | 4 |
| Utility | 2018 | Honda | HR-V | $15,819 | 28 | 34 | 4 | Average | $16,695 |
| Sedan | 2019 | Hyundai | Sonata | $15,945 | 26 | 35 | 4 | P=5/10 | 0.5 |
| Utility | 2016 | Cadillac | SRX | $17,230 | 17 | 24 | 6 | q=1-0.5 | 0.5 |
| Sedan | 2018 | Honda | Accord | $17,805 | 30 | 38 | 4 |
| Sedan | 2019 | Toyota | Camry | $17,935 | 28 | 39 | 4 |
| Utility | 2019 | Subaru | Crosstrek | $21,039 | 27 | 33 | 4 |
| P(X=4) | 0.205078125 | 21% |
| P(X≤5) | 0.62304688 | 62% |
| 1-P(X≤3) | 0.828125 | 83% |
| 1-P(X≤6) | 0.171875 | 17% |