Yesterday I explained a bit about districts, territories and jurisdictions. These are places and people associated with the United States, but not within the US. This subject was only chosen to provide us with some numbers we can investigate - not because I have any special knowledge about it.
|Territory||Area Sq Miles||Land Sq Miles||Water Sq Miles||Water %|
|Northern Mariana Islands||1,975||179||1,796||90.93|
|United States Virgin Islands||737||134||604||81.87|
|Minor Outlying Islands||16||16||N/A||0.00|
The data came from Wikipedia.
MATH LIES AHEAD
Here's a simple math question related to the chart:
Which columns are essential, and which are discretionary or can be derived from the other(s)? How little do we need to know to fully populate this table?
This is what we teach kids to answer for themselves.
In our data there is total area, land and water area, and percentage of water for the first 5 rows. We'll ignore the last row because the minor islands don't claim water area.
If we are given total area, we need either land or water area and then we will know everything:
Total - (what ever number you have) = (the number you don't have)
(Water square miles) ÷ Total = (Water %)
Total ÷ (Water %) = (Water square miles)
Total - (Water square miles) = (Land square miles)
Total ÷ (1-Water %) = (Land square miles)
TOTAL - (Land square miles) = (Water square miles)
Now is when I say,
Isn't math fun?
and you say,
Get a life, Excelmathmike!
and I say,
Ok, then. Hiho, Hiho, it's off to an atoll I go...