I hope there is an easier way to calculate the following in excel:
I am endeavoring to determine the weighted hourly rate of pay to determine the 75th percentile for a market wage rate study.
Example of data
3 hours at $45, 160 hours at $25, 900 hours at $65. (this is 3 examples of hour...