HINAL EXAM, Dats Analysis & Decision Making DDM 501 MBA IMT 46PM10 Octoher 2017
ID: 2930374 • Letter: H
Question
HINAL EXAM, Dats Analysis & Decision Making DDM 501 MBA IMT 46PM10 Octoher 2017 Here are descriptive statistics from Excel for annual per pupil expenditures in 94 0 cities and home sizes in a certain neighborhood. Very briefly compare the variab shape of the two data sets in terms of the following FOUR aspects: skewness, coefficient of variation, range, and outlier existence. 3. hio ility and kurtosis, Espenchtire per Pupal (dollara Hone Size (g Mean Median Mode Standard deviation 1095 217916 Standard devistion 2724 06383 Mean 2231 40857 2217 2117 249.3151 0.52824942 0 35668642 1315.4 1593 2508 5 Median 2506 Mode Kurtosis Skevness Range Minimum Maximum Count 43 9989606 Kurtosis 6 260249912 Skewness 9310 Rangse 916 Minimum 11226 Maximum 94 Count 2908 105 ANSWERExplanation / Answer
we represent Expenditure per pupil by 1
and home size(sq ft) by 2
If skewness is less than -1 or greater than 1, the distribution is highly skewed.
here skewness for 1 is 6.26 > 1 , hence i is highly skewed to the right
and that of 2 is 0.35 < 1 , hence it is not very highly skewed
positive kurtosis indicates a "heavy-tailed" distribution and negative kurtosis indicates a "light tailed" distribution.
kurtosis of 1 is 43.99 which is very high compared to that of 2 ,which is 0.5282
coefficient of variation = sd/mean
for 1 , it is 1095/2724 = 0.401
whereas for 2 it is 249/2231 = 0.1111
since C.O.V is less for 2 , it has less variability
Range for 1 = 9310
whereas for 2 it is 1315.4
range is less for 2 .
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.