Forum Discussion
Productivity Variance Analysis
Maddy29975 wrote: ``I am just wondering how can I calculate my stats in excel since dont have time components as such.``
Before I consider "how ... in excel" per se, I would first consider how I would define statistics mathematically that take tenure time into account.
I am not comfortable offering guidance about that. In fact, I had offered suggestions in some earlier responses. But I deleted them for lack of confidence, which is why you are unable to respond to them now.
-----
Food for thought.... I do not understand or agree with your calculations for productivity (column J), as well as the calculations in column H through K and the "total" calculations in M5:N16.
I would measure productivity (as I infer your definition to be) as the percentage of workout time that is not core time. That is =1 - F2/E2 or equivalently =(E2-F2)/E2 in G2. It is not =E2/F2.
And instead of the calculations in H:K, I would use =PERCENTRANK($G$2:$G$25, G2, 4) formatted as Percentage to determine how a person's productivity compares with others. That is the percentile of his/her productivity.
And again, I have no idea about what you are trying to "say" statistically with the "total" calculations in M5:N16. The "explanation" in your Dec 10 response did not improve my understanding.
Good luck!
workout time is total work processed and core time is spent on the system.
for an example if my core time is 10 hrs. in a day and have processed only 80 than my productivity is 80% and same way if processed 120 than its 120%. the faster I work more time is saved and lesser I work productivity decreases.
So without going into complex calculations ,
How can I show how much hours saved if productivity is bumped up.