Register to reply

What does E mean in this format?

by Tmp
Tags: format
Share this thread:
Tmp
#1
Jan13-11, 02:23 PM
P: 4
I'm just playing around with some stuff in excel.

I asked it to create a Polynomial trend line to the order 6 adn it came back wiht this...

Y = -9E-19x6 + 2E-14x5 - 2E-10x4 + 1E-06x3 - 0.0027x2 + 3.5222x - 1656.5


I just want to write that as a formula, but what's the E? I've seen it used to represent x10# before but that dosent seem to fit?

Can someone rewrite that in a format that works in excel?

eg.. = (10^-9)-(19*x^6).....
Phys.Org News Partner Mathematics news on Phys.org
Heat distributions help researchers to understand curved space
Professor quantifies how 'one thing leads to another'
Team announces construction of a formal computer-verified proof of the Kepler conjecture
NobodySpecial
#2
Jan13-11, 02:25 PM
P: 474
It is 10^x, in this case it means that the coeficients in x^3 and higher are zero.
Tmp
#3
Jan13-11, 02:28 PM
P: 4
I kind of get what your saying but I still can't see how I can write that as a formula that will work in excel if someone can do it I'm sure I'll be able to make sense of it

NobodySpecial
#4
Jan13-11, 02:34 PM
P: 474
What does E mean in this format?

assuming that x is a cell A1 then you can use E directly in any number

= -9E-19*power(A1,6) + 2E-14*power(A1,5) - 2E-10*power(A1,4) + 1E-06*power(A1,3) - 0.0027*power(A1,2) + 3.5222*A1- 1656.5

Although because the higher terms are so small this is really just

= 0.0027*A1*A1 + 3.5222*A1- 1656.5
HallsofIvy
#5
Jan13-11, 02:43 PM
Math
Emeritus
Sci Advisor
Thanks
PF Gold
P: 39,568
[QUOTE=Tmp;3081282]I'm just playing around with some stuff in excel.

I asked it to create a Polynomial trend line to the order 6 adn it came back wiht this...

Y = -9E-19x6 + 2E-14x5 - 2E-10x4 + 1E-06x3 - 0.0027x2 + 3.5222x - 1656.5

[itex]-9E-19[/itex] is "calculator speak" for [itex]-9 \times 10^{-19}= -0.0000000000000000009[/itex] (18 "0"s and "9" after the decimal point.)

Similarly
[tex]2E-14= 2\times 10^{-14}= .00000000000002[/tex]

[tex]-2 E-10= -2\times 10^{-10}= -.0000000002[/tex]

[tex]1E-06= 10^{-6}= 0.000001[/tex]

I just want to write that as a formula, but what's the E? I've seen it used to represent x10# before but that dosent seem to fit?

Can someone rewrite that in a format that works in excel?

eg.. = (10^-9)-(19*x^6).....


Register to reply

Related Discussions
.cda format Computers 10
Format for equations Advanced Physics Homework 1
What is this format ? General Discussion 6
I am sorry (format) Computing & Technology 0
APA format? General Discussion 3