The normal distribution I and II Responses

islandbuilt
RESPONSE2.xlsx
Home>Mathematics homework help>Statistics homework help>The normal distribution I and II Responses

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 average price $18,478.00 p(x=4) 20.01% exactly 4 Standard Deviation 657754.916691136
w/o supercar Median: $18,550.00 under average 3 p(x<5) & p(x<=4) 84.97% fewer than 5 Sample Variance 432641530431.364
SD: 1370.6247561686 p=3/10=.30 p(x>6) = 1 - p(x<=6)= 1 - p(x<=6) 1.06% more than 6 Kurtosis 10.9998853724
Sample Size: 10 q=1-.30=.70 p(x>=4) = 1 - p(x<=4-1) = 1 - p(x<=3) 35.04% at least 4 Skewness 3.3166010247
p= 0.30 Range 2183730
Mean: $216,798.18 q= 0.70 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

Normal Distribution

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 p(x<17978) 23.28% Standard Deviation 657754.916691136
SD: 1370.6247561686 p(x>19478) 7.23% Sample Variance 432641530431.364
New SD: 685.3123780843 p(x=18478) 0.06% Kurtosis 10.9998853724
p(x<16978<x<19978) 98.57% Skewness 3.3166010247
Range 2183730
Minimum 16270
Maximum 2200000
Sum 2384780
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

With