A campus survey is conducted at a large size university. The purpose of the survey is to collect background information of students and to understand what factors may explain university student's grade point average (GPA). a sample of 141 undergraduate students is randomly selected. These selected students answer questions on their personal backgrounds and agree to authorize the survey conductor to retrieve their GPAs at the university and high school/college and achievement test scores (Ascore). The relevant information is entered into a spreadsheet CampusSurvey.xlsx, where each column represents a variable. These variables include:

Question 1

Describing univariate data Pick up three numerical variables and three categorical variables that you think are important information of students. Write the report to describe them one by one. To describe univariate categorical variables, you need to use appropriate univariate tables or/and charts. To describe univariate numerical variables, you need to use appropriate univariate tables or/and charts as well as appropriate numerical measures to detail distribution of the numerical variables

Task 2

Use an appropriate graphical technique and an appropriate numerical measure to discuss the relationship (if there is any) between the university GPA and each of the numerical variables provided in the dataset. Based on your analysis, which numerical variable is most related to university GPA?

This is the data table link

https://drive.google.com/file/d/1BJwSGIobJuwgkh1wldUabcG9tUpQV5DF/view?usp=sharing