Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed

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 calculations

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions