{"id":542,"date":"2012-05-18T12:26:14","date_gmt":"2012-05-18T12:26:14","guid":{"rendered":"http:\/\/blogs.cetis.ac.uk\/adam\/?p=542"},"modified":"2012-05-18T12:26:14","modified_gmt":"2012-05-18T12:26:14","slug":"exploratory-data-analysis","status":"publish","type":"post","link":"https:\/\/www.hilltop-cottage.info\/blogs\/arc12\/exploratory-data-analysis\/","title":{"rendered":"Exploratory Data Analysis"},"content":{"rendered":"

It doesn’t take much to trigger me into a rant about the weaknesses of reports on data and “dashboards<\/a>” purporting to be “analytics” or “business intelligence”. Lots of pie charts and line graphs with added bling are as the proverbial red rag to a bull.<\/p>\n

Until recently my response was to demand more rigorous statistics: hypothesis testing, confidence limits, tests for reverse causality (but recognising that causality is a slippery concept in complex systems). Having recently spent some time thinking about using data analysis to gain actionable insights, particularly in the setting of an educational institution, it has become clear to me that this response is too shallow. It embeds an assumption of a linear process: ask a question, operationalise it in terms of data and statistics and crunch some numbers. As my previous post<\/a> indicates, I don’t suppose all questions are approachable. Actually, thinking back to the ways I’ve\u00a0 done a little text and data mining in the past, it wasn’t quite like this either.<\/p>\n

The label “exploratory data analysis<\/a>” captures the antithesis to the linear process. It was popularised in statistical circles by John W Tukey<\/a> in the early 1960’s and he used it as a title for a highly influential book. Tukey was trying to challenge a statistical community that was very focused on hypothesis testing and other forms of “confirmatory data analysis”. He argued that statisticians should do both, approaching data with flexibility and an open frame of mind and he saw having a well-stocked toolkit of graphical methods as being essential for exploration (Tukey was responsible for inventing a number of plot types that are now widely used).<\/p>\n

Tukey read a paper entitled “The Technical Tools of Statistics<\/a>” at the 125th Anniversary Meeting of the American Statistical Association in 1964 which anticipated the development of computational tools (e.g. R<\/a> and RapidMiner<\/a>), is well worth a read and has timeless gems like:<\/p>\n

“Some of my friends felt that I should be very explicit in warning you of how much time and money can be wasted on computing, how much clarity and insight can be lost in great stacks of computer output. In fact, I ask you to remember only two points:
\n<\/em><\/p>\n

    \n
  1. The tool that is so dull that you cannot cut yourself on it is not likely to be sharp enough to be either useful or helpful.<\/em><\/li>\n
  2. Most uses of the classical tools of statistics have been, are, and will be, made by those who know not what they do.”<\/em><\/li>\n<\/ol>\n

    There is a correspondence between the open-minded and flexible approach to exploratory data analysis that Tukey advocated and the Grounded Theory<\/a> (GT) Method of the social sciences. As a non-social scientist, GT seems to be a trying a bit too hard to be a Methodology (academic disputes and all) but the premise of using both inductive and deductive reasoning and going in to a research question free of the prejudice of a hypothesis that you intend to test (prove? how often is data analysed to find a justification for a prejudice?) is appealing.<\/p>\n

    Although GT is really focussed on qualitative research, some of the practical methods that the GT originators and practitioners have proposed might be applicable to data captured in IT systems and for practitioners of analytics. I quite like the dictum of “no talk” (see the wikipedia entry<\/a> for an explanation).<\/p>\n

    My take home, then, is something like: if we are serious about analytics we need to be thinking about exploratory data analysis and<\/span> confirmatory data analysis and the label “analytics” is certainly inappropriate if neither is occurring. For exploratory data analysis we need: visualisation tools, an open mind and an inquisitive nature.<\/p>\n","protected":false},"excerpt":{"rendered":"

    It doesn’t take much to trigger me into a rant about the weaknesses of reports on data and “dashboards” purporting to be “analytics” or “business intelligence”. Lots of pie charts and line graphs with added bling are as the proverbial red rag to a bull. Until recently my response was to demand more rigorous statistics: … Continue reading Exploratory Data Analysis<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-542","post","type-post","status-publish","format-standard","hentry","category-analytics"],"_links":{"self":[{"href":"https:\/\/www.hilltop-cottage.info\/blogs\/arc12\/wp-json\/wp\/v2\/posts\/542","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hilltop-cottage.info\/blogs\/arc12\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hilltop-cottage.info\/blogs\/arc12\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hilltop-cottage.info\/blogs\/arc12\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hilltop-cottage.info\/blogs\/arc12\/wp-json\/wp\/v2\/comments?post=542"}],"version-history":[{"count":0,"href":"https:\/\/www.hilltop-cottage.info\/blogs\/arc12\/wp-json\/wp\/v2\/posts\/542\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hilltop-cottage.info\/blogs\/arc12\/wp-json\/wp\/v2\/media?parent=542"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hilltop-cottage.info\/blogs\/arc12\/wp-json\/wp\/v2\/categories?post=542"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hilltop-cottage.info\/blogs\/arc12\/wp-json\/wp\/v2\/tags?post=542"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}