To make a statistical inference about the trend of hourly wages of part-time and full-time employees in the 15 to 24 age group, we need to construct trend lines over the decade.

(a) Use the Excel file 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 ten-year period for part-time and full-time employees.

(b) Using an Excel worksheet, find the regression lines, coefficients of determination, and coefficients 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.