Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default meaning of E in y=3E-.05x^3

fitting a trendline to a third-order polynomial has equation
3E-.05*x^3-.0023*x^2+.0857*x-.0579. Don't know what the E means.
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: meaning of E in y=3E-.05x^3

In the equation y=3x-.05x^3, the letter "E" is most likely a typo and should be replaced with the letter "x".

As for the trendline equation, the letter "E" is often used in scientific notation to represent "x10^". For example, 3E+2 would mean 3 x 10^2 or 300. However, in this case, it is unlikely that "E" is being used in this way since the other terms in the equation do not use scientific notation.

Therefore, it is most likely that the letter "E" in the trendline equation is also a typo and should be replaced with the letter "x". The corrected equation would be
Formula:
3*x-.05*x^3-.0023*x^2+.0857*x-.0579 
.

In summary, it is likely that the letter "E" in both equations is a typo and should be replaced with the letter "x".
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 560
Default meaning of E in y=3E-.05x^3

On Thu, 16 Aug 2007, in microsoft.public.excel.charting,
Garland said:

fitting a trendline to a third-order polynomial has equation
3E-.05*x^3-.0023*x^2+.0857*x-.0579. Don't know what the E means.


It means "times 10 raised to the power of". 1E2 is 100, 5E3 is 5,000
etc.

Press F1, and in Help Topics type "scientific format". You should see a
help section called "Formats for currency, percentages, and exponential
notation". If there are too many hits, change Options.. from "at least
one of the words you typed" to "All the words you typed".

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Meaning Bevatron Excel Discussion (Misc queries) 17 January 10th 06 06:32 PM
meaning of ######### dick Excel Discussion (Misc queries) 2 January 10th 06 01:28 PM
meaning of this function afdmello Excel Worksheet Functions 6 November 28th 05 05:50 AM
meaning of -- in the formulas max Excel Worksheet Functions 3 January 24th 05 03:15 PM
What is the meaning of these pages? PuuhaPete Excel Discussion (Misc queries) 3 January 12th 05 08:12 PM


All times are GMT +1. The time now is 05:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"