Question

	Minimum Salary Increase Percentage	Maximum Salary Increase Percentage	Mid-Point
Quartile 1	4.15%	5.30%	4.73%
Quartile 2	4%	5%	4.50%
Quartile 3	3.75%	4.80%	4.28%
Quartile 4	3.25%	4.35%	3.80%

1. Employee A has increase at the mid-point in Quartile 2 which is 4.50% and the company decided to change his Quartile to be Q3 so his new increase will be 4.28% the mid-point in Q3.

2. Employee B has increase 5.30% as maximum in Quartile 1 and the company decided to change his Quartile to be Q4 so his new increase will be the maximum in Quartile 4 which is 4.35%.

3. Employee C has increase 4.90% in Quartile 1 and the company decided to change his Quartile to be Q4 so what is his new increase in Q4?

Please answer the question with explanation.

Answer 1

ANSWER::

As we can see from the examples given about employees A and B, when an employee' s quartile is changed, there is a corresponding change in their Salary Increase Percentage which is in proportion to the difference between max and min increase of that particular quartile.

So, here, Emp. C has an increase of 4.90 in Q1.
(Increase - Min of Q1)/(Max of Q1 - Increase) = (New Increase - Min of Q4)/(Max of Q4 - New Increase)

To check whether the above formula is right, we put in the the value of the mid-point of Q1.
(4.73 - 4.15)/(5.30 - 4.73) = (N - 3.25)/(4.35 - N)
=> 0.58/0.57 = (N - 3.25)/(4.35 - N)
=> N = 3.80

So, we see that the equation formed above is correct. Using the value of 4.90 as increase percentage, we find the New Increase -
(4.90 - 4.15)/(5.30 - 4.90) = (N - 3.25)/(4.35 - N)
=> 0.75/0.4 = (N - 3.25)/(4.35 - N)
=> (4.35 - N) * 0.75 = 0.4 * (N - 3.25)
=> 4.35 * 0.75 + 3.25 * 0.4 = N (0.4 + 0.75)
=> 4.5625 = N * 1.15
=> N = 3.967

So, the new increase in Q4 is 3.967%

NOTE:: I HOPE YOUR HAPPY WITH MY ANSWER....***PLEASE PLEASE SUPPORT ME WITH YOUR RATING...

***PLEASE GIVE ME "LIKE"...ITS VERY IMPORTANT FOR ME NOW....PLEASE SUPPORT ME ....THANK YOU