Analyze Quartile wise stats Tenure wise

[Maddy29]

Dear Experts ,
I wanted to analyze the data from Quartile 2 to Quartile Q3.
How is Individual's productivity against workout in these quartile tenure wise. how much hours is extra worked individually.

As an intermediate I figured out the data like -
1. - I figured the productivity % by dividing workout/coretime.
2.- to get the productivity @ Q2 , first I took the average of prod (quartile(productivity range,2) & said if Produ is < than productivity @ Q2 then productivity @ Q2 else prductivity value
3-. to get the productivity @ Q3 , first I took the average of prod (quartile(productivity range,3) & said if Produ is < than productivity @ Q3 then productivity @ Q3 else prductivity value.
4. for workout @ Q2 simply apply - iferror(workout/productivity)*productivity at Q2),"")
5. same did for workout @ Q3 simply apply - iferror(workout/productivity)*productivity at Q3),"")

figured out some calculation for sample
workout baseline - sum of workout
workout @ Q2 - sum of workout @ Q2
workout @ Q3 - sum of workout @ Q3
Total Coretime - sum of Coretime
total productivity baseline = sum of workout/sum of coretime
Total productivity @ Q2 = sum of workout @ Q2 / sum of coretime
Total productivity @ Q2 = sum of workout @ Q3 / sum of coretime


Could someone please help me with my request.

 

[Fluff]

Duplicate to: Analyze Quartile wise stats Tenure wise

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.