> I am just trying to find the exact number the formula is > generating for subsequent months. "ottlots" wrote: > In the chart, the trendline follow the expected trajectory. But it is the best we can do, since Excel limits its displayed valuesto 15 significant digits. I suggest using Scientific with 14 decimal places if you intend to copy the coefficients into an Excel formula. In fact, you can format the trendline "label" (displayed formula) so that it displays more precision. The point is: 5E+16 and -3E-04 are rounded approximations. There rounded values are usuallytoo inaccurate to use into an Excel formula". As I wrong before: "it would be wrong to copy the trendline coefficients exactly as they are displayed. I agree that the following formula results in about 215E+09: =5E+16*EXP(-3E-04*A2) I anticipatedthe problem. > Plugging the known numbers in to the formula, I am getting > 215B. > Roughly speaking, the result usingSeptember 30 end of > month (41182)as "x", I would expect this formula to > generate a "y" of greater than 33B and less than 34.5B. These are in date > format in Excel, but are whole numbers in formulas > (4112 respectively). "ottlots" wrote: > The "x"s in this caseare dates at the end of the month: > Aug 31, 2012, September 30, 2012, etc. Most likely the latter ("apply this wrong"). > The equation is: > y=5E+16e-3E-04x "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: =(5E+16)*EXP(-(3E-04)*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". Ibelieve e is the math "e" > = 2.718 or so. I know what the > variables x and y mean. > The equation is: > y=5E+16e-3E-04x > The "-3E-04x" are in superscript. "ottlots" wrote: > I printed the trendline equation on the chart.
0 kommentar(er)
