Question

Please check I have Included all data. PleaseQuestion 3. (Excel)

1 Large Aquatic Ecosystem A(b) Water (lb) Land (lb) Total Off-site Disposal or Other Releases (Ib) 2 Gulf of Mexico 103,388,652 27,973,389 192,854,761 47,136,665 9,256,585 82,262,361 60,949,058 3 Great Lakes 4 Columbia River Basin 69,842,541 14,453,816 4,476,337 68,764,823 26,491,084 4,483,7745,992,702 4,426,779 5 Chesapeake Bay 10,509,813 6 San Francisco Bay Delta 7 Puget Sound - Georgia Basin 3,799,246 4 3,755,527 1,802,07312,309,848 3,064,969 463,796226,619 77661 2,365,878 1,331,2447 8 Long Island Sound 2,826 1,909,109 9 South Florida 1,769,618 83 290,860 88,534 182,313 10 Lake Champlain Basin 215,460 308,305 115,609 11 Pacific Islands 246,080 274,259 10,717 0 12 13 14 15 16 17 18 9 20 21 23 24 25 26 27 28 29 30 31 32

The data for this question are the Toxic Release Inventory releases by large aquatic ecosystem in 2015. Make the following charts in Excel:

a) Separate pie charts of air, water, land, and other releases where the slices of the pie are ecosystems.

b) Side by side bar charts of air, water, land, and other releases where the bars are ecosystems.

c) Side by side bar charts switching the row and column variables for part 3b.

d) Comment on whether the bar charts of 3b or 3c make more sense.

e) Stacked bar charts of air, water, land, and other releases where the stripes on the bars are ecosystems.

f) Stacked bar charts switching the row and column variables for part e. g) Comment on whether the stacked bar charts of 3e or 3f make more sense.

Answer 1

3)

a)

Air Gull of Mexico Great Lakes Columbia River Basin Chesapeake Bay San Francisco Bay Delta Puget Sound Long Island Sound South Florida Lake Champion Basin Pacific Island

Water Gull of Mexico Great Lakes Columbia River Basin Chesapeake Bay San Francisco Bay Delta Puget Sound Long Island Sound South Florida Lake Champion Basin Pacific Island

Land Gull of Mexico Great Lakes Columbia River Basin Chesapeake Bay San Francisco Bay Delta Puget Sound Long Island Sound South Florida Lake Champion Basin Pacific Island

Others Gull of Mexico Great Lakes Columbia River Basin Chesapeake Bay San Francisco Bay Delta Puget Sound Long Island Sound South Florida Lake Champion Basin Pacific Island

b)

Chart Title NN00 Air Waer Land Others Gull of Mexico Great Lakes Columb ia River Basin Chesapeake Bay San Francisco Bay Delta Puget Sound South F brida Lake Champion Basin Long Island Sound Pacific Isand

c)

Chart Title 250000000 200000000 150000000 100000000 50000000 Air w er 1 Land Others

d) The second graph is more appropriate as through this we can judge in each ecosystem which fact is more important in case of toxic relief.

e)

Stacked Chart 100% 80% 70% 60% 50% 40% 漠)% 10% 0% Air Water Land Others Gull of Mexico Great Lakes Columbia River Basin Bay Delta Puget Sound Chesapeake Bay Long Island Sound South Florida Lake Champion Basin Pacific Isand

f)

Chart Title 100% 90% 80% 70% 60% 50% 씻)% 漠)% 10% 096 Air ·Water ·Land Others

As said in the previous answer here also we can judge in each ecosystem what percentage of fact effect the toxic release through the second graph.