Question

Employee Number	Age	Salary	Degree	Gender
1	32	$98,000	None	Female
2	35	$121,000	Bachelors	Female
3	48	$125,000	Masters	Male
4	40	$141,000	Masters	Male
5	43	$152,000	Masters	Male

Create a histogram between degree and salary.

Answer 1

Answer:

Salary	Degree
$98,000	None
$121,000	Bachelors
$125,000	Masters
$141,000	Masters
$152,000	Masters

For above data histogram is as follows.

Answer 2

Answer 3

To create a histogram between degree and salary, you need to first organize the data and then plot the histogram. Since the data is given in a tabular format, we'll use Python with the matplotlib library to create the histogram.

Assuming you have the data in a CSV file named "employee_data.csv", you can use the following Python code to create the histogram:

pythonCopy codeimport pandas as pdimport matplotlib.pyplot as plt# Read the data from the CSV filedata = pd.read_csv("employee_data.csv", delimiter="\t")# Create a dictionary to map degree to its respective salariesdegree_salary = {}for index, row in data.iterrows():
    degree = row['Degree']
    salary = int(row['Salary'].replace("$", "").replace(",", ""))    if degree in degree_salary:
        degree_salary[degree].append(salary)    else:
        degree_salary[degree] = [salary]# Create a list of salaries for each degreebachelors_salaries = degree_salary.get('Bachelors', [])
masters_salaries = degree_salary.get('Masters', [])
none_salaries = degree_salary.get('None', [])# Create the histogramplt.figure(figsize=(10, 6))
plt.hist([bachelors_salaries, masters_salaries, none_salaries], bins=10, alpha=0.7, label=['Bachelors', 'Masters', 'None'])
plt.xlabel("Salary")
plt.ylabel("Frequency")
plt.title("Histogram of Salary by Degree")
plt.legend()
plt.grid(True)
plt.show()

Make sure you have the required libraries installed (pandas and matplotlib) using pip if you haven't already.

This code will create a histogram with three bars representing the salary distribution for employees with Bachelors, Masters, and None degrees. The x-axis represents the salary, and the y-axis represents the frequency of employees in each salary range for each degree category.