0 Replies Latest reply on Jul 26, 2012 1:27 PM by Cody Hall

    Average w/in a Distribution

    Cody Hall

      Hey everyone,

       

      I set up color banding in a trend graph to display different stages of an implementation in the background.

       

      My dependent variable is staffing FTE's, independent is relative week (counting like a rocket launch Week minus 1, Go live, etc.)

       

      How can I create a reference line showing the average of all items w/in a given distribution?

       

      I'll paint on what I'd like to see and attach the workbook below. Thanks for any advice!

       

      -Cody

       

      Note: blue drawn lines represent the avg for that distribution section.

      Averages.JPG