Please help. I don't know to calculate the table. I'll attach the excel link. You will have to copy and paste the link online to access the excel table. Here is the link -

https://docs.google.com/spreadsheets/d/1a81N8gbbGnlBsUMBAqI6nKTPsd1rLoIp4IUNvi6sKAc/edit?usp=sharing

Question 3 The Niagara Workforce Planning Board (NWPB) is interested in knowing whether there is any association between the age of employees and type of work (full-time/part-time) in 2016. Construct the following contingency table using 'Total employees, all wages' for 'All lndustries' in the Wages sheet of the file NWPB.xlsx. The values of the contingency tables will be the monthly mean number of employees of the 12 months of 201 6 (x 1,000). (Hint: Multiply the mean by 1000 for each entry) Age Type of Work 15 24 years 25 54 years 55 and over Full-time Employee 452167 Part-time Employee Assuming that a single employee is randomly selected from the sample data: a) What is the probability that the employee is from the 25 - 54 age group given that the work is full-time? b) What is the probability that the work is full-time and the employee is from the 25 - 54 age group? c) What is the probability that the work is full-time given that the employee is from the 25 - 54 age group? d) Is the employee's full-time work status independent from their 25 - 54 age group? e) Test, at the 5% significance level, the claim: the type of work (full/part-time) is independent from the age category. Should Ho be rejected at the 5% signicance level? (Hint: use the X2 test of independence). f) Use the stacked bar graph below along with the result in e) to make a conclusion between the age of employees and type of work. Age of Employees vs Type of Work 15- 24 25-54 55 and over I FUII'tiI'DE I Parttime n. Inn':nn A