1 Reply Latest reply on Sep 15, 2014 10:10 AM by Cac47

    Display the Simulated Sales and Sales Forecast using Least Square Regression - REGR_SLOPE

    Cac47

      Hi there,

       

      I've this table

      How Can I get the Values for the 2014_Forecast and Simulated_2014 using the Least_Square_Regresion or using REGR_SLOPE function?

       

      TRANSACTION_TYPEMONTHYEAR_2012YEAR_20132014_Forecast Simulated_2014
      Sales01-18.74-38.00
      Sales02-19.60-34.09
      Sales03-20.20-33.10
      Sales04-19.96-32.21
      Sales05-23.13-29.63
      Sales06-23.88-28.46
      Sales07-30.11-43.89
      Sales08-33.69-35.97
      Sales09-32.65-29.57
      Sales10-37.22-28.18
      Sales11-37.15-31.63
      Sales12-41.70-32.76

       

       

      Thanks in advance fro your Help.

      Rgds

      Carlos