Tag Archives: QL

How much have child and adolescent mortality rates changed?

The World Bank report, New child and adolescent mortality estimates show remarkable progress, but 17,000 children under 15 still died every day in 2017, by Emi Suzuki and co-author Haruna Kashiwase ( 9/18/18) provides a summary, as well as a number of charts. The good news:

There has been remarkable progress in reducing mortality among children and young adolescents in the past several decades. Between 1990 and 2017, the global under-five mortality rate dropped by 58 percent from 93 deaths per 1,000 live births to 39 deaths per 1,000 live births. During the last 17 years, the reduction in under-five mortality rates accelerated to an average 4% annual reduction, compared to an average 1.9% annual reduction between 1990 and 2000. For children aged 5-14, mortality dropped by 53 percent, from 15 deaths to 7 deaths per 1,000 children.

At the same time there is work to be done:

However, while a substantial reduction from the 14.3 million in 1990, an estimated 6.3 million children under age 15 still died in 2017, mostly from preventable causes.

The charts on the page are interactive but can’t be downloaded. On the other hand, the data is easily available and charts can be made for download. The chart here was made at the World Bank’s DataBank.  Note that the European Union has a lower under 5 mortality rate than the U.S. There are numerous variables to choose. Data can be downloaded and charts for download can be highly customized.

How have wages grown since 1980?

Source: EPI

Wage growth has varied depending on numerous factors such as gender, race, income level, and education. The EPI article,  America’s slow-motion wage crisis-Four decades of slow and unequal growth by John Schmitt, Elise Gould, and Josh Bivens (9/13/18) summarizes the findings with 30 graphs or tables (data included). For example, the cumulative percent change in inflation-adjusted hourly wages for workers in the 10th, 50th, and 90th percentile is given in the graph here (downloaded from the article).

The first key trend since 1979 is the historically slow growth in real wages. In 2017, middle-wage workers earned just 16.8 percent more than their counterparts almost four decades earlier. This corresponds to an annualized inflation-adjusted growth rate over the 38-year period of just 0.4 percent per year. The real wage increase for low-wage workers (those at the 10th percentile) was even slower: 8.9 percent over 38 years, or a 0.2 percent annualized growth rate.

This slow growth is particularly disappointing for two reasons. First, as we will see in the next section, U.S. workers today are generally older (and hence potentially more experienced) and substantially better educated than workers were at the end of the 1970s.10 Second, for workers at the bottom and the middle, most of the increase in real wages over the entire period took place in the short window between 1996 and the early 2000s. For the large majority of workers over the last four decades, wages were essentially flat or falling apart from a few short bursts of growth.

Quiz Questions: What was the cumulative change in hourly wages from 1979 to 2017 for

  1. What was the cumulative change in hourly wages from 1979 to 2017 for workers with an advanced degree?
  2. What was the cumulative change in hourly wages from 1979 to 2017 for workers with less than a high school diploma?
  3. Which ethnic group had the greatest change?
  4. What was the cumulative change in hourly wages from 1979 to 2017 for Women in the 50th percentile?
  5. What was the cumulative change in hourly wages from 1979 to 2017 for Men in the 50th percentile?

The article and/or corresponding data is ready for use in a stats or QL course in the 90th percentile.

Answers: (1) 30.0% (2) -9.6% (3) Asian American/Pacific Islander non-Hispanic 23.3% (4) 33.8% (5) 8.1%.

How much do countries spend on education?

The answer to the question depends on how it is measured.  The post  in statista, The Countries Spending the Most on Education by Martin Armstrong (9/12/2018) reports spending as a share of gross domestic product for primary, second and post-secondary non-tertiary education as well as tertiary education.  By this measure Norway spends the most. But, if the measure used is expenditure per student as a share of GDP per capita, the high spender is (south) Korea (Norway is fifth). Our graph here is a scatter plot of the two measures by country.

The data is from OECD.Stat. Go to Education and Training, Education at a Glance, Financial resources invested in education, Education finance indicators, and finally Expenditure per student as share of GDP per capita.  Under indicator at the top of the spreadsheet the measure can be changed.  Definitions of measures can be found in the OECD Handbook for Internationally Comparative Education Statistics (page 99).

Download the csv file and R-script used here.

What do we know about plastics?

The Our World in Data article Plastic Pollution by Hannah Ritchie and Max Roser (Sept 2018) is a detailed summary of plastics with 20 charts.  For example, one of the charts is a time series of plastic production (downloaded and posted here) showing that, in 2015, the world produced 381 million tons of plastic. In the same year, only 20% of the plastic was recycled (second chart in the article).  There is information on plastic waste generation.

Packaging, for example, has a very short ‘in-use’ lifetime (typically around 6 months or less). This is in contrast to building and construction, where plastic use has a mean lifetime of 35 years.7 Packaging is therefore the dominant generator of plastic waste, responsible for almost half of the global total.

Who produces the most plastic waste?

… we see the per capita rate of plastic waste generation, measured in kilograms per person per day. Here we see differences of around an order of magnitude: daily per capita plastic waste across the highest countries – Kuwait, Guyana, Germany, Netherlands, Ireland, the United States – is more than ten times higher than across many countries such as India, Tanzania, Mozambique and Bangladesh.

As always with Our World in Data, the data associated with each graph is downloadable.

How many 90+ degree days will your hometown have in the future?

The New York Times interactive article How Much Hotter Is Your Hometown Than When You Were Born? By Nadja Popovich, Blacki Migliozzi, Rumsey Taylor, Josh Williams and Derek Watkins, allows the reader to input a birth year and hometown and provides a graph with historical 90+ degree days and predictions for the future. For example a person born in 1970 in NYC would get the graph copied here.  In 1970 the expectation was six 90+ degree days, today it is 11, and by 2050 it will be 24 with a likely range of 15 to 30.

THE NEW YORK AREA is likely to feel this extra heat even if countries take action to lower their emissions by the end of the century, according to an analysis conducted for The New York Times by the Climate Impact Lab, a group of climate scientists, economists and data analysts from the Rhodium Group, the University of Chicago, Rutgers University and the University of California, Berkeley. If countries continue emitting at historically high rates, the future could look even hotter.

The future projection shown here assumes countries will curb greenhouse gas emissions roughly in line with the world’s original Paris Agreement pledges (although most countries do not appear on track to meet those pledges).

There are related human health impacts:

Worldwide, high temperatures have been found to increase the risk of illness and death, especially among older people, infants and people with chronic medical conditions. Lower-income populations, which more often lack access to air conditioning and other adaptive technologies, are also more likely to suffer the impacts of extreme heat. In America, so are people of color.

The article has other graphs and quantitative information which can be used in  QL based course.

How distracting are cell phones?

The extensive article by Pew Research, How Teens and Parents Navigate Screen Time and Device Distractions by Jingjing Jiang (8/22/18), presents detailed data on cell phone use.  For example,

And 51% of teens say they often or sometimes find their parent or caregiver to be distracted by their own cellphone when they are trying to have a conversation with them.

As they look at their own lives and those of their peers, most teens see things that worry them. Roughly nine-in-ten teens view spending too much time online as a problem facing people their age, including 60% who say it is a major problem.

The article has eight charts, one of which is reposted here.  There is a complete methodology section, which is perfect for a stats class, with enough information to use the data for statistical tests.

How much has the High Plains (or Ogallala) aquifer declined?

Source: USGS

The USGS post High Plains Aquifer Groundwater Levels Continue to Decline (6/16/17) summarizes the results from the USGS report Water-Level and Recoverable Water in Storage Changes, High Plains Aquifer, Predevelopment to 2015 and 2013–15.

In 2015, total recoverable water in storage in the aquifer was about 2.91 billion acre-feet, which is an overall decline of about 273.2 million acre-feet, or 9 percent, since predevelopment. Average area-weighted water-level change in the aquifer was a decline of 15.8 feet from predevelopment to 2015 and a decline of 0.6 feet from 2013 to 2015.

A little geography:

The High Plains aquifer, also known as the Ogallala aquifer, underlies about 112 million acres, or 175,000 square miles, in parts of eight states, including: Colorado, Kansas, Nebraska, New Mexico, Oklahoma, South Dakota, Texas and Wyoming. The USGS, at the request of the U.S. Congress and in cooperation with numerous state, local, and federal entities, has published reports on water-level changes in the High Plains aquifer since 1988 in response to substantial water-level declines in large areas of the aquifer.

A more recent article in the Conversation, Farmers are drawing groundwater from the giant Ogallala Aquifer faster than nature replaces it by Char Miller (8/7/18) provides context around the loss of water in the Ogallala. 

In my view, Plains farmers cannot afford to continue pushing land and water resources beyond their limits – especially in light of climate change’s cumulative impact on the Central Plains. For example, a recent study posits that as droughts bake the land, lack of moisture in the soil actually spikes temperatures. And as the air heats up, it further desiccates the soil.

This vicious cycle will accelerate the rate of depletion. And once the Ogallala is emptied, it could take 6,000 years to recharge naturally. In the words of Brent Rogers, a director of Kansas Groundwater Management District 4, there are “too many straws in too small of a cup.”

The USGS post and the Conversation article are useful for a QL based course. The full USGS report has links to water-level data sources starting on page 7.

Where are women less likely than men (ages 30-70) to die of a major disease?

The Our World in Data post, Why do women live longer than men?  by Esteban Ortiz-Ospina and Diana Beltekian (8/14/18) answers the question with the graph copied here.

As the next chart shows, in most countries for all the primary causes of death the mortality rates are higher for men. More detailed data shows that this is true at all ages; yet paradoxically, while women have lower mortality rates throughout their life, they also often have higher rates of physical illness, more disability days, more doctor visits, and hospital stays than men do. It seems women do not live longer than men only because they age more slowly, but also because they are more robust when they get sick at any age. This is an interesting point that still needs more research.

Interestingly, it seems that  except for Bhutan it is only countries in Africa where women are more likely to die of a major disease.  The article is an excellent example of telling a story with data while also posing questions.

The evidence shows that differences in chromosomes and hormones between men and women affect longevity. For example, males tend to have more fat surrounding the organs (they have more ‘visceral fat’) whereas women tend to have more fat sitting directly under the skin (‘subcutaneous fat’). This difference is determined both by estrogen and the presence of the second X chromosome in females; and it matters for longevity because fat surrounding the organs predicts cardiovascular disease.

But biological differences can only be part of the story – otherwise we’d not see such large differences across countries and over time. What else could be going on?

The article has three other graphs beyond this one. One compares life expectancy by country for women and men, one for life expectancy for men and women in the U.S. (and three other countries that can be selected) since 1790, and one for the difference in life expectancy at age 45 since 1790 for selected countries.  All graph can be downloaded  and the data is available for each.

What do we know about nighttime minimum temperatures?

The recent article on Climate.gov Extreme overnight heat in California and the Great Basin in July 2018 by Rebecca Lindsey (8/8/18) provides an overview in context.

As the NCEI’s Deke Arndt has blogged about before, nighttime low temperatures are increasing faster than daytime high temperatures across most of the contiguous United States. For much of the West and Southwest, July’s record-breaking nighttime heat is a new highpoint in a long-term trend—one that has rapidly accelerated in recent decades. In California, average overnight low temperature in July rose by 0.3°F per decade over the historical record (1895-2018), but since 2000, the pace of warming has accelerated to 1.3°F per decade.

Here is an example of why this matters:

According to Tim Brown, director of NOAA’s Western Region Climate Center (WRCC), it’s a pattern that has serious consequences for wildfires and those who combat them. When temperatures cool off overnight, it’s not just a physical relief for firefighters who may be working in conditions that push the limits of human endurance; fire behavior itself relaxes as temperatures drop, winds grow calmer, and relative humidity rises.

The graph here for California July minimum temperature is from the article. A stats course can have students create a similar graph for their hometown. Go to  NOAA’s Local Climatological Data Map. Click on the wrench under Layers. Use the rectangle tool to select your local weather station. Check off the station and Add to Cart. Follow the direction from their being sure to select csv file. You will get an email link for the data within a day.  Note: You are limited in the size of the data to ten year periods. You will need to do this more than once to get the full data set available for your station.

The map here  shows statewide minimum temperature ranks for July 2018.  It is from NOAA’s National Temperature and Precipitation Maps page.  Under products select Statewide Minimum Temperature Ranks and choose the desired time period.  A map similar to the one in the article can be generated by selecting CONUS Gridded Minimum Temperature Ranks.

What are the prospects for high school grads?

The EPI article Class of 2018 High school edition by Elise Gould, Zane Mokhiber, & Julia Wolfe (6/14/18) provides a thorough review.  Figure I from the report, copied here, shows 2000 and 2018 wages for high school grads not enrolled in further schooling by race and gender.

In 2018, young workers with a high school diploma have an average hourly wage of $11.85, which translates to annual earnings of around $24,600 for a full-time, full-year worker. This overall average masks important differences in wages by gender and race.

The report has 11 graphs each with data that can be downloaded along with the graph.  A few points from the article:

  • Only 32% of 18-64 have a four year degree or more while 10.5% haven’t graduated high school. (see figure A)
  • The percent of high school grads (18-21) that are employed and not enrolled has increased from 26% in 2010 to 31% in 2018. (see figure c)
  • Over much of the last three decades, wage growth for young high school graduates has been essentially flat. (see figure H)

The first paragraph of their conclusion:

While there may be many reasons someone might choose to enter the labor force after high school rather than attend college, college should at least be a viable option; a person’s economic resources should not be the determining factor in whether they get to go to college. But, as things stand, the prospect of staggering debt may discourage students from less wealthy families from enrolling in further education or prevent them from completing a degree.