2 Replies Latest reply on Feb 14, 2012 11:08 AM by kevin.spurgin

    standard score

      I have an input file consisting of mutiple iis file requests (from our application) and their associated Time-Taken value.  So each record is of the form


      iis_page_name_1  1048

      iis_page_name_2   3416

      iis_page_name_1   416



      I want to compute the z-score for each record so I can filter out any outlier records for a given page_name based on if the z-score is > 3.  I will then do a crosstab of averages adjusted for the exluded outliers.


      I have looked for examples, but cannot figure out how to do the z-score for each record.


      Any help would be appreciated!