Excel Trendline Formula in Scientific Format

  • Thread starter Thread starter Alberto
  • Start date Start date
A

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.
 
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
 
Back
Top