just follow instructions on paper

Complete the lab questions below (Word version here).

The completed Excel sheet is available here (PDF- not editable)

  1. The maximum subsidence that has occurred in New Orleans is believed to be 10-12 feet as of 2018. Explain why this is/is not supported by your data. Include estimates in your explanation.
  2. The map we viewed in class represented a direct measurement. Your Excel spreadsheet is a model representing an anticipated outcome based on generally agreed-upon values. What could account for any differences (error) between the map and your data table.
  3. The total subsidence in your spreadsheet depends on the average rates in the right side of your spreadsheet. These can be changed at any time- and as new research comes forward, there’s a good chance they might.
  4. Suppose new studies suggest that the tectonic subsidence might be closer to 0.40 mm/year over the last 200 years, even though the long-term trend could be higher than that. This PDF is modified to reflect this new calculation.
    (changed tectonic movement from 5.0 to 0.40 mm/year as circled)
    • Do the new calculations support the observed 10-12 foot subsidence rate?
    • As a scientist, what would you suggest that researchers do from here? Why? What does this mean for your model?