Niagara Workforce Planning Board (NWPB) Case Study Data Statistics Canada publicizes collected data from various data sources. In this assignment, Statis- tics Canada provided data in relation to the Niagara Workforce Planning Board. Niagara Work- force Planning Board examines factors related to Niagara's regional labour force and jobs. As a result, insight into employment specifics is possible; this allows one to examine relationships amongst job aspects such as wages, employment patterns, and export trends. Note: Use Excel for all computations and graphs. Question 1. The Niagara Workforce Planning Board (NWPB) is interested to know knowing whether there is any association between age of employees and type of work (full-time/part- time) in 2017. Construct the following contingency table using 'All Industries' in the file NWPB/Wages.xlex and the year 2016: Type \\Age: 15-24 years 25-54 years 55 and over Total: of work ! Full-time employee Part-time employee Total Assuming that a single employee recently hired is randomly selected from the sample data: (a) What is the probability that the employee is from the 15 - 24 age group given that the work is part-time? (b) What is the probability that the work is part-time and the employee is from the 15 - 24 age group? (c) What is the probability that the work is part-time given that the employee is from the 15 - 24 age group? (d) Is the employee's full-time work status independent from their 15 - 24 age group? (e) Test, at the 5% significance level, the claim: the type of work (full/part-time) is indepen dent from the age category. Should Ho be rejected at the 5% significance level? (Hint: use the x' test of independence). Give an explanation for your conclusion