7 Replies Latest reply: Sep 5, 2017 3:39 PM by Sunny Talwar RSS

    Linest_R2

    Michael Rainey

      LINEST_R2(

            aggr(avg(Hours),CalendarDate),CalendarDate

      )

       

      I am trying to calculate R but the number I am getting is really low.  Is there a way to increase the forgiveness of R.

       

      I'm not talking about taking the square root of it.  Maybe rounding the average to the nearest integer?