2 Replies Latest reply on Mar 2, 2017 8:59 AM by Cord Thomas

    Using CORR function - can't seem to make it work on calculated fields

    Cord Thomas

      I have two calculated fields,

       

      • [budgeted time of category A] / [total budgeted time of all categories] 
      • [actual time of category A] / [total actual time of all categories]

       

      My goal is to understand the correlation of budgeted vs actual time on various tasks.

       

      i tried to wrap these in a CORR or COVAR function and it is claiming my calculation is invalid.  These are all numeric fields.   I can see the individual results which are all fractions between 0 and 1.

       

      I am new to statistical programming so maybe i can't even do a correlation on these types of data?