May 06 2021 01:11 PM
How do I write this formula in an Excel cell? y = 4E-11x3 - 3E-07x2 + 0.001x
May 06 2021 01:18 PM
May 06 2021 01:29 PM
May 06 2021 01:57 PM
May 10 2021 02:16 PM
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?
May 11 2021 02:29 AM
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).
May 11 2021 04:15 PM
May 12 2021 03:08 PM
Sorry, I'm missed - where is X and where is Y in your sample? Trendline formula shows how for known X calculate Y, not an opposite. Depends on that you may use any of formulas like
May 09 2023 12:55 PM