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
'Moral victories' might spare you from losing again
Fair cake cutting gets its own algorithm
Effort to model Facebook yields key to famous math problem (and a prize)
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,363
[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