You are reading a single comment by @chez_jay and its replies. Click here to read the full conversation.
  • What is the statistically sound way to find out if the the length of projects are decreasing over time ?

    The obvious one is to just take an average of all finished projects each month and see a change. But at the start of records it will be unstable and as you get to the present it will become more and more stable and harder to move the average.

  • Can't you just plot a scatter chart of start date (or end date) vs duration, and then add linear best fit line?

  • 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.

About

Avatar for chez_jay @chez_jay started