Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

This question was created from P -Student – Designing a Pay Structure

August 26, 2019/in Questions Uploads /by Hannah Wangui

Question

Instructions for how to calculate in Excel are not provided. ATTACHMENT PREVIEW Download attachment

11582467-275968.jpeg

mgr; ﬂonduct a simple regression in Excel to create a market [3.113,r line
You can do this by entering the job evaiuation points [on the X axis} and the respective weighted average market
base pay [on the Y axis} for each benchmark job. Using this Excel output, the regression equation for the market Pa? line [external] is represented as: If = 35142): — 2331)
F:2 = 0.9?