Question 6. To make a statistical inference about the trend of hourly wages of parttime and fulltime employees in the 15 to 24 age group, we need to construct trend lines over the decade. (a) Use the Excel le NWPB/Wages.xlsx for \"All Industries\" to construct two scatter plot diagrams of hourly wages (dependent variable) vs. month (independent variable) starting from t = 1, January 2008, for the tenyear period for parttime and fulltime employees. (b) Using an Excel worksheet, nd the regression lines, coefcients of determination, and coefcients of correlation. Is the linear trend evident for both cases? (c) Based on the regression model, estimate the average hourly wages of employees in Decem ber 2020