The USA national board of education is concerned about college graduation rates and has hired you as a consultant to investigate what drives these rates. Specifically, they are interested in understanding what factors influence the graduation rate (percentage of enrolled students who graduate), whether college education aids social mobility, and if the percentage of faculty holding PhDs or terminal degrees makes a difference. Your task is to analyze these factors using the dataset provided (college.csv) and produce a report that identifies the key drivers of graduation rates and quantifies their impact. The report should include both graphical and numerical analysis, for example scatter plots showing the relationship between each variable and graduation rates.
The assignment includes: 1) A detailed description of the data preparation process, 2) Descriptive statistics of the main variables presented both graphically and numerically, ensuring the visuals clarify the data, 3) A description of the analytical procedures used and their appropriateness, 4) The results of the analysis, 5) Interpretations of the results
Additionally, the analysis files should be provided (e.g., Excel, Real Statistics, Tableau and/or JASP). For classical statistical analysis Excel including Real Statistics or JASP can be used. For visualizations Tableau needs to be used.
Okay thank you. So the assignment is as following: The USA national board of education is worried about college graduation rates. In particular, they are interested to see
1. what drives the graduation rate (grad.rate = percent of enrolled students who graduate).
2. They are also interested to see if college education is helping social mobility,
3. and to see if the percentage PHD or terminal diploma holding faculty makes a difference.
They hire you to Investigate what drives college graduation rates. Write a report in which you both graphically and using analysis, tell them what are the most important drivers of the graduation rate, and how much these drivers actually predict the success. Don’t forget to include graphs that show how the data is distributed. (At the minimum, a scatter graph of each variable against graduation rate is in order). Use the data set college.csv data. The assignment includes: 1. a description of the research problem and research questions,
2. a description of the data preparation process
3. descriptive statistics (graphically and numerical) of the main variables, make sure the visuals make sense and clarify matters.
4. description of what procedures you did and why they are appropriate,
5. their results,
6. interpretations of the results
02:03