Browse > Article
http://dx.doi.org/10.5626/KTCP.2016.22.11.559

Flaws in Excel when performing Base Conversion of Decimals  

Kim, Tae Soo (Seoul National Univ. of Science and Technology)
Publication Information
KIISE Transactions on Computing Practices / v.22, no.11, 2016 , pp. 559-566 More about this Journal
Abstract
Excel is a commercially available computer program that is used worldwide. Excel is widely utilized; it is helpful in household ledgers, corporate tax calculations, management of academic grades or reports, etc. However from the beginning, inaccuracies and errors in calculations have constantly been identified, so the program is updated regularly. Decimal-to-binary conversion is a simple and repetitive task. So, use of a computer program to do this calculation is suitable. Errors in decimal-to-binary conversion are surprising and are not easily understood. Therefore, it is important to identify the flaws in Excel, which unfortunately still exist today. It is necessary to determine the cause of this type of error, and I hope for a fix to be implemented quickly.
Keywords
Excel; decimal-to-binary conversion; flaws in calculation; fill handle;
Citations & Related Records
연도 인용수 순위
  • Reference
1 Greg Harvey. Excel 2007 For Dummies. Wiley. New York, 2006.
2 Doopedia. (2013. Feb 1). Excel [Online]. Available: http://www.doopedia.co.kr (downloaded 2016. May. 4)
3 McCullough, Bruce D. and Wilson, Berry, "On the accuracy of statistical procedures in Microsoft Excel 2000 and Excel XP," Computational Statistics & Data Analysis, Vol. 40, No. 4, pp. 713-721. 2002.   DOI
4 McCullough. Bruce. D. and Heiser, David A, "On the accuracy of statistical procedures in Microsoft Excel 2007," Computational Statistics & Data Analysis, Vol. 52, No. 10, pp. 4570-4578. 2008.   DOI
5 Yalta, A. Talha, "The accuracy of statistical distributions in Microsoft Excel 2007," Computational Statistics & Data Analysis, Vol. 52, No. 10, pp. 4579-4586, 2008.   DOI
6 Heiser. David. (2008). Microsoft Excel 2000, 2003 and 2007 faults, problems, work arounds and fixes" [Online] Available: http://www.daheiser.info (downloaded 2016. May. 4)
7 Hans Pottel. Statistical flaws in Excel, Innogenetics NV, Technologiepark 6, 9052 Zwijnaarde, Belgium, 2003.
8 Lee. G. H., "On the accuracy of MS Excel for Statistical Purpose," Journal of Business & Economics, Vol. 21, No. 1, pp. 163-173, 2003.
9 Joel. S. (2007. Sep 26). Explaining the Excel Bug, [Online]. Available: http://www.joelonsoftware.com (downloaded 2016. May. 7)
10 Microsoft. (2015. Aug 16), "What's new in Office 2016," [Online]. Available: http://support.office.com (downloaded 2016. Feb. 7)
11 Diego Oppenheimer. (2009. Oct). Function Improvements in Microsoft Office Excel 2010. [Online]. Available: http://blogs.msdn.com (downloaded 2016. Feb. 7)