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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Chart Formula Displayed in Scientific Format 2
Calculation using a trendline 3
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
large numbers as text replaced with scientific notation 2
Number Formatting help 3
Excel 2007 bug? Merged cells must be formatted as scientific 2
Curve fitting with weighted trendline 1
Trendline equation and data do not match up 3

Back
Top