Statistical software can be very helpful but it does not automatically guarantee correct analyses:
A team of Australian researchers analyzed nearly 3,600 genetics papers published in a number of leading scientific journals — like Nature, Science and PLoS One. As is common practice in the field, these papers all came with supplementary files containing lists of genes used in the research.
The Australian researchers found that roughly 1 in 5 of these papers included errors in their gene lists that were due to Excel automatically converting gene names to things like calendar dates or random numbers…
Genetics isn’t the only field where a life’s work can potentially be undermined by a spreadsheet error. Harvard economists Carmen Reinhart and Kenneth Rogoff famously made an Excel goof — omitting a few rows of data from a calculation — that caused them to drastically overstate the negative GDP impact of high debt burdens. Researchers in other fields occasionally have to issue retractions after finding Excel errors as well…
For the time being, the only fix for the issue is for researchers and journal editors to remain vigilant when working with their data files. Even better, they could abandon Excel completely in favor of programs and languages that were built for statistical research, like R and Python.
Excel has particular autoformatting issues but all statistical programs have unique ways of handling data. Spreadsheets of data – often formatted with cases in the rows and variables in the columns – don’t automatically read in correctly.
Additionally, user error can lead to issues with any sort of statistical software. Different programs may have different quirks but various researchers can do all sort of weird things from recoding incorrectly to misreading missing data to misinterpreting results. Data doesn’t analyze itself and statistical software is just a tool that needs to be used correctly.
A number of researchers have in recent years called for open data once a paper is published and this could help those in an academic field spot mistakes. Of course, the best solution is to double-check (at least) data before review and publication. Yet, when you are buried in a quantitative project and there are dozens of steps of data work and analysis, it can be hard to (1) keep track of everything and (2) closely watch for errors. Perhaps we need independent data review even before publication.
Scientists regularly use p-values to evaluate their findings but apparently have difficulty explain exactly what they mean:
To be clear, everyone I spoke with at METRICS could tell me the technical definition of a p-value — the probability of getting results at least as extreme as the ones you observed, given that the null hypothesis is correct — but almost no one could translate that into something easy to understand.
It’s not their fault, said Steven Goodman, co-director of METRICS. Even after spending his “entire career” thinking about p-values, he said he could tell me the definition, “but I cannot tell you what it means, and almost nobody can.” Scientists regularly get it wrong, and so do most textbooks, he said. When Goodman speaks to large audiences of scientists, he often presents correct and incorrect definitions of the p-value, and they “very confidently” raise their hand for the wrong answer. “Almost all of them think it gives some direct information about how likely they are to be wrong, and that’s definitely not what a p-value does,” Goodman said.
We want to know if results are right, but a p-value doesn’t measure that. It can’t tell you the magnitude of an effect, the strength of the evidence or the probability that the finding was the result of chance.
So what information can you glean from a p-value? The most straightforward explanation I found came from Stuart Buck, vice president of research integrity at the Laura and John Arnold Foundation. Imagine, he said, that you have a coin that you suspect is weighted toward heads. (Your null hypothesis is then that the coin is fair.) You flip it 100 times and get more heads than tails. The p-value won’t tell you whether the coin is fair, but it will tell you the probability that you’d get at least as many heads as you did if the coin was fair. That’s it — nothing more. And that’s about as simple as I can make it, which means I’ve probably oversimplified it and will soon receive exasperated messages from statisticians telling me so.
Complicated but necessary? This can lead to fun situations when teaching statistics: students need to know enough to do the statistical work and evaluate findings (we at least need to know what to do with a calculated p-value, even if we don’t quite understand what it means) but explaining the complexity of some of these techniques wouldn’t necessarily help the learning process. In fact, the more you learn about statistics, you tend to find that the various methods and techniques have limitations even as they can help us better understand phenomena.
How will refugees be dispersed among European countries? This formula:
On Wednesday, shortly after European Commission President Jean-Claude Juncker announced a new plan to distribute 120,000 asylum-seekers currently in Greece, Hungary, and Italy among the EU’s 28 member states, Duncan Robinson of the Financial Times tweeted a series of grainy equations from the annex of a proposed European regulation, which establishes a mechanism for relocating asylum-seekers during emergency situations beyond today’s acute crisis. Robinson’s message: “So, how do they decide how many refugees each country should receive? ‘Well, it’s very simple…’”
In an FAQ posted on Wednesday, the European Commission expanded on the thinking behind the elaborate math. Under the proposed plan, if the Commission determines at some point in the future that there is a refugee crisis in a given country (as there is today in Greece, Hungary, and Italy, the countries migrants reach first upon arriving in Europe), it will set a number for how many refugees in that country should be relocated throughout the EU. That number will be “not higher than 40% of the number of [asylum] applications made [in that country] in the past six months.”…
What’s most striking to me is the contrast between the sigmas and subscripts in the refugee formula—the inhumanity of technocratic compromise by mathematical equation—and the raw, tragic, heroic humanity on display in recent coverage of the refugees from Syria, Afghanistan, Eritrea, and elsewhere who are pouring into Europe.
The writer hints at the end here that the bureaucratic formula and stories of human lives at stake are incompatible. How could we translate people who need help into cold, impersonal numbers? This is a common claim: statistics take away human stories and dignity. They are unfeeling. They can’t sum the experiences of individuals. One online quote sums this up: “Statistics are human beings with the tears wiped off.”
Yet, we need both the stories and the numbers to truly address the situation. Individual stories are important and interesting. Tragic cases tend to draw people’s attention, particularly if presented in attractive ways. But, it is difficult to convey all the stories of the refugees and migrants. Where would they be told and who would sit through them all? The statistics and formulas help give us the big picture. Just how many refugees are there? (Imagine a situation where there are only 10 refugees but with very compelling stories. Would this compel nations to act.) How can they be slotted into existing countries and systems?
On top of that, you can’t really have the nations of today without bureaucracies. We might not like that they are slow moving or inefficient at times or can be overwhelming. How can you run a major social system without a bureaucratic structure? Would we like to go to a hospital that was not a bureaucracy? How do you keep millions of citizens in a country moving in a similar direction? Decentralization or non-hierarchical systems can only go so far in addressing major tasks.
With that said, the formula looks complicated but the explanation in the text is fairly easy to understand: there are a set of weighted factors that dictate how many refugees will be assigned to each country.
I’ve seen this argument several places, including this AP story: collecting national data about fatalities due to police would be helpful.
To many Americans, it feels like a national tidal wave. And yet, no firm statistics can say whether this spate of officer-involved deaths is a growing trend or simply a series of coincidences generating a deafening buzz in news reports and social media.
“We have a huge scandal in that we don’t have an accurate count of the number of people who die in police custody,” says Samuel Walker, emeritus professor of criminal justice at the University of Nebraska at Omaha and a leading scholar on policing and civil liberties. “That’s outrageous.”…
The FBI’s Uniform Crime Reports, for instance, track justifiable police homicides – there were 1,688 between 2010 and 2013 – but the statistics rely on voluntary reporting by local law enforcement agencies and are incomplete. Circumstances of the deaths, and other information such as age and race, also aren’t required.
The Wall Street Journal, detailing its own examination of officer-involved deaths at 105 of the nation’s 110 largest police departments, reported last week that federal data failed to include or mislabeled hundreds of fatal police encounters…
Chettiar is hopeful that recent events will create the “political and public will” to begin gathering and analyzing the facts.
A few quick thoughts:
1. Just because this data hasn’t been collected doesn’t necessarily mean this was intentional. Government agencies collect lots of data but it takes some deliberate action and foresight regarding what should and shouldn’t be reported. Given that there are a least a few hundred such deaths each year, you would think someone would have flagged such information as interesting but apparently not. Now would be a good time to start reporting and collecting such data.
2. Statistics would be helpful in providing a broader perspective on the issue but, as the article notes, statistics have certain kinds of persuasive power as do individual events or broad narratives not necessarily backed by statistics. In our individualistic culture, specific stories can often go a long ways. At the same time, social problems are often defined by their scope which involves statistical measures of how many people are affected.
Measuring many things rests on the ability to observe or collect the data. But, a number of organizations have found that they can’t keep up with the actions of ISIS:
He and his colleagues have (alone among wire services) built up a detailed spreadsheet total of civilian and combatant casualties, but faced with the near impossibility of verifying multiple daily reports of massacres in provinces rendered inaccessible since the early weeks of ISIS’s June offensive, they now largely restrict its use for internal purposes.Officials in UN’s Iraq mission (UNAMI) are similarly downbeat about the accuracy of their records.
“Since the armed conflict escalated, I would say that our figures are significantly under reported,” said Francesco Motta, Director of UNAMI’s human rights office.
“We are getting hundreds of reports in addition to those we verify that we are just simply not able to verify owing to our limited access to areas where incidents are taking place,” he added…
It’s the sheer magnitude of the slaughter that’s overstretching these groups’ resources, but ISIS’s murderous approach to the media has compounded the problem. On top of the much publicized recent beheadings of two American journalists, ISIS also has killed dozens of Syrian and Iraqi reporters. Body counts rely heavily on local news articles for coverage of incidents in towns and rural pockets far from Baghdad, and the jihadists’ seizure of up to a third of Iraq has complicated attempts to report within their areas of control.
It may be a macabre task but an important one. As the article goes on to note, this matters for political ends (different sides will spin the available or estimated numbers in different ways) and for public perceptions. In fact, social problems are often defined by the number of people they affect. Higher numbers of deaths would tend to prompt more reaction from the public but overestimates that are later shown to be false could decrease attention.
A finance professor suggests the wage gap between economists and sociologists can be explained by the lack of statistical skills among sociologists:
Statistics is hugely valuable in the real world. Simply knowing how to run, and interpret, a regression is invaluable to management consultants. Statistics is now permeating the IT world, as a component of data science — and to do statistics, economists have to learn how to manage data. And statistics forces economists to learn to code, usually in Matlab.
As Econ 101 would tell us, these skills command a large premium. Unless universities want to shrink their economics departments, they have to shell out more money to keep the professors from bolting to consulting and financial firms.
If sociologists want to crack this bastion of economists’ “superiority,” they need to tech up with statistics. Sociologists do use some statistics, but in general it’s just much less rigorous and advanced than in economics. But there is no reason why that has to continue. Sociologists work with many quantitative topics. There are vast amounts of quantitative data available to them — and if there is a shortage, survey research centers such as the University of Michigan’s Institute for Social Research can generate more.
Using more and harder statistics will probably require more quantitative modeling of social phenomena. But it won’t require sociologists to adopt a single one of econ’s optimization models, or embrace any economics concepts. It won’t require giving one inch to the “imperialist” economics of Gary Becker’s disciples. All it will require is for sociologists to learn a lot more advanced statistics, and the data management and coding skills that go with it. The best way to make that happen is to start using a lot more sophisticated statistics in sociology papers. Eventually, the word “sociologist” will start to carry the connotation of “someone who is a whiz with data.” I’m sure some departments have already started to move in this direction.
I imagine this would generate a wide range of responses from sociologists. A few quick thoughts:
1. Using more advanced statistical techniques is one thing but it also involves a lot of interpretation and explanation. This is not just a technical recommendation but also requires links to conceptual and theoretical changes.
2. Can we statistically model the most complex social realities? Would having more and more big data make this possible? Statistics aren’t everything.
3. Any way to quantify this anecdotal argument? I can’t resist asking this…
A group of scientists is suggesting food packaging should replace calories with data on how much exercise is required to burn off that food:
A 500ml bottle of Coke, for example, contains 210 calories, more than a 10th of the daily recommended intake for a woman.
But US scientists think that statistic is ignored by most people and does not work as a health message.
Instead, telling them that it would take a 4.2 mile run or 42-minute walk to burn off the calories is far more effective.
The researchers, from the Johns Hopkins Bloomberg School of Public Health in Baltimore, found that teenagers given the information chose healthier drinks or smaller bottles…
They say that if a menu tells you a double cheeseburger will take a 5.6-mile hike before the calories are burned off, most people would rather choose a smaller hamburger which would require a walk of 2.6 miles…
Study leader Professor Sara Bleich said: ‘People don’t really understand what it means to say a typical soda has 250 calories.
The public vaguely knows what a calorie is – a measure of the amount of energy in food. However, the technical definition is difficult to translate into real life since a calorie is defined as “the energy needed to raise the temperature of 1 gram of water through 1 °C.” (Side note: does this mean Americans are even worse in judging calories due to not using the metric system?) This proposal does just that, translating the scientific term into one that practically makes sense to the average person. And, having such information could make comparisons easier.
I would wonder if the new exercise data would have diminishing returns over time. A new interpretation might catch people’s attention for a while. But, as time goes on, what is really the difference between that 3.6 mile burger and that 2.6 mile burger?