Problem 8 (8 points) Please find the attached EXCEL file named "Pay." Bob wants to predict the hourly pay by findings the influential factors from four aspects: Job Class, Years with Company, Years in Union, and Local. Please use EXCEL to run multiple linear regression. (1) Please code the Variables of "Local" as a dummy variable. Please list the first five observations' numbers after your coding for "Local" Please attach a screenshot of the multiple linear regression output (1 point) (2) If we denote the Variable of "Hourly Pay" as "P," "Job Class" as "J," "Years with Company" as "C," "Years in Union" as "U," and "Local" as "L," Please list the multiple linear regression model. (2 points) (3) Please discuss the model fitness by focusing on the adjusted R Square Value. (1 point) (4) If Tom knows another observation has the values of J, C, U, and L as 30, 10, 8, and Y, please help Bob to predict the hourly pay. (2 points) (5) What are the statistically significant factors for the hourly pay, are they positively significant or negatively significant? Why? (2 points)