Statistic 6

profileedwin.villa
Dylan.xlsx
Home>Mathematics homework help>Statistics homework help>Statistic 6

descriptivestats sample size 10

Descri
Mean 32069.5
Standard Error 4961.3723151967
Median 28920
Mode ERROR:#N/A
Standard Deviation 15689.2368361243
Sample Variance 246152152.5
Kurtosis 8.2076699903
Skewness 2.7509552142
Range 55505
Minimum 19650
Maximum 75155
Sum 320695
Count 10
Confidence Level(95.0%) 11223.4039201309
T Critical Value 2.2621571628
SE 4961.3723151967
ME 11223.4039201309

descriptivestats sample size 11

Price
Mean 192790.454545455
Standard Error 160783.596649566
Median 28940
Mode ERROR:#N/A
Standard Deviation 533258.862530453
Sample Variance 284365014467.273
Kurtosis 10.9770526255
Skewness 3.3119504866
Range 1780350
Minimum 19650
Maximum 1800000
Sum 2120695
Count 11
Confidence Level(95.0%) 358248.178456988

Data

Vehicle type/class Year Make Model Price MPG (city) MPG (highway) # of cylinders WEEK 3 WEEK 4
SUV 2021 GMC Yukon $ 75,155.00 15 22 8 P 0.7 less than 500$
Compact SUV 2021 Hyundai Santa Fe $ 26,850.00 25 28 4 Q 0.3 New SD 7844.6184180622
Compact SUV 2021 Ford Escape $ 24,885.00 44 37 4 P(X=4) 3.68% p(x<31569.50) 47%
SUV 2021 Kia Sorento $ 29,390.00 24 29 4 P(X<5)/ P(X<=4) 4.73%
Pickup Truck 2021 Ford F150 $ 28,940.00 25 26 8 P(X>6)/ 1-P(X<=6) 64.96% 1000$ above
Pickup Truck 2021 Chevy Silverado 1500 $ 28,900.00 22 28 8 P(X>=4)/ 1-P(X<=3) 98.94% New SD 7844.6184180622
Compact Car 2021 Hyundai Elantra $ 19,650.00 33 43 4 p(x>33069.50) 100%
Compact Car 2021 Chevy Malibu $ 22,140.00 29 36 4
Pickup Truck 2021 Dodge Ram 1500 $ 32,595.00 22 32 8 equal to mean $32069.50
SUV 2021 KIA Telluride $ 32,190.00 20 26 6 New SD 7844.6184180622
p(x=32069.50) 0%
Mean: $ 32,069.50
Median: $ 28,920.00 within $1500
SD: 15689.2368361243 New SD 7844.6184180622
Sample Size: 10 p(30569.50<x<33569.50) 15%
Week 2 Outlier
Vehicle type/class Year Make Model Price MPG (city) MPG (highway) # of cylinders WEEK 5 Classmate 1- Week 5
SUV 2021 GMC Yukon $ 75,155.00 15 22 8 T Critical Value 2.2621571628 T-Critcal Value 1.8331129327
Compact SUV 2021 Hyundai Santa Fe $ 26,850.00 25 28 4 SE 4961.3723151967 SE 5206.771494
Compact SUV 2021 Ford Escape $ 24,885.00 44 37 4 ME 11223.4039201309 ME 10724.2086330932
SUV 2021 Kia Sorento $ 29,390.00 24 29 4 Mean $ 32,069.50 Mean $ 55,882.20
Pickup Truck 2021 Ford F150 $ 28,940.00 25 26 8 equation from pdf 11223.4039201309
Pickup Truck 2021 Chevy Silverado 1500 $ 28,900.00 22 28 8 55882.20-10724.2086 $ 45,157.99
Compact Car 2021 Hyundai Elantra $ 19,650.00 33 43 4 32069.50-11223.40 $ 20,846.10 $ 22,446.81 55882.20+10724.2086 $ 66,606.41 $ 21,448.42
Compact Car 2021 Chevy Malibu fail to reject null hypothesis because p-value is greater than alpha 29 36 4 32069.50+11223.40 $ 43,292.90
Pickup Truck 2021 Dodge Ram 1500 $ 32,595.00 22 32 8
SUV 2021 KIA Telluride $ 32,190.00 20 26 6
Sports car 2018 Aston Martin DB4 GT $ 1,800,000.00 Z Critical Value 1.96 .7*.30 0.21 Classmate2-Week 5
p 0.70 .7*.3/10 0.021 Z Critical Value 1.37
q 0.30 Square root of above 0.1449137675 p 0.4 .4*.6 0.24
z*(SqRt of p*q/n) 0.2840257651 q 0.6 .4*.6/10 0.024
.70 +0.284025765 98% sqrt of above 0.1549193338
Mean: $ 209,855.50 .70 -0.284025765 42% .40+0.2125809 61% z*(SqRt of p*q/n) 0.2125809
Median: $ 29,165.00 .40-0.2125809 19%
SD: 558929.175524502
Sample Size: 10
WEEK 6
40th Percentile of Week 1 Sample $ 28,080.00 There is not enough evidence to support the alternative hypothesis
Sample Mean (x-bar) $ 32,069.50
SD: $ 15,689.24
Sample Size: 10
Standard Error: $ 4,961.37
TS: 0.8041
p-value 0.22
alpha 0.05
h=28,080 fail to reject null hypothesis because p-value is greater than alpha
h<28080