In this unit, we return once again to the National Center for Educational Statistics (NCES) Integrated Postsecondary Education Data System (IPEDS) at the link below and begin to compile information, make basic comparisons, and illustrate trends.
National Center for Education Statistics. (n.d.). Home page.
For the first part of the assignment, go to IPEDS, and click on the Find your College box. Next, click on the Compare Colleges box. This will take you to the College Scorecard area from the first unit of the course. Click on Programs and Degrees, and select Four-year and Public Administration and Social Service Professions and for Location, select Alabama. You should see a list of colleges and universities that present all three statistical areas. Ignore any in the list that do not present all three areas.
For the graphs and charts described below, (see attachment) for helpful instructions for creating each type.
1) Create a bar graph to display the Graduation Rates of each of the institutions. The bar graph should be labeled appropriately with a title and a legend.
2) Create a pie chart to display the Average Annual Costs of the listed institutions. Split these into whatever amount ranges that you would like.
3) Calculate the range, mean, median, mode, and standard deviation for the Salary After Attending from the institutions. In your response, include the list of all the values that you included in your calculation, and then provide an answer to each calculation. (See Attachment) for helpful instruction on calculating range, mode, mean, median, and standard deviations. In addition, the website below provides some helpful tips in calculating standard deviation:
Math is Fun. (n.d.). Standard deviation formulas.
Place the bar graph, the pie chart, the list of all values, and the answers to each calculation into one document and submit. Be sure to include a properly formatted title page and reference page with your work. At a minimum, you will need to cite the NCES website. For your reference, the citation for the NCES website for this assignment is below:
U.S. Department of Education. (n.d.). College scorecard.
Attachment:- Creating a bar and pie chart.rar