Road Runner Posted June 19, 2021 Share #1 Posted June 19, 2021 Had I tried to calculate the winning percentage of 9 out of 10, I would have come up with 90%. Computers know better. It is a good thing that computers will soon be driving all of our cars. 1 2 Link to comment Share on other sites More sharing options...
JerrySTL ★ Posted June 19, 2021 Share #2 Posted June 19, 2021 Rounding error. I'm still waiting for the promised flying 🚗. 1 1 Link to comment Share on other sites More sharing options...
MickinMD ★ Posted June 19, 2021 Share #3 Posted June 19, 2021 I keep a live record of my stocks on Google Sheets and also back it up on my computer using the free, almost-identical-to-Excel WPS Office Spreadsheets. The information is identical for the stocks, but the rounding differences end up with sums and other calculations being very slightly different. The six numbers in the Sheets example below were copied to the WPS cells and still don't completely agree due to each one's rounding rules! Google Sheets as of right now: WPS Spreadsheets as of right now: 1 Link to comment Share on other sites More sharing options...
MickinMD ★ Posted June 19, 2021 Share #4 Posted June 19, 2021 Getting 89% instead of 90% is really surprising because even if it wasn't exact, scientists and mathematicians are taught to ROUND TO EVEN - and 9 is not even! Did you know that scientists and mathematicians do NOT round .5 up to 1 as we were taught in grade school? This applies to MEASURED numbers which we do not know exactly to an infinite amount of places. If you add: 0.5 + 1.5 + 2.5 + 3.5 that equals 8.0. But if you round the grade school way first it's: 1 + 2 + 3 + 4 = 10 So scientists and mathematicians ROUND TO EVEN to account for the fact that .5 is as close to the next whole number down as the next whole number up. If you round the scientific way first it's: 0 + 2 + 2 + 4 = 8. The same is true for rounding anything ending in "5" to the next greater place. 3 Link to comment Share on other sites More sharing options...
maddmaxx ★ Posted June 19, 2021 Share #5 Posted June 19, 2021 This is a low bar. 1 Link to comment Share on other sites More sharing options...
Ralphie ★ Posted June 20, 2021 Share #6 Posted June 20, 2021 21 hours ago, Road Runner said: It is a good thing that computers will soon be driving all of our cars. All our base are now belong to them. 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now