1. Introduction

I used the data from CollegeScore4yr - College Scorecard four year which mainly focused on 4 year colleges in the United States of America.

I propse the following 10 questions:

2. Analysis

I will explore the questions further more in details below:

##                                  Name State     ID Main
## 1            Alabama A & M University    AL 100654    1
## 2 University of Alabama at Birmingham    AL 100663    1
## 3                  Amridge University    AL 100690    1
## 4 University of Alabama in Huntsville    AL 100706    1
## 5            Alabama State University    AL 100724    1
## 6           The University of Alabama    AL 100751    1
##                                                                Accred
## 1 Southern Association of Colleges and Schools Commission on Colleges
## 2 Southern Association of Colleges and Schools Commission on Colleges
## 3 Southern Association of Colleges and Schools Commission on Colleges
## 4 Southern Association of Colleges and Schools Commission on Colleges
## 5 Southern Association of Colleges and Schools Commission on Colleges
## 6 Southern Association of Colleges and Schools Commission on Colleges
##   MainDegree HighDegree Control    Region Locale Latitude Longitude AdmitRate
## 1          3          4  Public Southeast   City 34.78337 -86.56850    0.9027
## 2          3          4  Public Southeast   City 33.50570 -86.79935    0.9181
## 3          3          4 Private Southeast   City 32.36261 -86.17401        NA
## 4          3          4  Public Southeast   City 34.72456 -86.64045    0.8123
## 5          3          4  Public Southeast   City 32.36432 -86.29568    0.9787
## 6          3          4  Public Southeast   City 33.21187 -87.54598    0.5330
##   MidACT AvgSAT Online Enrollment White Black Hispanic Asian Other PartTime
## 1     18    929      0       4824   2.5  90.7      0.9   0.2   5.6      6.6
## 2     25   1195      0      12866  57.8  25.9      3.3   5.9   7.1     25.2
## 3     NA     NA      1        322   7.1  14.3      0.6   0.3  77.6     54.4
## 4     28   1322      0       6917  74.2  10.7      4.6   4.0   6.5     15.0
## 5     18    935      0       4189   1.5  93.8      1.0   0.3   3.5      7.7
## 6     28   1278      0      32387  78.5  10.1      4.7   1.2   5.6      7.9
##   NetPrice  Cost TuitionIn TuitonOut TuitionFTE InstructFTE FacSalary
## 1    15184 22886      9857     18236       9227        7298      6983
## 2    17535 24129      8328     19032      11612       17235     10640
## 3     9649 15080      6900      6900      14738        5265      3866
## 4    19986 22108     10280     21480       8727        9748      9391
## 5    12874 19413     11068     19396       9003        7983      7399
## 6    21973 28836     10780     28100      13574       10894     10016
##   FullTimeFac Pell CompRate Debt Female FirstGen MedIncome
## 1        71.3 71.0    23.96 1068   56.4     36.6      23.6
## 2        89.9 35.3    52.92 3755   63.9     34.1      34.5
## 3       100.0 74.2    18.18  109   64.9     51.3      15.0
## 4        64.6 27.7    48.62 1347   47.6     31.0      44.8
## 5        54.2 73.8    27.69 1294   61.3     34.3      22.1
## 6        74.0 18.0    67.87 6430   61.5     22.6      66.7

Q1: What is the average undergraduate enrollment across schools?

## [1] 4484.831

This shows that from the data used, the average undergraduate enrollment across schools in the data set is 4484.831 persons per school.

Q2: What is the median admission rate among schools?

## [1] 0.69505

This shows that from the data used, the median admission rate among the schools in the data set is 0.69505

Q3: What is the variance in instructional spending per FTE student?

## [1] 123100321

The variance in instructional spending per Full Time Enrolled student is 123100321.

Q4: What is the standard deviation of faculty salaries across schools?

## [1] 2563.004

The standard deviation of faculty salaries across the schools in the data set is 2563.004.

Q5: Is there a correlation between admission rate and average SAT scores?

## [1] -0.4221255

With a correlation of -0.4221, this means there is a moderate negative relationship between admission rate and average SAT scores: as admission rates increase, average SAT scores tend to decrease.

Q6: How is the distribution of in-state tuition fees across schools?

Q7: Are there any outliers in the average net price across schools?

This boxploy shows the distribution of the prices of schools from the data set. It also shows there are outliners from the drops above.

Q8: What is the breakdown of schools by region?

This shows the breakdown of schools by region from the data set provided.

Q9: What percentage of schools offer only online programs?

This shows the percentage of schools offer only online programs.

10: What is the average percentage of part-time students across all schools?

## [1] 16.46559

This shows that 16.46559 is the average percentage of part-time students across all schools in the data set.

3. Summary

This project explored various aspects of college data from the College Scorecard dataset, focusing on key metrics such as enrollment, admission rates, faculty salaries, tuition fees, and student demographics. I computed summary statistics such as mean, median, variance, and standard deviation, and also analyzed correlations between variables like admission rate and SAT scores. Visualizations, including histograms, boxplots, barplots, and pie charts, were used to better understand the distribution of key factors like tuition fees, school regions, and the percentage of schools offering online programs. The findings provide valuable insights into trends and variations across schools in the dataset.