For this assignment, you will be working on a data set on Technical Sales Representatives. The purpose of the analysis is primarily to compare salaries of males and femal representatives. You will perform analysis (as suggested below) and then write a report for your supervisor based on your findings. Your report has to be professional. (You might want to use examples from the book on writing big data, e.g. on page 76. As a note, I have modified the data taken from the book for this assignment.)

Do your analysis in R.

Data cleaning - are there any missing data? If yes, what do you want to do with them? Provide your rationale for your action.

Obtain summary data for the appropriate variables. What information can you get from the summary?

Provide a histogram of salary for the cleaned data.

Aggregate the average salary for male and female. Create a bar chart for the salary by gender.

Create two subsets of the data - one for females (Female=1) and another for Males (Female=0)

Create a boxplot for salary for female repsresentatives (using the Female subset)

Create a boxplot for Salary for male representatives (using the Male subset)

Bin the data for salary into (<25K, 25-75K, 75-125K, >125K) and age into (<25, 25-30, 30-35, >35). Create a heatmap to show the relationship between salary and age (based on the binned data).

(Your plots need to have a title and be appropriately labeled.)

Provide a report based on your findings. Your report should have an appropriate title, an introduction, a section on your analyses (include tables and charts as appropriate), and some concluding remarks.

Submission:

R codes

Report (in Word)