Confidence intervals and sample size Responses
islandbuilt
RESPONSE1.xlsx
Sheet3
| Price |
| Mean | 40588.7 |
| Standard Error | 4986.5590608934 |
| Median | 37423 |
| Mode | ERROR:#N/A |
| Standard Deviation | 15768.8843193733 |
| Sample Variance | 248657712.677778 |
| Kurtosis | -0.7745719499 |
| Skewness | 0.5873946372 |
| Range | 48015 |
| Minimum | 19866 |
| Maximum | 67881 |
| Sum | 405887 |
| Count | 10 |
| Confidence Level(95.0%) | 11280.3802973162 |
Sheet1
| Vehicle type/Class | Year | Make | Model | Price | MPG (City) | MPG (Hwy) | Quan (cylinders) |
| 1 | SUV | 2019 | Toyota | 4Runner | 34,565 | 17 | 20 | 6 |
| 2 | SUV | 2020 | Toyota | Rav4 | 28,517 | 26 | 35 | 4 |
| 3 | SUV | 2019 | Ford | Expidition | 60,247 | 17 | 24 | 6 |
| 4 | Truck | 2020 | Ram | Ram 2500 | 40,437 | 20 | 25 | 8 |
| 5 | Truck | 2019 | Ford | F-250 | 40,281 | 15 | 16 | 8 |
| 6 | SUV | 2018 | Kia | Sorento | 19,866 | 21 | 28 | 4 |
| 7 | SUV | 2019 | Dodge | Durango | 32,946 | 19 | 26 | 6 |
| 8 | SUV | 2020 | GMC | Yukon | 55,349 | 15 | 22 | 8 |
| 9 | SUV | 2020 | Chevy | Equinox | 25,798 | 26 | 31 | 4 |
| 10 | SUV | 2020 | Land Rover | Range Rover | 67,881 | 22 | 28 | 4 |
| QUAL | QUAN | QUAL | QUAL | QUAN | QUAN | QUAN | QUAN |
| Mean: | 40,589 | Mean: | 40,589 |
| Median: | 37,423 | Median: | 37,423 |
| SD: | 15768.8843193733 | SD: | 15768.8843193733 |
| Sample Size: | 10 | Sample Size: | 10 |
| Wk4 | New SD | 7052.0594534899 |
| 1 | P(X<40,089) | 0.4717381647 | 47.17% |
| 2 | P(X>41,589) | 0.4436179857 | 44.36% |
| 3 | P(X=40,589) | 0.000056571 | 0% |
| 4 | P(39,089<X<42,089) | 0.16844201468267 | 16.88% |
| 39,089 |
| 42,089 |
| Wk5 | 2.2621571628 | <---------- T Interval | Z Crit Value------> | 1.9599639845 |
| .70 ± 1.96(.1449137) |
| Column1 | . 70 ± .28403 |
| (.41597, .98403) |
| Confidence Level(95.0%) | 11280.3802973162 | equals:41.6% to 98.4% |
| Mean+CL | 51,869 |
| Mean-CL | 29,308 |
