Cullimore Math302 W6 Assignment

.xlsx
Year Make Model Price SUV SUV 2023 KIA Telluride $56,860 Truck 2023 RAM TRX $87,090 Truck 2023 Ford Raptor $78,580 Car 2016 Aston Martin DB9 $213,295 Car 2015 Ferrari 458 $239,340 Truck 2023 RAM 1500 $76,275 Car 1969 Chevy Camaro $55,000 Car 1970 Chevy Chevelle $72,900 Truck 1955 Chevy 3100 $31,000 Car 2022 Aston Martin Valkerie $3,000,000 Mean $101,149 8 0.8 0.2 73151.68 40th Percentile: $73,575.00 Mean: $101,148.89 Standard Deviation (SD): $73,151.68 Sample size (N): 10 Degrees of Freedom (DF): 9 Standard Error (SE): 23132.59 Test Statistic (TS): 1.19 P-Value: 1.319E-01 Alpha: 0.05 Test Statistic (TS): 1.19 P-Value: 0.13 Alpha: 0.05 1 We reject the null hypothesis (Ho) because our p-value is less than alpha Response to peer 2, 80th %: $137,572.00 Test Statistic (TS): -1.57 P-Value: 0.07 Alpha: 0.05 1 Vehicle type/class 2018 Subaru Forester $22,795 Data points below mean Number of cars that Fall Below Mean (P) Failure (Q) = 1 - 0.8 Standard Deviation (SD)
Drive Train Rationale 23 29 2WD functional 20 26 AWD Family vehicle (owned) 10 14 4WD Dream truck 15 18 4WD 2nd dream truck 13 19 2WD Dream modern car 13 17 2WD Other dream modern car 17 22 4WD I own a 2014 sport and love it 9 13 2WD Dream classic muscle 11 13 2WD Other dream classic muscle 9 11 2WD Dream classic truck 9 14 2WD Dream Supercar O Square root of 8 2.828427 Price Mean $101,148.89 Standard Error $24,383.89 Median $76,275.00 Mode #N/A Standard Deviation $73,151.68 Sample Variance $5,351,167,854.86 Kurtosis $0.64 Skewness $1.42 Range $208,340.00 Minimum $31,000.00 Maximum $239,340.00 Sum $910,340.00 Count 10 Confidence Level(95.0%) $56,229.36 MPG (city) MPG (highway) Quantitati c
Omitted from data set during W4 tive vs Qualitative data is shown through the comments within the header cells
Uploaded by dylman10 on coursehero.com