0 Replies Latest reply: Jul 6, 2016 7:12 AM by Stu Morris RSS

    Using Linest to predict month end values

    Stu Morris

      Hi, I'm trying to predict month end values and have got as far as getting the results from a straight table.  I want to be able to get the value for y = mx + b, in this case for the last day in June, based only on the 'DayResult' figures recorded in June.  With the file attached, I can see the value for 30th June is 98.8342, when I select June from the list box.  Can I do this without a table, or even better, generate this value in the code?

       

      Many thanks,

       

      Stu.