Assessment 2

Individual assignment (15%)

The main task of the assignment is for students to perform analysis using fundamental skills of R programming.

Submission: A report in pdf format and a R-script recording your codes for data manipulation and output.

Context

QS university ranking provides ranking of universities around the globe. This data is popularly utilized by many stakeholders as a benchmark, especially for education-related cohorts. Although this ranking data may not represent everything about the micro-quality of university, it provides a good gauge to estimate the macro-quality of the educational institution.

Your main task is to come up with some insights evaluating tertiary (higher) education utilizing the data. You will manipulate data as well as explore relationship between certain variables.

Task

1. Data Preparation (10 marks)
   1. Load the csv file (QS ranking data) to RStudio. Also, load the packages that you used in the assignment. (2 marks)
   2. If you look at the data frame, you notice that column “link”, “logo” takes too much space. Remove those two from the data frame. Also, remove “city” column since there are too many unique values. (2 marks)
   3. You can rename variables to your preferred name since some variables have long text. (2 marks)
   4. Convert the data as tibble since you will use tidyverse package. (2 marks)
   5. Create a new data frame which contains Top 400 universities for each year (2017 to 2022). Hence there will be total 2400 observations. You might notice that the variable “rank” is in the format of ‘factor’. This might cause further problem throughout the analysis. Replace the “rank” variable to include integers from 1 to 400. (2 marks)
2. Top 100 universities from the Top 6 countries. (Total 15 marks)
   1. Show the count of where top 400 universities are located across the region in year 2022. Provide a table. (2 marks)
   2. Check how many universities from the United States ranked top 400 in year 2022. Calculate a percentage of it out of top 400 universities. (2 marks)
   3. Identify top 6 countries which have the most universities ranked in TOP 100 in 2022. (2 marks)
   4. Create a variable that shows the average score of universities for each country from year 2017 to 2022. Arrange the average score in descending order and show the first 10 rows in report. (2 marks)
   5. Create an appropriate plot that shows the changes in average score of universities over time for countries you have identified in 2.3. (4 marks)
   6. Provide a brief description on plot you generated in 2.5. Your description should not exceed 1 page. (3 marks)
3. University in Australia (15 marks)
   1. Create a table that shows changes in rank and score for Monash University from 2017 to 2022. (2 marks)
   2. Provide a plot that visualizes the changes in ‘score’ of Australian universities that are ranked in top 100 from 2017 to 2022. (5 marks)
   3. Provide a plot that visualizes the changes in ‘rank’ of Australian universities from 2017 to

2022. Note that your y-axis should be reversely plotted since lower rank is better. (5 marks)

1. 4. Based on two plots you generated from 3.2 and 3.3, evaluate the global competency of Australian universities. (3 marks)
2. Visualize the data to explore relationship between university score and the number of international students for top 100 universities from 2017 to 2022. In your plot, try to add the line of best fit to see any linear relationship. Evaluate your plot and provide a brief description. Notice the class of the variable international students. You need to convert it to numeric. (15 marks)
3. Produce an appropriate plot to exhibit a comparison of the distribution of ranking across the size of the universities. Use data for top 400 universities in year 2022. Mind the order of the x-axis.