Plot the hourly compensation of A and the hourly compensation of B on the same graph (blue for B and orange for A) in Excel. Assume that the tendency is linear, that is, each year the compensation increases at a constant rate. Compare the results:
As we see, in 2019 the hourly compensation must be higher in country B, no matter what is the actual number of hours worked in both countries because we compare hourly values. The amount of actual hours worked in countries is excessive information for the estimation of the hourly labor cost.
The linear equations passing two points with coordinates "(x_1, x_2), (y_1, y_2)" that describes the growth of hourly compensation were computed as follows:
For instance, substitute our values for country A:
"x_1=2015,\\\\\ny_1=25.96;\\\\x_2=2019,\\\\y_2=28.29."
multiply both sides by "4\\cdot2.33":
express y:
The equation for B can be calculated likewise.
Comments
Dear Naomi kuria, You are welcome. We are glad to be helpful. If you liked our service, please press a like-button beside the answer field. Thank you!
Wow. Thanks so much.
Leave a comment