
#1
Jan1311, 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 = 9E19x^{6} + 2E14x^{5}  2E10x^{4} + 1E06x^{3}  0.0027x^{2} + 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)..... 



#2
Jan1311, 02:25 PM

P: 474

It is 10^x, in this case it means that the coeficients in x^3 and higher are zero.




#3
Jan1311, 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




#4
Jan1311, 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
= 9E19*power(A1,6) + 2E14*power(A1,5)  2E10*power(A1,4) + 1E06*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 



#5
Jan1311, 02:43 PM

Math
Emeritus
Sci Advisor
Thanks
PF Gold
P: 38,900

[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 = 9E19x^{6} + 2E14x^{5}  2E10x^{4} + 1E06x^{3}  0.0027x^{2} + 3.5222x  1656.5 [itex]9E19[/itex] is "calculator speak" for [itex]9 \times 10^{19}= 0.0000000000000000009[/itex] (18 "0"s and "9" after the decimal point.) Similarly [tex]2E14= 2\times 10^{14}= .00000000000002[/tex] [tex]2 E10= 2\times 10^{10}= .0000000002[/tex] [tex]1E06= 10^{6}= 0.000001[/tex] 


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 