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?
excel
PReagan's avatar
PReagan
Bronze Contributor
Jan 29, 2020

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
    Jan 29, 2020

    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
      Jan 29, 2020

      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