3 Replies Latest reply on Nov 22, 2012 7:20 PM by Dimitri.B

    My Standard Deviation (reference distribution) do not match my window calculated Standard Deviation

    Claire Blondin

      I have a bar chart presenting building energy consumption by area to which I add the median and standard deviation plotted by using the reference lines.

      The displayed Standard deviation  is not equally distributed on either side of the media on the chart and if do a windows calculation for the media and standard deviation the result for the media is correct but the standard deviation is off

       

      I have plotted as line the calculated standard deviation

      Can anyone help me  to  understand and correct this issue. I have attached a sample of the test workbook

       

      TX