4 Replies Latest reply on Jul 31, 2013 6:37 PM by Scott Tennican

    Is it possible to save trend line statistics to use in a calculation?

    Brittany Fong

      I want to be able to save the slope that is given after creating a trend line and use it in a calculation.

       

      Ex:

      Individual trend lines:

       

      Panes

      Line

      Coefficients

      Row

      Column

      p-value

      DF

      Term

      Value

      StdErr

      t-value

      p-value

      Order Line Value

      Quantity Ordered

      < 0.0001

      202

      Quantity Ordered

      13.7333

      0.521502

      26.3342

      < 0.0001


      intercept

      -12849.5

      17165.8

      -0.748553

      0.454997

       

      This is an example of what the output from the trend line would look like.  I want to save 13.7333 and use it in a new calculation.