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:
1½ cords per hour
Step-by-step explanation:
A log splitter can split 6/5 cords of wood in 4/5 of an hour.
To find a unit rate, we divide the quantity of cords of wood by the time.
This gives us the complex fraction.
This is the same as
To divide two fractions, we multiply by the reciprocal of the second fraction.
This simplifies to:
The unit rate is 1.5 cords per hour