3 ms·
A median of about 1.7 years, by my math.
by akhmatova 4y ago
A median of about 1.7 years, by my math.
- koliber 4y agoI 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.