$11\mathrm{.}4$ Using the table on the Hourly Rate worksheet, complete the "Hourly Rate $"$ and "Monthly Salary" columns for each employee on the Attrition worksheet. Assume a $40-$hour work week and $4$ weeks in a month to compute the monthly salary.

Then, do exploratory analysis of the Attrition data to determine in which department the average monthly salar of male employees is more than female employees.

Calculate the hourly rate and monthly salary for the first employee then use copy and past to complete the column.

Use the Task $4$ worksheet as your work area forthe explorator analysis.

The PivotTable should display the Gender as the rows.

Select your answer from the drop down in cell B$3).$