1 2 Previous Next 17 Replies Latest reply on Apr 4, 2018 8:45 AM by Deepak Rai

    Z-score calculation

    John McGuirk

      I seem to be stuck calculating the correct z score by investment security spread info.  I am trying to build a view that shows the most recent z score by spread series for the specific date range in the date filter.  But the values on the view are not equal to what I calculate manually and am not sure what is wrong with my z score calculation.  For example, on Sheet 2 Tableau is showing a z score value of 2.549 for CLO BBB.  I manually calculate a z score value of -2.201 using the 3/23/18 CLO BBB spread data point of 275.  Any help would be greatly appreciated.  My workbook is attached.  Thanks.

        1 2 Previous Next