Most likely, the latter ('apply this wrong'). The equation is: y = 5 × 10^16 * e^(-3 × 10^-4x) Ottlots wrote: I must have omitted some important details or I am applying this wrong, because the results I am getting don't make sense. Ottlots wrote previously: I printed the trendline equation on the chart. If you are interested in copying the trendline coefficients into an Excel formula, let us know, and we can offer proper instructions. There rounded values are usually too inaccurate to use into an Excel formula. However, it would be wrong to copy the trendline coefficients exactly as they are displayed. So if you were to write that in an Excel formula, ostensibly it would be: =(5*EXP(16))*EXP(-(3*EXP(-4))*X1) I have over-parenthesized for clarity. Likewise, 5E+16e is '5 times 10 to the power of 16, that times e to the power of'. Uppercase 'E' is the Scientific notation for '10 to the power of'. More precisely, it is EXP(1), where EXP() is an Excel function. My question is, what is the capital E? You are correct about the lowercase 'e'. I believe e is the math 'e', approximately equal to 2.718 or so. I know what the variables x and y mean. y = 5E+16e^(-3E-04x) The '-3E-04x' are in superscript.
0 Comments
Leave a Reply. |