Dr. Zinnert is studying coastal plant ecology using remote sensing data. Satalite images enable her to deduce land coverage on c
oastal 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
1 answer:
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.
You might be interested in
Answer:
Step-by-step explanation:
To get you needed to divide the numerator and denominator by 3.