1 Reply Latest reply on May 16, 2018 10:32 PM by lei.chen.0

    generate a power trendline from observed data

    William Graham

      in the attached spreadsheet i have 3 known columns {month, x, y} from which 6 values are known and 6 values yet to come

      i want to predict the last 6 values from the first 6 using a power trendline.


      the 2 computed values {c, b} are generated from the Excel LINEST function

      and a final column where i apply the generated power trendline using the formula: y = cx^b


      how might i do this in Tableau?