1
2
3
4
5
#

Name:

Description:

About hydropower by state

    Hydroelectricity generated by dams has some environmental advantages over other sources of electricity such as nuclear reactors and coal-fired power plants. Hydropower generates essentially no greenhouse gases and produces essentially no solid or toxic wastes, once the facility is constructed. Hydropower is renewable; no finite resources such as uranium ore, coal or petroleum are consumed, once the facility is built. Hydropower also can re-use the same water over and over to generate electricity, if a single river or stream has a series of facilities along its course. Hydropower is not without its problems, however. Dams alter habitat in many ways; fertile agricultural valleys are often lost, salmon and other migratory fish are severely impacted, etc.

    The United States Geological Survey has compiled data on the hydroelectric power production of each state and territory in 1990, as well as the amount of water used to generate this electricity. Though not stated, hydropower presumably includes both dams and in-stream turbines, though dams must account for practically all of the production. The units are quite interesting. Water use is given in millions of gallons per day; Washington State uses the better part of a million million gallons every day. Why did the USGS choose the very tiny unit, gallon per day? Electricity production is given in millions of kilowatt-hours; a million kilos is a billion, thus the data are actually given in Gigawatt-hours. Washington generates just under 105 Gwh of hydroelectricity each year; how many hours in a year, and therefore how much hydroelectric capacity is there in Washington State?

    The data range over 4 or 5 orders of magnitude, making it difficult to see the data on a conventional linear diagram. The scatterplot shows the logarithm of water use versus the logarithm of hydroelectric production. As might be expected, there is a strong positive correlation between these two variables, though with some scatter. The student should recognize that this scatter is actually quite large, as each increment on the graph represents one order of magnitude in size. Students can fit a linear regression to the "logged" data, and then use algebra to determine the best fit power law regression, if necessary. Is the data actually linear?

    The graph might give some indication of the efficiency of hydropower generation. Points below the line indicate larger quantities of water used to generate smaller amounts of electricity than the "average" represented by the regression; Iowa, Kansas, and Rhode Island, for example. Why are these states inefficient? Points above the line might indicate higher efficiency; California, Colorado and Nevada, for example. Why are these states efficient?

Reference:   U.S. Department of the Interior, Estimated Use of Water in the United States in 1990, USGS National Circular 1081.

Variables:

state - US state
water - water used to generate hydropower in millions of gallons per day
elec - electricity generation in millions of kilowatt-hours
log_water - logarithm of water variable
log_elec - logarithm of elec variable

Link To Google Sheets:

Rows:

Columns:

License Type:

References/Notes/Attributions:

Langkamp, G. and Hull, J., 2022. QELP Data Set 043. [online] Seattlecentral.edu. Available at: <https://seattlecentral.edu/qelp/sets/043/043.html> [Accessed 27 July 2022].

R Dataset Upload:

Use the following R code to directly access this dataset in R.

d <- read.csv("https://www.key2stats.com/Hydropower_Production_v.csv")

R Coding Interface:


Datasets Tag Questions & Instructional Blocks

NumberContentType
No results found.