Florida Atlantic University Multiple Regression Test of Data On Public Employees

I’m working on a business question and need guidance to help me understand better.

Assignment 5 is an individual-based project which requires you to conduct a multiple linear regression analysis of a quantitative independent variables and pay rate. In doing so, you must do the following:

undefined

• Conduct a regression analysis for a quantitative independent variables and the rate of pay;
• Determinte the model fit (amount of variation explained by the model);
• Test significance of the estimated regression coefficients at 5% level of significance
• Specify the estimated regression model;
• Conduct predictions using the estimate model

undefined

After completing items 1 – 5, the following is required:

undefined

• Prepare the report on the analyses conducted;
• Prepare the table summarizing estimated regression coefficients and their significance
• Predict the expected hourly pay rate for the following groups of employees and summarize your predictions in a table:
  • A full-time Black male with 5 years of service in Police department;
  • A part-time Black male with 5 years of service in Police department;
  • A part-time White female with 10 years of service in Police department;
  • A part-time White male with 10 years of service in Police department;
  • A full-time Hispanic male with 5 years of service in Fire department;
  • A full-time White male with 5 years of service in Fire department;
  • A full-time Black male with 5 years of service in Fire department.
• Attach the Excel spreadsheets that contain the statistical output. Failure to attach the Excel spreadsheets to the assignment to verify that you performed the analysis will result in a 30 point deduction.

undefined

The required structure of this written assignment is as follows:

undefined

Cover Sheet

undefined

I. Executive Summary
a. Research question; b. Data and Method; c. Main Conclusions

undefined

II. Background (lit review)

undefined

III. Problem Statement (Research question)

undefined

IV. Analysis (Data and Method; Results)

undefined

V. Conclusions and Recommendations (findings and policy implications)

undefined

VI. Bibliography

undefined

VII. Appendecies