This is all the information I received for these questions. I just need help with (d) and Question 2

Background of Data In this exam, you will look at some analysis on a Technology company employee and their experience, education and their annual salary. In addition, the company examines various departments and their relationship with the employee proles. The data is based on the records from 2003 to 2010. You are required to examine the outputs covering different areas of the analysis and provide the insight report for the cOmpany to understand its departmental roles and their driving capacity towards the future expansion in the country. Question 1 (18 marks) The table below consists of employees' annual salary by their age group. Number of Cumulative Cumulative % of employees aged 40 number of Employee aged 40 and and over employees Over _ m Question 2 (18 marks) The company would like to nd more details about the departments and the respective employees. One of the departments to look into is the production and engineering and its number of employees by gender and their educational attainment. (a). To do so the data is Summarised in the the contingency (pivot) tables. Shown below is the table illustrating the number of employees from all the departments by gender and the educational attainment (in years). _- Count of Employee Next is a table showing the employees from the Production and Engineering by gender and the educational level. Department Production and Engineering Count of Employee Grand Total Grand Total The table below is for the employees that are in the department of production and engineering. Department Production and Engineering Count of Employee Gender Education Female Male Grand Total 0 5.13% 1.28% 6.41% 2 3.85% 1.28% 5.13% 4 34.62% 28.21% 62.82% 6 10.26% 11.54% 21.79% 8 1.28% 2.56% 3.85% Grand Total 55.13% 44.87% 100.00%(b). Looking at the table below answer the following questions. Department Production and Engineering Count of Employee Gender Education Female Male Grand Total 0 80.00% 20.00% 100.00% 2 75.00% 25.00% 100.00% 4 55.10% 44.90% 100.00% 6 47.06% 52.94% 100.00% 8 33.33% 66.67% 100.00% Grand Total 55.13% 44.87% 100.00%