4 Replies Latest reply: Jul 23, 2012 3:05 PM by Nagaian Krishnamoorthy RSS

    Use polynomial regression result to predict future

      I have a follow up question about the polynomial regression. How to use the regression result to forcast future?

       

      I mentioned there is statistical function for linear regression: linest_m and linest_b, so we can use linest_m and linest_b to forcast future.

       

      But i don't know whether there is representation of a1, a2, a3, a4, m in the formula below

      Y =  a1 * x^4 + a2 * x^3 + a3 * x^2 + a4 * x + m

       

      Thanks!