Unfortunatly... it seems Excel is giving me the wrong equation. I've entered it into my TI-Calculator, and I get the same results as I do with putting the equation it gives me in a VBA script and calculating... so I know that I have the equation right cause they check out with each other, however it doesn't check out with the graph. Does anybody know what can cause this and how to fix this? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel giving wrong equation
- Thread starter mike101
- Start date
Mike,
Can you post the equation and the graph or provide a link where someone might go to view the graph and equation and do their own tests?
Knock and the door will be opened to you; Seek and you will find; Ask and it will be given to you! Our God is an awesome God!![[peace]](/data/assets/smilies/peace.gif "[peace] [peace]")
Can you post the equation and the graph or provide a link where someone might go to view the graph and equation and do their own tests?
Knock and the door will be opened to you; Seek and you will find; Ask and it will be given to you! Our God is an awesome God!
ooooooooommmmmmmm....oooooommmmmmmmmmm - nope - telepathy powers still not working - you're gonna have to post the formula and give us the data that it is reading
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
- Thread starter
- #4
y = 2E-21x6 - 4E-18x5 - 1E-13x4 + 4E-10x3 + 2E-06x2 - 0.0094x + 10.275
R2 = 0.8764
<-- what I'm working with.
R2 = 0.8764
<-- what I'm working with.
I'm willing to bet this is a sig figs issue - excel can only handle 15 significant figures - after that, the number just gets truncated
from excel help:
Number precision 15 digits
Largest number allowed to be typed into a cell 9.99999999999999E307
Largest allowed positive number 1.79769313486231E308
Smallest allowed negative number 2.2250738585072E-308
Smallest allowed positive number 2.229E-308
Largest allowed negative number -1E-307
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
from excel help:
Number precision 15 digits
Largest number allowed to be typed into a cell 9.99999999999999E307
Largest allowed positive number 1.79769313486231E308
Smallest allowed negative number 2.2250738585072E-308
Smallest allowed positive number 2.229E-308
Largest allowed negative number -1E-307
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
It is not excel but the way it displays the trendline's equation. Note that you have only one significant digit.
Right-click the label with formula, go to 'numbers' tab and choose scientific format with for instance two decimal digits. You will get more precise formula for the trendline.
combo
Right-click the label with formula, go to 'numbers' tab and choose scientific format with for instance two decimal digits. You will get more precise formula for the trendline.
combo
- Status