A manager of a product sales group believes the number of sales made by an employee (Y) depends on how many years that employee has been with the company (X1) and how he/she scored on a business aptitude test (X2). A random sample of 8 employees provides the following (refer Table 4): Table 4 Employee Y X1 X2 1 100 10 7 2 90 3 10 3 80 8 9 4 70 5 4 5 60 5 8 6 50 7 5 7 40 1 4 8 30 1 1 (a) Run a regression analysis based on the data in Table 4 using Mic. Office EXCEL. Based on the output, propose a regression equation that can be used to predict paralegal GPA. (5 marks) (b) Interpret the coefficient value of each independent variable in the constructed model. (4 marks) (c) Is each independent variable sharing a significant linear relationship with the dependent variable? Verify at 0.05 level of significance. Make your conclusion based on the p-value in the EXCEL output. (21 marks)