Excel Trendline Formula in Scientific Format

[Alberto]

For some reason, the when I insert a trend line into a
graph, the formula comes up with one part of it in
scientific format (y = 2750.2x2 - 64597x + 2E+06). I konw
the last expression in the formula is $2,000,000 but this
is rounded- and I need to know what the exact amount is.
I have tried extending the formula box, but that doesn't
work. Can anyone help me? Thanks in advance.

 

[Jerry W. Lewis]

Right click on the formula and format to scientific notation with 14
decimal places. Alternately, you could use
=LINEST(ydata,xdata^{1,2})
although in it has the potential to lose accuracy in Excel versions
prior to 2003.

Jerry