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
Hi, this is the notation for inclusion of all real numbers.
We can also state numbers which are positive or negative with a sign on top of the R notation like so:
We can also state numbers which are positive or negative with a sign on top of the R notation like so:
We have to compare diameters and arrange them in order smallest to greatest
We can see units for option A and B are in square inches so they represents area. So first we will find diameter from area using formula
so for choice (A) area is given as . So plug this in A place in formula and then solve for radius r
3731.76 = r
So screw A will have inches
Similarly for choice (E) area is
so again plug in formula
2.13201 = r
So screw E will have inches
So diameters of all screws are as follows:
Screw A: 7463.52 inches
Screw B: 1.5 inches
Screw C: inches
Screw D: 0.25 inches
Screw E: 4.26402 inches
Comparing all numbers 7463.52, 1.5, 1.875, 0.25, 4.26402 we can see that smallest number is 0.25, then comes 1.5, then 1.875 and then 4.26402 and then 7463.52
So order from least to greatest will be screw D (0.25), B(1.5), C(1.875), E (4.26402), A (7463.52).
So thats the order D,B,C,E,A and the final answer