The U.S. Department of the Interior releases figures on mineral production. Following are the 15 leading states in nonfuel mineral production in the United States in 2008.
State Value ($ billions)
Arizona 7.84
Nevada 6.48
Florida 4.20
Utah 4.17
California 4.00
Texas 3.30
Minnesota 3.21
Alaska 2.74
Missouri 2.08
Colorado 2.05
Michigan 2.05
Wyoming 1.89
Georgia 1.85
New Mexico 1.81
Pennsylvania 1.68
a) Using the data analysis toolpak in Excel, calculate the descriptive statistics.
b) Briefly explain what each of the metrics in the summary statistics means.
c) Comment on the figures in the report. What are they telling you about this data set? Is it symmetrical, flat, skewed, does it have outliers, and so on?