Use Named Ranges to build a table of results for the possible answers to the problem.
Monthly Archives: July 2022
Sensitivity analysis with Goal Seek
Explore what would happen for the other answers to the problem.
Now convert to the required square miles measure
For the whole population, the result needs to be in square miles, and here we find the answer to the question.
Initial calculations in square feet
At the person level, the most convenient unit of measure is feet, so we start there
Assumptions for model
First we put the assumption for the model in cells at the top of the sheet, rather than inserting those assumption into the middle of formulas.
Introduction to Basic Modeling Problem
The problem to model is shown here
Here is a video describing the problem