RESPONSE1.xlsx
WithoutS.
| Price | Without Supercar |
| Mean | 31560 |
| Standard Error | 2098.7403629585 |
| Median | 32250 |
| Mode | ERROR:#N/A |
| Standard Deviation | 6636.7997642773 |
| Sample Variance | 44047111.1111111 |
| Kurtosis | -1.9893518953 |
| Skewness | -0.172583768 |
| Range | 17500 |
| Minimum | 22000 |
| Maximum | 39500 |
| Sum | 315600 |
| Count | 10 |
| Confidence Level(95.0%) | 4747.6805449202 |
WithS.
| Price | With Supercar |
| Mean | 192327.272727273 |
| Standard Error | 160778.48063317 |
| Median | 36500 |
| Mode | ERROR:#N/A |
| Standard Deviation | 533241.894623648 |
| Sample Variance | 284346918181.818 |
| Kurtosis | 10.9959113277 |
| Skewness | 3.3157768188 |
| Range | 1778000 |
| Minimum | 22000 |
| Maximum | 1800000 |
| Sum | 2115600 |
| Count | 11 |
| Confidence Level(95.0%) | 358236.77926209 |
Regression
| SUMMARY OUTPUT |
| Regression Statistics |
| Multiple R | 0.3173782172 |
| R Square | 0.1007289327 |
| Adjusted R Square | -0.0277383626 |
| Standard Error | 6154.8245368463 |
| Observations | 9 |
| ANOVA |
| | df | SS | MS | F | Significance F |
| Regression | 1 | 29702500.0000001 | 29702500.0000001 | 0.7840823026 | 0.4052846815 |
| Residual | 7 | 265173055.555555 | 37881865.0793651 |
| Total | 8 | 294875555.555556 |
| | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% |
| Intercept | 29897.2222222222 | 3698.5892431805 | 8.0834124193 | 0.0000853028 | 21151.4484011173 | 38642.9960433271 | 21151.4484011173 | 38642.9960433271 |
| 0 | 2725 | 3077.4122684231 | 0.8854842193 | 0.4052846815 | -4551.9236820625 | 10001.9236820625 | -4551.9236820625 | 10001.9236820625 |
| RESIDUAL OUTPUT |
| Observation | Predicted 22000 | Residuals | Standard Residuals |
| 1 | 32622.2222222222 | -8622.2222222222 | -1.4976126811 |
| 2 | 32622.2222222222 | -6122.2222222222 | -1.0633822001 |
| 3 | 32622.2222222222 | -5622.2222222222 | -0.9765361039 |
| 4 | 29897.2222222222 | -1897.2222222222 | -0.3295326873 |
| 5 | 32622.2222222222 | 3877.7777777778 | 0.6735397239 |
| 6 | 35347.2222222222 | 1652.7777777778 | 0.2870745958 |
| 7 | 32622.2222222222 | 4877.7777777778 | 0.8472319163 |
| 8 | 29897.2222222222 | 7702.7777777778 | 1.3379123598 |
| 9 | 35347.2222222222 | 4152.7777777778 | 0.7213050768 |
Car List
| Vehicle | Year Count | Year | Engine | Make | Model | Price | MPG (city) | MPG (highway) |
| SUV | 0 | 2021 | Hybrid | Subaru | Crosstrek | $22,000 | 22 | 29 |
| Wagon | 1 | 2020 | Hybrid | Kia | Niro LX | $24,000 | 52 | 49 |
| Sedan | 1 | 2020 | Hybrid | Ford | Fusion SE | $26,500 | 43 | 41 |
| Crossover | 1 | 2020 | Hybrid | Ford | Escape SE | $27,000 | 44 | 37 |
| SUV | 0 | 2021 | Hybrid | Toyota | RAV4 | $28,000 | 41 | 38 |
| SUV | 1 | 2020 | Hybrid | MINI | Countryman | $36,500 | 29 | 73 |
| Sedan | 2 | 2019 | Electric | Honda | Clarity | $37,000 | 126 | 103 |
| Sedan | 1 | 2020 | Electric | Chevrolet | Bolt EV | $37,500 | 127 | 118 |
| SUV | 0 | 2021 | Electric | Hyundai | Kona | $37,600 | 132 | 120 |
| Hatchback | 2 | 2019 | Electric | BMW | i3 | $39,500 | 100 | 113 |
| Sport | | 2019 | Gas | Bugatti | Veyron 16.4 | $1,800,000 | 15 | 37 |
| Qualitative | | Quantitative | Qualitative | Qualitative | Qualitative | Quantitative | Quantitative | Quantitative |
| Correlation: | 0.4642240324 | | | | | Without Supercar: |
| R-Squared: | 0.2155039519 | | | | | Mean: | $31,560 |
| RE: | 29897.22 | | | | | Median: | $32,250 |
| | | | | | | SD: | 6636.799764 |
| | | | | | | Sample Size: | 10 |
| | | | | | | With Supercar: |
| | | | | | | Mean: | $192,327 |
| | | | | | | Median: | $36,500 |
| | | | | | | SD: | 533241.8946 |
| | | | | | | Sample Size: | 11 |
islandbuilt
