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

      etc.

       

      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!