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