KIISE Transactions on Computing Practices (정보과학회 컴퓨팅의 실제 논문지)

Korean Institute of Information Scientists and Engineers (한국정보과학회)
권호 표지
DOI QR코드

DOI QR Code

Flaws in Excel when performing Base Conversion of Decimals

Excel을 활용한 소수의 진법변환 계산에서의 오류

  • 김태수 (서울과학기술대학교 기초교육학부)
  • Received : 2016.05.13
  • Accepted : 2016.07.18
  • Published : 2016.11.15
⟨ Previous Next ⟩

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.

전 세계적으로 널리 상용화된 Excel은 수식작성과 계산이 편리해 기업의 세무계산, 보고서나 학교의 성적관리 및 가계부 등에 광범위하게 활용되고 있는 전산프로그램이다. 그러나 초기부터 계산의 부정확성 및 오류들이 꾸준히 제기되어 왔고, 지속적으로 수정되어 발전하여왔다. 소수의 진법변환 과정은 경우에 따라서는 단순한 계산을 반복적으로 여러 번 해야만 하기에, 이러한 단순작업은 컴퓨터에 의한 계산도구들의 도움을 받기에 적절하다. 이번에 발견된 소수의 진법변환과 같은 단순계산과정에서 Excel의 오류는 쉽게 이해되지 않는다. 유사한 오류가 추가적으로 발견될 가능성은 높다. 이번에 발견된 오류의 유형에 대하여 원인을 파악하고, 빠른 수정을 희망한다.

Keywords

Acknowledgement

Supported by : 서울과학기술대학교

References

  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. https://doi.org/10.1016/S0167-9473(02)00095-6
  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. https://doi.org/10.1016/j.csda.2008.03.004
  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. https://doi.org/10.1016/j.csda.2008.03.005
  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)