As a Data Analyst working for the Department of Education - IT Assignment Help

Assignment Task:

Task:

Context  

Each row in CPR.csv corresponds to University data for a given academic year. Assume that this data was collected by the United States Department of Education over 10 academic years (2010 — 2019) to better understand the variability in higher education completion rate (CPR) across 120 Universities, and the factors influencing the completion rate. 

Relevant information about data variables is given below: YEAR: Academic year INSTNM: Institute name CITY, STATE, COUNTRY: City, State where University is located in United States INST_TYPE: Type of Institution — Public or Private NT_TUT_REV: Net Tuition Revenue per student (5) INST_EXP: Instructional expenditure per student (5) AVG_FAC_SAL: Average faculty salary per month ($) TS: Total students enrolled in the academic year TS_MEN: Percentage of total students enrolled - Men TS_WOM: Percentage of total students enrolled - Women TS_MAR: Percentage of total students enrolled - married TS_DPEN: Percentage of total students enrolled - dependent TS_VET: Percentage of total students enrolled veteran TS PT: Percentage of total students who study part time ST_FI_LO: Percentage of students whose family income is in the range 50-$30,000 ST_FI_Ml: Percentage of students whose family income is in the range $30,001-548,000 ST_FI_M2: Percentage of students whose family income is in the range $48,001-$75,000 ST_FI_Hl: Percentage of students whose family income is in the range $75,001-5110,000 ST_FI_H2: Percentage of students whose family income is 5110,001+ HL_ED_MS: Percentage of students whose arents' hi hest level of education is middle school 
 

Task 
As a Data Analyst working for the Department of Education, you are required to create the following data visualizations: 
1. A visualization (preferably a map) that shows TS and CPR for all 120 universities. [10) 
2. A visualization that answers the following questions:

• Is there a relationship between INST_EXP and CPR?

• Is there a relationship between AVG_FAC_SAL and CPR?

• Is there a relationship between gender ratio and CPR?

• Is there a relationship between TS_PT and CPR? You are required to demonstrate an application of string parameters in this visualization. 

3. A visualization that explores the relationship between student cohort's family income and CPR. [10] 
4. A visualization that explores the relationship between student cohort's parents' education and CPR. [10] 
 

This IT Assignment has been solved by our IT Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.