$1.$ Create a new PivotTable showing Average Usual Hours Worked by Gender $($with Gender as the Row variable$).$

You should get a table that looks like this:

$2.$ Create a new PivotTable showing Average Usual Hours Worked for each state by Gender $($with Gender as the Row variable$).$

Chart the resulting data.

$3.$ Create a PivotTable which shows Average Yearly Earnings with Education in the Rows and Gender in the Columns.

Chart the resulting data.

$4.$ Based on the data can we conclude that having a higher level of eduction $($more years$)$ will result in higher wages?

Show the justification for your answer.

$5.$ Based on the data provided: Which state has the higher wages for females?

Show the justification for your answer.

Submit $1$ workbook $($containing all of the pivot tables and Chart on $1$ worksheet$)$ to the provided link. Label your worksheet 'Answers"

examples on how these are supposed to look with pictures please.