Question

Dr. Zinnert is studying coastal plant ecology using remote sensing data. Satalite images enable her to deduce land coverage on coastal barrier islands on the coast of Virginia.Given the table below, what percent of barrier island is bare earth?Report your answer to two decimal places and carry out all calculations in a single step using Excel to prevent accruing rounding error.Ground Cover km2Trees 1.4Shrubs 2.3Grass 1.4Bare Earth 4.5

Answer 1

Answer:

Attached is the excel solution

answer : The  percentage of the barrier island that is bare earth = 46.88

Step-by-step explanation:

ROUND((B5*100/SUM(B2:B5),2) is used to calculate the percent of barrier island that is bare earth.

SUM(B2:B5) is used to compute the total area of barrier island.

while  B5 stores the area of Bare Earth.