Question: Second, calculate the weighted means ( for base pay ) for each benchmark job. table [ [ Company , # of JobIncumbents,,Base Pay ]

Second, calculate the weighted means (for base pay) for each benchmark job. \table[[Company,# of JobIncumbents,,Base Pay],[A],[Administrative Assistant,4,Average,$25,000],[,Minimum,$21,000],[,Maximum,$28,000],[B],[Administrative Assistant,4,Average,$31,000],[,Minimum,$27,000],[,Maximum,$34,500],[C],[Administrative Assistant,3,Average,$30,000],[,Minimum,$29,000],[,Maximum,$32,000],[D],[Administrative Assistant,5,Average,$33,000],[,Minimum,$28,000],[,Maximum,$34,000],[E],[Administrative Assistant,4,Average,$29,000],[,Minimum,$27,000],[,Maximum,$30,000],[F],[Administrative Assistant,4,Average,$28,000],[,Minimum,$27,000],[,Maximum,$30,000]]\table[[Company,# ofJobIncumbents,,Base Pay],[A,,,],[Operations Analyst,2,Average,$55,000],[,,Minimum,$50,000],[,,Maximum,$60,000],[B,,,],[Operations Analyst,4,Average,$57,000],[,,Minimum,$54,000],[,,Maximum,$59,000],[C,,,],[Operations Analyst,3,Average,$56,000],[,,Minimum,$54,000],[,,Maximum,$58,000],[D,,,],[Operations Analyst,5,Average,$58,500],[,,Minimum,$52,000],[,,Maximum,$61,000],[E,,,],[Operations Analyst,3,Average,$59,000],[,,Minimum,$57,000],[,,Maximum,$61,000],[F,,,],[Operations Analyst,3,Average,$54,000],[,,Minimum,$53,000],[,,Maximum,$55,000]]\table[[Company,# ofJobIncumbents,,Base Pay],[A],[Payroll Assistant,2,Average,$35,000],[,Minimum,$34,000],[,Maximum,$36,000],[B],[Payroll Assistant,3,Average,$34,000],[,Minimum,$32,000],[,Maximum,$35,000],[C],[Payroll Assistant,1,Average,$35,000],[,Minimum,],[,Maximum,],[D],[Payroll Assistant,3,Average,$35,000],[,Minimum,$33,000],[,Maximum,$37,000],[E],[Payroll Assistant,2,Average,$36,000],[,Minimum,$35,000],[,Maximum,$37,000],[F],[Payroll Assistant,2,Average,$29,000],[,Minimum,$27,000],[,Maximum,$31,000]]\table[[Company,# ofJobIncumbents,,Base Pay],[A,,,],[Benefits Manager,1,Average,$62,000],[,,Minimum,],[,,Maximum,],[B,,,],[Benefits Manager,2,Average,$61,500],[,,Minimum,$61,000],[,,Maximum,$62,000],[C,,,],[Benefits Manager,1,Average,$60,000],[,,Minimum,],[,,Maximum,],[D,,,],[Benefits Manager,3,Average,$64,000],[,,Minimum,$62,000],[,,Maximum,$65,000],[E,,,],[Benefits Manager,2,Average,$63,000],[,,Minimum,$62,000],[,,Maximum,$64,000],[F,,,],[Benefits Manager,1,Average,$66,000],[,,Minimum,],[,,Maximum,]]
\table[[Company,# ofJobIncumbents,,Base Pay],[A,,,],[Front Desk Receptionist,1,Average,$21,000],[,,Minimum,],[,,Maximum,],[B,,,],[Front Desk Receptionist,2,Average,$22,000],[,,Minimum,$21,000],[,,Maximum,$23,000],[C,,,],[Front Desk Receptionist,1,Average,$18,000],[,,Minimum,],[,,Maximum,],[D,,,],[Front Desk Receptionist,2,Average,$21,000],[,,Minimum,$20,000],[,,Maximum,$22,000],[E,,,],[Front Desk Receptionist,2,Average,$18,500],[,,Minimum,$18,000],[,,Maximum,$19,000],[F,,,],[Front Desk Receptionist,1,Average,$17,500],[,,Minimum,],[,,Maximum,]]
Please show me how to calculate the weighted means and explain how you are doing this so I can replicate same steps with similar data.
 Second, calculate the weighted means (for base pay) for each benchmark

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!