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?

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        May 11, 2021

        fradella100 

        Formula gives not exact but close to your data result

        Please note, if you enter the formula with scientific notation Excel automatically converts such numbers to "number" format where possible.

        For example, if you type

         after you hit Enter same formula will be shown as

        (in A1 is number 2).

Resources