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
Given:
Consider the below figure attached with this question.
The linear equation is:
To find:
The values to complete the table of ordered pairs for the given linear equation.
Solution:
We have,
Substituting in the given equation, we get
So, the value for first blank is -8.
Substituting in the given equation, we get
So, the value for second blank is 3.
Substituting in the given equation, we get
So, the value for third blank is -4.
Therefore, the required complete table is:
x y
0 -8
3 -2
2 -4
