Hello,
I am trying to analyse data I have on 10 projects...
The table in this image shows the data: http://imgur.com/a/ETPi8
For each project (A-K), I have recorded the duration (in days) of stages in each project. Some projects were not completed as they were abandoned (for example Projects C and G) whereas some projects progressed without completing Stages 1, 2, 4 and/or 5.
I have used an Excel macro to work out the ANOM and draw the chart which can be seen from the above link.
Looking at the ANOM Chart, as far as I can see, the Stages 1, 2, 3 and 6 are the highly problematic since they are above the grand mean (the central line), and Stage 3 is dangerously above the Upper Decision Limit indicating that this stage takes way too long to complete compared with the rest of the project stages.
On the other hand, the Stages 4, 5 and 7 consume relatively shorter time to accomplish, with Stage 7 being extremely quick compared with the rest of the project stages... However, I do not quite understand why the Stage 4 Lower Decision Limit is a negative number?
So, my questions are:
1- Are there any issues with the above analysis?
2- Do you think it is appropriate to use ANOM in this example, and finally,
3- What am I missing from the interpretation of the ANOM Chart, which would be useful for the analysis?
Many thanks!
http://imgur.com/a/ETPi8
Dear Mesut,
If the number of projects were larger, this chart would be much more helpful. However, at this stage you have no other choice and this chart sheds light on the matter anyways.
There are no problems with stages 1, 2, and 6. It's true that they are over central limit, but these means are relative to each other and as long as they don't pass upper limit, they are fine. The stage 3 is indeed problematic and should be your main concern.
One idea is also to apply this chart without stage 7. Because this stage is less than lower limit anyways and you may consider it as an outlier.
Stage 4 doesn't have a negative number. This is approximately 15. Pay attention to the scale of your figure.
I hope you have found this comment useful.
Good luck :)
Dear Mani,
Many thanks for the comments. As you said, I think it is more appropriate to use this analysis with more projects so I am going to make few changes to the way I apply ANOM to my example.
Although it makes sense to discount the Stage 7 from the analysis, I am not sure if that would be appropriate for the descriptive analysis. Also, I am going to remove the UDL and LDL lines from the chart because I am not convinced they are appropriate to use in the current context. That leaves me with just the central line (the grand mean) and upper/lower lines which I hope will show the impact of each stage in the project; for example if the line is above the grand mean it is a sign of a problematic stage, whereas if the line is below the grand mean, it is okay.
Once again, thank you for your time, it is much appreciated.
Mesut
- Badges
- Science topic
- Similar topics
- Computer Science
- Images