![0 stars based on 0 ratings](/images/blogs/graystarSmall.gif)
![0 stars based on 0 ratings](/images/blogs/graystarSmall.gif)
![0 stars based on 0 ratings](/images/blogs/graystarSmall.gif)
![0 stars based on 0 ratings](/images/blogs/graystarSmall.gif)
![0 stars based on 0 ratings](/images/blogs/graystarSmall.gif)
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 States24354 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
China7077 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: ![]() ![]() (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. | ||
| ||
![]() StarCraft 2 StarCraft: Brood War Britney Dota 2![]() ![]() Sea ![]() Rain ![]() Calm ![]() Bisu ![]() Horang2 ![]() Shuttle ![]() Jaedong ![]() Larva ![]() Soulkey ![]() [ Show more ] Counter-Strike Other Games summit1g14080 B2W.Neo1192 ArmadaUGS635 crisheroes582 DeMusliM428 Happy287 NuckleDu222 XaKoH ![]() NeuroSwarm67 Organizations Dota 2 StarCraft 2 StarCraft: Brood War StarCraft 2 StarCraft: Brood War
StarCraft 2 • practicex StarCraft: Brood War![]() • LUISG ![]() • AfreecaTV YouTube • aXEnki ![]() • intothetv ![]() • Gussbus • Kozan • IndyKCrew ![]() • LaughNgamez Trovo • Laughngamez YouTube • Migwel ![]() • Poblha Dota 2 |
Replay Cast
HomeStory Cup
Korean StarCraft League
Replay Cast
HomeStory Cup
Sparkling Tuna Cup
HomeStory Cup
ESL Open Cup
ESL Open Cup
ESL Open Cup
|
|