Distribution of university expenditures is strongly skewed to the right with high peakness, kurtosis as opposed to liberal arts expenditures which have very little positive skewness and actually negative kurtosis, indicating a flatter distribution. The top 10% High School distribution has a strong left skewness, for research universities, the kurtosis opposite to the liberal arts distribution. 14. Compute descriptive statistics for all colleges and branch campuses for each year in the Excel file Are any differences apparent from year to year? Freshman College Data. Answer: 2007 Avg ACT Avg SAT HS GPA Mean Mean 1043.036364 Mean 3.108905455 Standard Standard Error 0.738851 Standard Error 30.92917209 Error 0.091212149 Median 21.6 Median 1025.4 Median 3.084 Mode #N/A Mode #N/A Mode #N/A Standard Standard Standard Deviation 2.450492 Deviation 102.5804589 Deviation 0.302516475 Sample Sample Sample Variance 6.004909 Variance 10522.75055 Variance 0.091516218 Kurtosis -0.18901 Kurtosis -0.688310488 Kurtosis -0.677827036 Skewness 0.760534 Skewness 0.493235313 Skewness -0.060373476 1st year % top 10% retention % top 20% rate Mean 0.141909091 Mean 0.303354545 Mean 0.704872665 Standard Standard Error 0.036010467 Standard 0.06000226 Error 0.026726439 Median 0.107 Median 0.197 Median 0.701754386 Mode #N/A Mode #N/A Mode 0.598784195 Standard Standard Standard Deviation 0.119433207 Deviation 0.199004982 Deviation 0.08864157 Sample Sample Sample Variance 0.014264291 Variance 0.039602983 Variance 0.007857328 Kurtosis Kurtosis 0.008968745 Kurtosis 2.420733092 Skewness 0.760534 Skewness 0.493235313 Skewness -0.060373476
Distribution of university expenditures is strongly skewed to the right with high peakness, kurtosis as opposed to liberal arts expenditures which have very little positive skewness and actually negative kurtosis, indicating a flatter distribution. The top 10% High School distribution has a strong left skewness, for research universities, the kurtosis opposite to the liberal arts distribution. 14. Compute descriptive statistics for all colleges and branch campuses for each year in the Excel file Freshman College Data. Are any differences apparent from year to year? Answer: 2007 Avg ACT Avg SAT HS GPA Mean Mean 1043.036364 Mean 3.108905455 Standard Error 0.738851 Standard Error 30.92917209 Standard Error 0.091212149 Median 21.6 Median 1025.4 Median 3.084 Mode #N/A Mode #N/A Mode #N/A Standard Deviation 2.450492 Standard Deviation 102.5804589 Standard Deviation 0.302516475 Sample Variance 6.004909 Sample Variance 10522.75055 Sample Variance 0.091516218 Kurtosis -0.18901 Kurtosis -0.688310488 Kurtosis -0.677827036 Skewness 0.760534 Skewness 0.493235313 Skewness -0.060373476 % top 10% % top 20% 1st year retention rate Mean 0.141909091 Mean 0.303354545 Mean 0.704872665 Standard Error 0.036010467 Standard 0.06000226 Standard Error 0.026726439 Median 0.107 Median 0.197 Median 0.701754386 Mode #N/A Mode #N/A Mode 0.598784195 Standard Deviation 0.119433207 Standard Deviation 0.199004982 Standard Deviation 0.08864157 Sample Variance 0.014264291 Sample Variance 0.039602983 Sample Variance 0.007857328 Kurtosis Kurtosis 0.008968745 Kurtosis 2.420733092 Skewness 0.760534 Skewness 0.493235313 Skewness -0.060373476