5 ms·
I was sharing the average (mean) not median. Can you share how you arrived at that number? I've been trying to verify my approach to this. What I did: - Crea
by koliber 4y ago
I was sharing the average (mean) not median.
Can you share how you arrived at that number? I've been trying to verify my approach to this.
What I did:
- Create a spreadsheet for a simulation
- col 1 has "number of people remaining". I start this at 1000
- col 2 has "month number"
- col 3 has "% of people who left this month"
- col 4 has "number of people who left this month"
- in each new row, I subtract the col 4 value from the col 1 value to come up with a new headcount
- I fill this down for 10 years (120 months)
- for each month, I multiply the number of people that left \ the number of months they were there
- I sum the man-months worked, add the man-months for the people who are still there, and divide by 1000 (the number of people in the experiment). This is the average number of man-months.
- koliber 4y agoI just checked the median using my methodology and got 1.95 years. That's closer to your 1.7 than the mean of 2.7 I posted earlier.