Submit a document that includes the following items upon submission – be sure to follow the steps and prompts below as you create plots and answer questions:
1. Click on the link for the Snake River at Jackson Lake Dam Streamflow Reconstruction Page and build two quick reference tables (an Excel spreadsheet works great here) with the following information:
a. One with the descriptive stats for both the observed and reconstructed flow periods (provided in the metadata)
b. One with the statistics for calibration and validation
2. Download the “snakemoran.xls” data file from the TreeFlow.info website and make two scatterplots:
a. One plot showing both the observed and reconstructed streamflow data for the entire time period (1591-2005)
b. One plot showing both the observed and reconstructed streamflow data for only the time period of observed data (1910-2005)
c. Be sure to title and appropriately label the axes of each plot and provide a legend. You may use whatever graphing software is most comfortable for you, but I strongly encourage Excel.
3. How do the observed and reconstructed streamflow trends match up over the 1910-2005 period? What does the value of the explained variance in the calibration period (1910-2005) tell you about the strength of the relationship between the tree rings and streamflow in KAF? Hint: the closer an R2 value is to -1 or 1, the stronger the relationship. A value of 0 indicates no relationship at all.
4. What are some things that make reconstructing streamflow in the Upper Columbia River basin difficult?
5.How does current streamflow activity compare within the context of the entire available record?
Streamflow Part III — Applications
Please read Lost Cities and Climate Change by Kate Marvel. attached
6. How has climate change impacted civilizations in the past? Use and cite the article as needed for your answer here.