Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please answer using as much detail as possible. Thanks The personnel director for a manufacturing company is reviewing the annual salaries for all the machinists
Please answer using as much detail as possible. Thanks
The personnel director for a manufacturing company is reviewing the annual salaries for all the machinists and millwrights that currently work for the company (a total of 24 workers). Besides salary, employee records also provide data for the most recent performance ratings, total years working for the company, and the number of specific jobs in the plant the worker is qualified to be assigned to. This information is included in the Assignment 5 spreadsheet. The director wants to build a regression model to estimate the average salary an employee should expect to receive You are to use the Assignment 5 spreadsheet to build the model requested. You must then use your model to answer the following 3 questions. You must submit all regression reports that were run to answer this question. If the director wanted to build a regression model to predict salary based on 2 independent variables, which two variables should be used? Explain why and develop a regression model based on these two variables Suppose all three independent variables in the data set were used in a regression model to predict salary. Develop the regression model and briefly explain whether your model from question 1 or a model with three independent variables would be the most effective model to use. Suppose the company considers an employee's salary to be fair as long as it falls within 1.5 standard errors of the value estimated by the regression model. What salary range would be considered fair for an employee with 10 years experience, who received a performance rating of 7.20, and is qualified to work at 4 job assignments in the plant? (using whatever regression model you feel is most effective; with 2 or 3 independent variables). State your assumptions and show your calculationsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started