Forum Discussion

gbrcooper's avatar
gbrcooper
Copper Contributor
Jan 29, 2020

Trendline equation scientific format

Is it possible to display a linear trendline in scientific notation? Of so, how?

3 Replies

  • PReagan's avatar
    PReagan
    Bronze Contributor

    Hello gbrcooper,

     

    I'm afraid you will need to elaborate. Do you mean to display the coefficients of a linear regression in scientific notation?

    • gbrcooper's avatar
      gbrcooper
      Copper Contributor

      Thanks for the quick reply, PReagan 

       

      Yes, I need to display the Excel-calculated y=mx+b equation, but the format of the coefficients must be in scientific notation. My apologies for not being clear in the initial question.

      • PReagan's avatar
        PReagan
        Bronze Contributor

        gbrcooper 

         

        Can you share a sample file of your regression formula along with an example of exactly how you would like it to appear?

Resources