Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Conduct a simple regression in Excel to create a market pay line by entering the job evaluation points(on the X axis) and the respective weighted
Conduct a simple regression in Excel to create a market pay line by entering the job evaluation points(on the X axis) and the respective weighted average market base pay (on the Y axis) for each benchmark job. Calculate the summary output, regression statistics (Multiple R, R Square, Adjusted R, Square, Standard Error, Observations). Calculate also the ANOVA and RESIDUAL OUTPUT. Regression Analysis Job Evaluation Weighted Points Avg $ X = 120 Y = 19944.44 X = 145 Y = 29458.33 X = 165 Y = 34000 X = 225 Y = 56875 X = 260 Y = 62900
Step 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