Statistic 6
edwin.villa
SEAN.xlsxWK6
| $11,787.00 | Mean (x-bar): | 44280.2 | |||||
| $15,795.00 | Standard Error (SE): | 6264.047794624 | |||||
| $37,703.00 | Standard Deviation (s): | 19808.6584031664 | >40% | 41665.4 | |||
| $40,421.00 | Count (n): | 10 | |||||
| $42,495.00 | |||||||
| $44,028.00 | 𝐻0: 𝜇 = 41665.40 | ||||||
| $54,984.00 | 𝐻𝑎: 𝜇 > 41665.40 | ||||||
| $55,175.00 | |||||||
| $66,660.00 | Sample Error | 6264.047794624 | |||||
| $73,754.00 | TS: | 0.4174297652 | |||||
| P-Value: | 0.3430729332 | ||||||
| Conclusion | |||||||
| a. | 0.343 > .05, Therefore our p-value is greater than alpha. | ||||||
| b. | We fail to reject the null hypothesis (Ho) because our p-value is more than alpha | ||||||
| c. | There is not enough evidence to suggest that the average vehicle from the type of car you chose during week 1 sells for more than $41665.40. | ||||||
Original Data
| Vehicle Type/Class | Year | Make | Model | Price | MPG (city) | MPG (highway) | Engine Size (Quantitative) |
| Hatchbacks | 2021 | Kia | Rio | $11,787.00 | 33 | 41 | V4, 1.6 Liter |
| Sedan | 2021 | Hyundai | Accent | $15,795.00 | 33 | 41 | V4, 1.6 Liter |
| Truck | 2021 | Toyota | Tacoma | $37,703.00 | 19 | 24 | V6, 3.5 Liter |
| Minivan | 2021 | Toyota | Sienna | $40,421.00 | 36 | 36 | V4, 2.5 Liter |
| SUV | 2021 | Mercedes Benz | GLA | $42,495.00 | 25 | 34 | V4, 2.0 Liter |
| Offroad Vehicle | 2021 | Jeep | Wrangler | $44,028.00 | 17 | 23 | V6, 3.6 Liter |
| Coupe | 2021 | Toyota | GR Supra | $54,984.00 | 22 | 30 | V4, 2.0 Liter |
| Truck | 2021 | Chevy | Silverado 2500 | $55,175.00 | 18 | 20 | V8, 6.6Liter |
| SUV | 2021 | Chevy | Tahoe | $66,660.00 | 16 | 20 | V8, 5.3 Liter |
| Sports | 2021 | Porshe | 718 Spyder | $73,754.00 | 17 | 23 | V6, 4.0 Liter |
| Mean | $44,280.20 | ||||||
| Median | $43,261.50 | ||||||
| Standard Deviation | $19,808.66 | ||||||
| Count | 10 | ||||||
| Week 3 | |||||||
| Exactly 4 - P(x=4) | 0.111476736 | 11.15% | |||||
| Fewer than 5 - P(x < 5); P(x<j) = P (x ≤ 5-1) = P(x ≤ 4) | 0.1662386176 | 16.62% | |||||
| More than 6 - P(x > 6) P(x>j) = 1 - P (x ≤ 6) | 0.3822806016 | 38.23% | |||||
| At least 4 - P( x ≥ 4) same as 1 – P(x ≤ 4 - 1) = 1-P(x ≤ 3) | 0.9452381184 | 94.52% | |||||
Super Car Data
| Vehicle Type/Class | Year | Make | Model | Price | MPG (city) | MPG (highway) | Engine Size (Quantitative) |
| Hatchbacks | 2021 | Kia | Rio | $11,787.00 | 33 | 41 | V4, 1.6 Liter |
| Sedan | 2021 | Hyundai | Accent | $15,795.00 | 33 | 41 | V4, 1.6 Liter |
| Truck | 2021 | Toyota | Tacoma | $37,703.00 | 19 | 24 | V6, 3.5 Liter |
| Minivan | 2021 | Toyota | Sienna | $40,421.00 | 36 | 36 | V4, 2.5 Liter |
| SUV | 2021 | Mercedes Benz | GLA | $42,495.00 | 25 | 34 | V4, 2.0 Liter |
| Offroad Vehicle | 2021 | Jeep | Wrangler | $44,028.00 | 17 | 23 | V6, 3.6 Liter |
| Coupe | 2021 | Toyota | GR Supra | $54,984.00 | 22 | 30 | V4, 2.0 Liter |
| Truck | 2021 | Chevy | Silverado 2500 | $55,175.00 | 18 | 20 | V8, 6.6Liter |
| SUV | 2021 | Chevy | Tahoe | $66,660.00 | 16 | 20 | V8, 5.3 Liter |
| Sports | 2021 | Porshe | 718 Spyder | $73,754.00 | 17 | 23 | V6, 4.0 Liter |
| Luxury | 2021 | Bugatti | Chiron Pur Sport | $3,500,000.00 | 8 | 13 | V16/8.0 Liter |
| Mean | $358,436.55 | ||||||
| Median | $44,028.00 | ||||||
| Standard Deviation | $1,042,108.17 | ||||||
| Count | 11 | ||||||
Wk3 Bi Dist
| Price | ||
| Observation 1 | $11,787.00 | |
| Observation 2 | $15,795.00 | |
| Observation 3 | $37,703.00 | |
| Observation 4 | $40,421.00 | |
| Observation 5 | $42,495.00 | |
| Observation 6 | $44,028.00 | |
| Observation 7 | $54,984.00 | |
| Observation 8 | $55,175.00 | |
| Observation 9 | $66,660.00 | |
| Observation 10 | $73,754.00 | |
| Avg | $44,280.20 | |
| p= 0.60 | ||
| q= 0.40 | ||
| Exactly 4 - P(x=4) | 0.111476736 | 11.15% |
| Fewer than 5 - P(x < 5); P(x<j) = P (x ≤ 5-1) = P(x ≤ 4) | 0.1662386176 | 16.62% |
| More than 6 - P(x > 6) P(x>j) = 1 - P (x ≤ 6) | 0.3822806016 | 38.23% |
| At least 4 - P( x ≥ 4) same as 1 – P(x ≤ 4 - 1) = 1-P(x ≤ 3) | 0.9452381184 | 94.52% |
Wk4
| Observation 1 | $11,787.00 | Column1 | ||
| Observation 2 | $15,795.00 | |||
| Observation 3 | $37,703.00 | Mean | 44280.2 | |
| Observation 4 | $40,421.00 | Standard Deviation | 19808.6584031664 | |
| Observation 5 | $42,495.00 | |||
| Observation 6 | $44,028.00 | |||
| Observation 7 | $54,984.00 | |||
| Observation 8 | $55,175.00 | |||
| Observation 9 | $66,660.00 | |||
| Observation 10 | $73,754.00 | |||
| Next 4 Cars < $500 | ||||
| P(x)= 44280.20-500.00 | 43780.2 | |||
| New sd | 9904.3292015832 | |||
| 0.4798687582 | ||||
| 47.99% | ||||
| Next 4 Cars > $1000 | ||||
| P(x)= 44280.20 + 1000.00 | 45280 | |||
| New sd | 9904.3292015832 | |||
| 0.4597967602 | ||||
| 45.98% | ||||
| Next 4 Cars = 44280.20 | ||||
| P(x)= 44280.20 | 44280.2 | |||
| New sd | 9904.3292015832 | |||
| 0.5 | ||||
| 50.00% | ||||
| Next 4 Cars within $1500.00 | ||||
| P(x)= 44280.20+1500 | 45780.2 | High | ||
| P(x)= 44280.20-1500 | 42780.2 | Low | ||
| New sd | 9904.3292015832 | |||
| 0.1203784012 | ||||
| 12.04% |
Wk 5
| $11,787.00 | T-Confidence Interval | ||||||||||
| $15,795.00 | Margin of Error = | 14170.2605867189 | 80% | 95% | |||||||
| $37,703.00 | Mean | 44280.2 | Lower Boundary= | 30109.9394132811 | 35616.841881345 | 17326.71623731 | 28340.5211734378 | ||||
| $40,421.00 | Standard Error | 6264.047794624 | Upper Boundary= | 58450.4605867189 | 52943.558118655 | ||||||
| $42,495.00 | Median | 43261.5 | Confidence Interval | (30109.94,58450.46) | |||||||
| $44,028.00 | Mode | ERROR:#N/A | |||||||||
| $54,984.00 | Standard Deviation | 19808.6584031664 | |||||||||
| $55,175.00 | Sample Variance | 392382947.733333 | Proportion Confidence Interval | 75% | 95% | ||||||
| $66,660.00 | Kurtosis | -0.3588659162 | Z-Critical Value | 1.9599639845 | 42.2-77.8 | 29.6-90.4 | |||||
| $73,754.00 | Skewness | -0.3294124144 | p-value | 0.60 | 35.6 | 60.8 | |||||
| Range | 61967 | q-value | 0.40 | ||||||||
| Minimum | 11787 | Average | $44,280.20 | ||||||||
| Maximum | 73754 | ||||||||||
| Sum | 442802 | ||||||||||
| Count | 10 | ||||||||||
| Confidence Level(95.0%) | 14170.2605867189 |
Sheet2
Sheet3
| Column1 | |
| Mean | 44280.2 |
| Standard Error | 6264.047794624 |
| Median | 43261.5 |
| Mode | ERROR:#N/A |
| Standard Deviation | 19808.6584031664 |
| Sample Variance | 392382947.733333 |
| Kurtosis | -0.3588659162 |
| Skewness | -0.3294124144 |
| Range | 61967 |
| Minimum | 11787 |
| Maximum | 73754 |
| Sum | 442802 |
| Count | 10 |
| Confidence Level(95.0%) | 14170.2605867189 |
