Forum Discussion

fradella100's avatar
fradella100
Copper Contributor
May 06, 2021

How to convert trendline with E into Excel formula?

How do I write this formula in an Excel cell? y = 4E-11x3 - 3E-07x2 + 0.001x
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 06, 2021

fradella100 

Perhaps you mean

=4E-11*A1^3 - 3E-07*A1^2 + 0.001*A1
  • fradella100's avatar
    fradella100
    Copper Contributor
    May 06, 2021
    I understand how to raise cell A1 to the exponent of 3 "A1^3"
    What do I do with the 4E?
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 06, 2021

      fradella100 

      That's scientific notation for the number. 4E-11 is the same as 0.00000000004

       

      • fradella100's avatar
        fradella100
        Copper Contributor
        May 10, 2021

        SergeiBaklan 

         

        Using the E as scientific notation does not work.  

         

        Here is my data

        CD14 Concentration (pg/mL)Average
        20001.016
        10000.706
        5000.440
        2500.255
        1250.140
        62.50.101
        00.000

        y = 1E-10x3 - 6E-07x2 + 0.0012x

         

        How can I write the slope formula so that I get reasonable values when solving unknows ie x?

Resources