473,320 Members | 1,946 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

excel equation scientific notation


(hover cursor over box to see image of formula that cannot be copied correctly from excel (rabble rabble rabble))

So I made a 6th degree equation from a trendline in excel...

If anyone can tell me what this is supposed to mean they can have a cookie* >.>. I know scientific notation, but it seems to me that regular SN is not good enough for microsoft, I mean, why would they put another value after the E? thats like saying -6x10^1 - 06x10^6 which makes no sense since the powers are sorted and this is a 6th degree polynomial... err.... have they invented their own convention?

also.. anyone who can tell me if it is possible to calculate a first order derivative in excel can have another cookie*. I suspect not since no Google searches I did told me how and its not in the excel functions... but I may have missed it.

Thanks!

*actual cookie existence not guaranteed
Feb 9 '09 #1
3 7188
JosAH
11,448 Expert 8TB
That notation isn't Microsoft's invention: the capital 'E' reads as 'times 10 raised to the power', so -6E-6 reads as 'minus six, timers 10 raised to the power minus six'. So in numbers: -6/1,000,000 (minus six divided by a million).

kind regards,

Jos
Feb 9 '09 #2
And that I understand since math in high school. however

regular SN form is:

1.8*10^4 or 1.8E4... etc

But if you look at it (more closely at the first term in the polynomial) you will see that this show as
-6E-06E^6 .
I say, this makes very little sense.
it would work out to be -6*10^1 - 06*10^6
or
-6*10*-06*10^6 which also means nothing

which makes absolutely no sense at all as there is already a constant term and as I mentioned in my original post, not standard in any way that I can see.

Which brings us back to my original question: What does MicroSoft intend this to mean?
Feb 10 '09 #3
JosAH
11,448 Expert 8TB
@themadjester
That is not what I see from that picture you posted; I see -6E-06x^6 which makes sense ... or I completely misunderstand your question.

kind regards,

Jos
Feb 10 '09 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: masoud bayan | last post by:
I have some values in type of double such 0.00009 , 0.0000007, when I want to show them in a text box and convert them to string they are changed to scientific notation while I want to show them as...
1
by: Nick | last post by:
Well, the project I am working on has now come to a screeching halt! I have been developing a program that heavily utilizes ADO.NET record sets. To generate reports, I convert the recordset to XML,...
0
by: Greg | last post by:
I am working on an application that requires working with numbers in scientific notation. I am using SqlServer as the database and I have created strongly typed data adapters and datasets. The...
7
by: Dustan | last post by:
How can I get a number into scientific notation? I have a preference for the format '1 E 50' (as an example), but if it's well known, it works.
9
by: Joe Attardi | last post by:
Hi all, Math is not my strongest area so forgive me if I use some of the wrong terminology. It seems that scientific notation is immune to rounding errors. For example: (4.98 * 100) + 5.51 ...
2
by: rSmoke | last post by:
I have a DataSet that contains a table with about 6 columns of high accuracy decimal values. When I try to write out the DataSet using the WriteXML() function the XML is written fine, but the...
2
by: Greg | last post by:
I am working on an application that requires working with numbers in scientific notation. I am using SqlServer as the database and I have created strongly typed data adapters and datasets. The...
0
by: prashantdixit | last post by:
Hi, I am trying to generate Linear Trendline Equation for a graph using VBA in Excel 2007. I am able to do it. However It always generate trendline equation in "General" Format. And i want to...
0
by: Manoj Amin | last post by:
Hi, I have follwing C# code which opens that tab delimited .txt file and does the saveas to Excel file. Problem what I am running into is some of the text field has value such as...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.