Education and Salary

Author

Katie Morrill

I’m going to perform an analysis on an education and salary data set. Every row is a student while every column is a product of their c

Edusalary <- read_csv("https://myxavier-my.sharepoint.com/:x:/g/personal/morrillk_xavier_edu/EdbXEnGW-xVIr8t6kJZfhOsBS1nhpXAjyWRKDrzb0nAUtw?download=1")

hist(Edusalary$Age)

Running Code

Do you get more job offers with a higher GPA? My hypothesis is the higher a student’s GPA, the more job offers they will receive. I will analyze this question by visualizing the relationship between Job offers and University GPA.

I intend to answer this question by categorizing the GPAs together so it is easier to view.The GPAs that are over 3.5 are considered high, a GPA between a 3.0 and 3.5 is considered medium,and anything under a 3.0 is considered low. It then used a box chart and used the other variable job offers. Where the sum of the of the job offers were grouped together to show the average amount of jobs per GPA level.

Edusalary$GPAlevel <- ifelse(Edusalary$University_GPA >= 3.5, "High GPA",
                             ifelse(Edusalary$University_GPA >= 3.0 & Edusalary$University_GPA < 3.5, "Medium GPA",
                                    "Low GPA"))
    
Edusalary %>%
  ggplot(aes(x =GPAlevel, y = Job_Offers)) + 
  geom_boxplot() +
  labs(title = "Job offers by GPA Level",
       x = "Job offers",
       y = "GPA Level")

Interpretation

Looking at the chart you can see that the students with medium GPAS got the least amount of job offers. On average they got one less job offer than the students with high and low GPAS. This proves the hypothesis is incorrect.GPAs and just because you have a higher GPA does not mean you will get the most jobs.

--- title: "Education and Salary" editor: visual author: "Katie Morrill" # Author name toc: true # Generates an automatic table of contents. format: # Options related to formatting. html: # Options related to HTML output. code-tools: TRUE # Allow the code tools option showing in the output. embed-resources: TRUE # Embeds all components into a single HTML file. execute: # Options related to the execution of code chunks. warning: FALSE # FALSE: Code chunk sarnings are hidden by default. message: FALSE # FALSE: Code chunk messages are hidden by default. echo: TRUE # TRUE: Show all code in the output. --- I'm going to perform an analysis on an education and salary data set. Every row is a student while every column is a product of their c ```{r} #| include: FALSE library(tidyverse) #For all the tidy things library(skimr) #for better summary statistics ``` ```{r} Edusalary <- read_csv("https://myxavier-my.sharepoint.com/:x:/g/personal/morrillk_xavier_edu/EdbXEnGW-xVIr8t6kJZfhOsBS1nhpXAjyWRKDrzb0nAUtw?download=1") ``` ```{r} hist(Edusalary$Age) ``` ## Running Code Do you get more job offers with a higher GPA? My hypothesis is the higher a student's GPA, the more job offers they will receive. I will analyze this question by visualizing the relationship between Job offers and University GPA. I intend to answer this question by categorizing the GPAs together so it is easier to view.The GPAs that are over 3.5 are considered high, a GPA between a 3.0 and 3.5 is considered medium,and anything under a 3.0 is considered low. It then used a box chart and used the other variable job offers. Where the sum of the of the job offers were grouped together to show the average amount of jobs per GPA level. ```{r} #| label: analysis Edusalary$GPAlevel <- ifelse(Edusalary$University_GPA >= 3.5, "High GPA", ifelse(Edusalary$University_GPA >= 3.0 & Edusalary$University_GPA < 3.5, "Medium GPA", "Low GPA")) Edusalary %>% ggplot(aes(x =GPAlevel, y = Job_Offers)) + geom_boxplot() + labs(title = "Job offers by GPA Level", x = "Job offers", y = "GPA Level") ``` Interpretation Looking at the chart you can see that the students with medium GPAS got the least amount of job offers. On average they got one less job offer than the students with high and low GPAS. This proves the hypothesis is incorrect.GPAs and just because you have a higher GPA does not mean you will get the most jobs.