You are reading a single comment by @rj and its replies.
Click here to read the full conversation.
-
I don't think so because the month they finish is not related to how long they take. And for live reporting the data output changes this month if for instance next month a very long project finishes.
rj-
Finish date for each completed project (or start date, or even midpoint date - up to you), not month on the x-axis.
-
Split your projects into cohorts based on when they started. Then figure out for each cohort after 1, 2 .. N months, what proportion were completed. Plot those cumulative distributions and compare. If you want to assess significance then you do a chi-squared test.
chez_jay
𝔒𝕨𝖑𝘡
Can't you just plot a scatter chart of start date (or end date) vs duration, and then add linear best fit line?