I propose the following questions based on my own understanding of the data 1. What is the mean faculty salary across all institutions? 2. How are the distribution and frequency of tuition levels across institutions? 3. What is the average debt upon graduation, and how does it vary between states? 4. What is the proportion of institutions (ie. school type)? 5. How does the completion rate compare between public and private institutions? 6. What is the median percentage of female students in institutions? 7. What is the range of tuition costs for in-state students? 8. How does out-of-state tuition vary across different regions? 9. What is the median family income for students receiving Pell Grants? 10. How is the distribution of average room and board costs across institutions?

Chat GPT proposes the following questions 11. What is the variance in the percentage of full-time faculty across institutions? 12. What is the mode of student-to-faculty ratios across institutions? 13. What is the distribution of completion rates for institutions with above-average faculty salaries? 14. What is the variance in completion rates by institutional level (Undergraduate, Graduate, etc.)? 15. How does the percentage of students receiving Pell grants vary across institutions? 16. What is the mean percentage of part-time students across institutions? 17. Is there a correlation between instructional spending and faculty salary? 18. What is the standard deviation of median family income for students in these institutions? 19. How does the percentage of first-generation students vary across different regions? 20. What is the average instructional spending per Full-Time Equivalent (FTE) student for each region?

Analysis

We will analyze some of the questions in detail

##                                  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 and Q11. What is the mean faculty salary across all institutions? What is the variance in the percentage of full-time faculty across institutions?

## The average faculty salary is 7465.778.
## The variance in full time faculty is 761.0431.

Q2. How are the distribution and frequency of tuition levels across institutions?

Q3. What is the average debt upon graduation, and how does it vary between states?

Q4. What is the proportion of institutions (ie. school type)?

Q20. What is the average instructional spending per Full-Time Equivalent (FTE) student for each region?

Q19. How does the percentage of first-generation students vary across different regions?

Q17. Is there a correlation between instructional spending and faculty salary?

## The correlation between instructional spending and faculty salary is 0.4998836.

Q15. How does the percentage of students receiving Pell grants vary across institutions?

Q18. What is the standard deviation of median family income for students in these institutions?

## The standard deviation of median family income is 22.85785.