PROBLEM 1: (20 Marks) Use the dataset provided in the Excel file Job Satisfaction:

a) Build a regression model for overall job satisfaction as the dependent variable and use years of service and department as independent variables. For handling the categorical department variable, define the appropriate dummy variables, as it contains multiple categories. Use the administrative department as your reference category. (14 Marks)

b) Provide explanations regarding the statistical significance of each coefficient in the regression model. (6 Marks)