EPT
[H]excel
| Blogs > Steelflight-Rx |
|
Steelflight-Rx
United States1389 Posts
| ||
|
EtherealDeath
United States8366 Posts
Google is the closest thing to God man has ever created. Remember this young padawan, when your prayers are not answered in time. | ||
micronesia
United States24514 Posts
edit: yeah that tutorial just says to manually type in the quadratic formula by using the cells of a b and c. edit2: if you can come up with a reason why that method isn't good, please explain why | ||
|
Steelflight-Rx
United States1389 Posts
So in response to edit2: The prescribed method is not accurate enough to give me a reasonable answer when compared with the answer in the book. I guess that really doesn't answer the question why, which is probably something to do with the way excel does its math, which is why I was wondering if there was a function that did the calculations by some predetermined algorithm with a higher level of accuracy. | ||
|
Steelflight-Rx
United States1389 Posts
 just the way you posed the question made me feel like answering it in essay form lol | ||
GHOSTCLAW
United States17042 Posts
| ||
|
Raithed
China7078 Posts
| ||
|
Steelflight-Rx
United States1389 Posts
On October 16 2008 08:56 Raithed wrote: just plug it in. .. thats what i did but im losing precision somewhere, my answer is off by +0.0006, which is too much for the calculations i'm doing. lol srsly man theres only like 4 posts in this blog, you couldn't read them? | ||
|
Nitrogen
United States5345 Posts
not sure if this is what you mean, but you can just add on a bunch of decimal places for more precision edit: i think you have to select all cells before you do this if you want them all to have a bunch of decimal places. | ||
|
JeeJee
Canada5652 Posts
i highly doubt it's a rounding error but you can look at that as well | ||
MasterOfChaos
Germany2896 Posts
So calculate: ![[image loading]](http://upload.wikimedia.org/math/b/b/9/bb937d64eccf2c9452d2c815f33e38a6.png) ![[image loading]](http://upload.wikimedia.org/math/d/d/3/dd31f71737ae01255a9414dc08e41639.png) (for x^2+px+q=0 so p=b/a q=c/a) which is a wellknown trick to reduce the rounding errors. But no idea if that works with excel, I don't use it very often. | ||
| ||
