A graphical trap for unwary users of Excel 2010

Delwyn G Cooke, Leonard F Blackwell, Simon Brown

Abstract


Excel’s “line chart” has several peculiarities that can yield misleading representations of data.  However, in Excel 2010 it is possible to combine “line charts” with “scatter charts” which exacerbates the capacity to be misleading.

Full Text:

PDF

References


D. Pianjud, O. Natakuatoong, and J. Vicheanpanya, “The development of a knowledge management system to promote the sufficiency economy philosophy for the basic education teacher,” International Journal of e-Education, e-Business, e-Management and e-Learning, vol. 3, pp. 219-223, 2013. http://dx.doi.org/10.7763/IJEEEE.2013.V3.227

T. Worstall, “Microsoft’s Excel might be the most dangerous software on the planet,” in Forbes, 2013. http://onforb.es/12LAYaI

M. P. Campbell, “Spreadsheet issues: pitfalls, best practices, and practical tips,” Actuarial Practice Forum, vol. 2010, pp. 1-39, 2010. https://www.soa.org/library/journals/actuarial-practice-forum/2010/february/apf-2010-02-toc.aspx#

EuSpRiG, “Spreadsheet mistakes − news stories collated by the European Spreadsheet Risks Interest Group,” vol. 2015: European Spreadsheet Risks Interest Group, 2013. http://www.eusprig.org/horror-stories.htm

G. Sawitzki, “Report on the numerical reliability of data analysis systems,” Computational Statistics and Data Analysis, vol. 18, pp. 289-301, 1994. http://dx.doi.org/10.1016/0167-9473(94)90177-5

J. C. Nash and T. K. Quon, “Issues in teaching statistical thinking with spreadsheets,” Journal of Statistics Education, vol. 4, pp. np, 1996. http://www.amstat.org/publications/jse/v4n1/nash.html

J. C. Nash, “Spreadsheets in statistical practice − another look,” American Statistician, vol. 60, pp. 287-289, 2006. http://dx.doi.org/10.1198/000313006X126585

R. L. Berger, “Nonstandard operator precedence in Excel,” Computational Statistics and Data Analysis, vol. 51, pp. 2788-2791, 2007. http://dx.doi.org/10.1016/j.csda.2006.09.040

B. D. McCullough and B. Wilson, “On the accuracy of statistical procedures in Microsoft Excel 2000 and Excel XP,” Computational Statistics and Data Analysis, vol. 40, pp. 713-721, 2002. http://dx.doi.org/10.1016/S0167-9473(02)00095-6

B. D. McCullough and D. A. Heiser, “On the accuracy of statistical procedures in Microsoft Excel 2007,” Computational Statistics and Data Analysis, vol. 52, pp. 4570-4578, 2008. http://dx.doi.org/10.1016/j.csda.2008.03.004

A. T. Yalta, “The accuracy of statistical distributions in Microsoft® Excel 2007,” Computational Statistics and Data Analysis, vol. 52, pp. 4579-4586, 2008. http://dx.doi.org/10.1016/j.csda.2008.03.005

B. D. Hargreaves and T. P. McWilliams, “Polynomial trendline function flaws in Microsoft Excel,” Computational Statistics and Data Analysis, vol. 54, pp. 1190-1196, 2010. http://dx.doi.org/10.1016/j.csda.2009.10.020

L. Knüsel, “On the accuracy of statistical distributions in Microsoft Excel 2003,” Computational Statistics and Data Analysis, vol. 48, pp. 445-449, 2005. http://dx.doi.org/10.1016/j.csda.2004.02.008

M. G. Almiron, B. Lopes, A. L. C. Oliviera, A. C. Medeiros, and A. C. Frery, “On the numerical accuracy of spreadsheets,” Journal of Statistical Software, vol. 34, pp. 1-29, 2010. http://dx.doi.org/10.18637/jss.v034.i04

G. Mélard, “On the accuracy of statistical procedures in Microsoft Excel 2010,” Computational Statistics, vol. 29, pp. 1095-1128, 2014. http://dx.doi.org/10.1007/s00180-014-0482-5

Y.-S. Su, “It’s easy to produce chartjunk using Microsoft® Excel 2007 but hard to make good graphs,” Computational Statistics and Data Analysis, vol. 52, pp. 4594-4601, 2008. http://dx.doi.org/10.1016/j.csda.2008.03.007

J. Baker, “The charts that Excel cannot do,” Spreadsheets in Education, vol. 1, pp. 6, 2004. http://epublications.bond.edu.au/ejsie/vol1/iss3/6/

J. Benacka, “Introduction to 3D graphics through Excel,” Informatics in Education, vol. 12, pp. 221-230, 2013. http://www.mii.lt/informatics_in_education/htm/INFE226.htm

C. Duller, “Teaching statistics with Excel. A big challenge for students and lecturers,” Austrian Journal of Statistics, vol. 37, pp. 195-206, 2008. http://www.stat.tugraz.at/AJS/ausg082/082Duller.pdf

B. D. McCullough, “Does Microsoft fix errors in Excel?,” presented at 2001 Joint Statistical Meetings [CD-ROM], Alexandria, 2002. http://www.amstat.org/sections/SRMS/Proceedings/y2001/Proceed/00177.pdf

B. D. McCullough, “The unreliability of Excel’s statistical procedures,” Foresight, vol. 2006, pp. 44-45, 2006. http://www.forecastingprinciples.com/files/McCullough.pdf

B. D. McCullough and A. T. Yalta, “Spreadsheets in the cloud − not ready yet,” Journal of Statistical Software, vol. 52, pp. 1-14, 2013. http:// www.jstatsoft.org/article/view/v052i07/v52i07.pdf

J. A. Schwabish, “An economist’s guide to visualizing data,” Journal of Economic Perspectives, vol. 28, pp. 209-234, 2014. http://dx.doi.org/10.1257/jep.28.1.209

C. Chambers and C. Scaffidi, “Struggling to Excel: a field study of challenges faced by spreadsheet users,” in Proceedings. 2010 IEEE symposium on visual languages and human-centric computing (VL/HCC 2010), C. Hundhausen, E. Pietriga, P. Diaz, and M. B. Rosson, Eds. Los Alamitos: Institute of Electrical and Electronics Engineers, Inc., 2010, pp. 187-194. http://dx.doi.orh/10.1109/VLHCC.2010.33

S. S. Patel, M. Z. Molnar, J. A. Tayek, J. H. Ix, N. Noori, D. Benner, S. Heymsfield, J. D. Kopple, C. S. Kovesdy, and K. Kalantar-Zadeh, “Serum creatinine as a marker of muscle mass in chronic kidney disease: results of a cross-sectional study and review of literature,” Journal of Cachexia, Sarcopenia and Muscle, vol. 4, pp. 19-29, 2013. http://dx.doi.org/10.1007/s13539-012-0079-1

U. Holzinger, R. Brunner, H. Losert, V. Fuhrmann, C. Modl, F. Sterz, and B. Schneeweiβ, “Resting energy expenditure and substrate oxidation rates correlate to temperature and outcome after cardiac arrest − a prospective observational cohort study,” Critical Care, vol. 19, pp. 128, 2015. http://dx.doi.org/10.1186/s13054-015-0856-2

Ministry of Education, Mathematics standards for years 1-8. Wellington: Learning Media Limited, 2009. http://nzcurriculum.tki.org.nz/content/download/3166/47235/file/Maths_Standards_amended_vs3.pdf

L. F. Blackwell, P. Vigil, M. E. Alliende, S. Brown, M. Fortin, and D. G. Cooke, “Monitoring of ovarian activity by measurement of urinary excretion rates using the Ovarian Monitor, Part IV: the relationship of the pregnanediol glucuronide threshold, basal body temperature and cervical mucus as markers for the beginning of the post-ovulatory infertile period” Human Reproduction, vol. 31, pp. 445-453, 2016. http://dx.doi.org/10.1093/humrep/dev303


Refbacks

  • There are currently no refbacks.


IT-EDU-2017   RTUWO 2017

ISSN: 2307-8162