Forum Discussion
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
Using the E as scientific notation does not work.
Here is my data
| CD14 Concentration (pg/mL) | Average |
| 2000 | 1.016 |
| 1000 | 0.706 |
| 500 | 0.440 |
| 250 | 0.255 |
| 125 | 0.140 |
| 62.5 | 0.101 |
| 0 | 0.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?