Productivity Variance Analysis

JoeUser2004 Hi Joe, thanks for understanding  and replying. On another forum I asked 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.
and also tried working in my way with data. can it be help for me if I add that file here? 

Question - If I understand you correctly, you write "at Q2" and "at Q3" as if they indicate time periods; i.e. "quarter 2" and "quarter 3".

Ans-  Per my view its Quartile 

Question - So, your various calculations seem to (intend to) determine each person's productivity relative to 50% and 75% of the group.  Is that what you really mean?

Ans - Yes somewhat.

Question - PS.... For my edification, how is the ratio "workout"/"core time" a measure of "productivity" per se?  Is that a standard statistic that PTs use?  What is the unit of measure for "workout"?

Ans - Workout is total work processed (accumulated time)

Question - Moreover, your "total" calculations do not seem to have anything to do with the stated goal, to wit:  "who is more productive".  So please explain what the "total" calculations are intended to demonstrate.

Ans - how  an individual or whole team productivity is tenure wise, there might be possibility those who are in the system from quite long are not that much productive to the with lesser time period.