Frequency distributions and graphs; Data description Responses
islandbuilt
Response2Exceldoc.xlsx
Sheet5
| Price |
| Mean | 216798.181818182 |
| Standard Error | 198320.569334179 |
| Median | 18610 |
| Mode | ERROR:#N/A |
| Standard Deviation | 657754.916691136 |
| Sample Variance | 432641530431.364 |
| Kurtosis | 10.9998853724 |
| Skewness | 3.3166010247 |
| Range | 2183730 |
| Minimum | 16270 |
| Maximum | 2200000 |
| Sum | 2384780 |
| Count | 11 |
| Confidence Level(95.0%) | 441885.765681523 |
List
| Vehicle | Year | Make | Model | Price | MPG City | MPG Highway | Fuel Capacity (Gallons) |
| WAGON | 2021 | KIA | SOUL | $18,610.00 | 25 | 31 | 14.3 | w/o supercar |
| SUV | 2021 | CHEVROLET | TRAILBLAZER | $19,995.00 | 28 | 31 | 13.2 | Mean | 18478 |
| Standard Error | 433.4296046906 |
| HATCHBACK | 2020 | HONDA | FIT | $17,145.00 | 29 | 36 | 10.6 | Median | 18550 |
| Mode | ERROR:#N/A |
| SUV | 2021 | HYUNDAI | VENUE | $18,490.00 | 27 | 35 | 11.9 | Standard Deviation | 1370.6247561686 |
| Sample Variance | 1878612.22222222 |
| SEDAN | 2019 | HYUNDAI | ELANTRA | $18,130.00 | 26 | 36 | 14 | Kurtosis | -1.3456954168 |
| Skewness | -0.4165890254 |
| SUV | 2019 | NISSAN | KICKS | $19,735.00 | 31 | 36 | 10.8 | Range | 3725 |
| Minimum | 16270 |
| COUPE | 2020 | HYUNDAI | VELOSTER | $19,775.00 | 25 | 33 | 13.2 | Maximum | 19995 |
| Sum | 184780 |
| SEDAN | 2020 | VOLKSWAGEN | JETTA | $19,815.00 | 30 | 40 | 13.2 | Count | 10 |
| Confidence Level(95.0%) | 980.4858848196 |
| SEDAN | 2020 | HYUNDAI | ACCENT | $16,270.00 | 29 | 39 | 11.9 |
| SEDAN | 2020 | KIA | RIO | $16,815.00 | 33 | 41 | 11.9 | w/ supercar |
| SPORT | 2016 | Ferrari | LaFerrari Aperta | $2,200,000.00 | 12 | 15 | 25 | Mean | 216798.181818182 |
| Standard Error | 198320.569334179 |
| Qualitative | Quantitative | Qualitative | Qualitative | Quantitative | Quantitative | Quantitative | Quantitative | Median | 18610 |
| Mode | ERROR:#N/A |
| Mean: | $18,478.00 | Standard Deviation | 657754.916691136 |
| w/o supercar | Median: | $18,550.00 | Sample Variance | 432641530431.364 |
| SD: | 1370.6247561686 | Kurtosis | 10.9998853724 |
| Sample Size: | 10 | Skewness | 3.3166010247 |
| Range | 2183730 |
| Mean: | $216,798.18 | Minimum | 16270 |
| w/ supercar | Median: | $18,610.00 | Maximum | 2200000 |
| SD: | 657754.916691136 | Sum | 2384780 |
| Sample Size: | 11 | Count | 11 |
| Confidence Level(95.0%) | 441885.765681523 |
Without
| Price |
| Mean | 18478 |
| Standard Error | 433.4296046906 |
| Median | 18550 |
| Mode | ERROR:#N/A |
| Standard Deviation | 1370.6247561686 |
| Sample Variance | 1878612.22222222 |
| Kurtosis | -1.3456954168 |
| Skewness | -0.4165890254 |
| Range | 3725 |
| Minimum | 16270 |
| Maximum | 19995 |
| Sum | 184780 |
| Count | 10 |
| Confidence Level(95.0%) | 980.4858848196 |
