EVR2001: Environmental Science Assignment 1 Due: September 11, 2019 by 11:59PM Instructions: • Answer all questions in your own words in the space provided on the ANSWER DOCUMENT or in the EXCEL WORKSHEET. • Answer completely and concisely o Provide all necessary information o Do not ramble on about irrelevant topics • Submit your completed assignment on Canvas before the due date. -----------------------------------------------------------------------------------------------------------INTRO TO EXCEL Questions 1-11 are on the Excel Spreadsheet provided. INTERPRETTING DATA AND THE SCIENTIFIC METHOD 12. [5 points] Using the data on water withdrawal in the U.S. and the plot you created in question 11, create a testable hypothesis to explain the trends in water withdrawal. This scenario does not have to be true it has to be testable (able to be supported with further research or experiments). Keep them appropriate. 13. [5 points] There are two trees, Tree A and Tree B, that grow under very specific temperature conditions. Design an experiment that tests for what temperature ranges Tree A and Tree B grow best. ENVIRONMENTAL SCIENCE & ECONOMIES 14. [5 points] What are the four ways we can measure the wealth of nations? What are the problems with only using GNP and GDP to measure national wealth? 15. [5 points] Explain why understanding the impact human activity has on the environment is important to determining economic policies? EARTH AND ITS RESOURCES 16. [10 points] Most plastics are considered organic compounds (made of combinations of carbon with hydrogen and oxygen). What happens to plastics that are in landfills, dumps, or in the ocean? (In other words: How long does it take them to decompose?) Using this information and the Law of Conservation of Matter, what is happening to the carbon, hydrogen, and oxygen used in plastics? Why might this be a problem? 1. [1 point] In the yellow cell below, enter the number 3.14159 3.14159 2. [1 point] In the yellow cell below, enter the number 3.14159 and format the cell to scientific notation. 3.14E+00 3. [1 point] In the yellow cell below, add 3 and 6 together using a formula. Hint: formulas in Excel start with = 9 4. [1 point] In the yellow cell below, multiply 3 and 6 together using a formula. 18 5. [1 point] In the yellow cell below, enter the number in the green (C18) cell by using a formula that calls on the cell 42 42 6. [2 points] In the yellow cell below, add the green (C22) and blue (D22) cells together using a formula. 35 20 15 7. [2 points] In the yellow cell below, multiply the green (C26) and blue (D26) cells together using a formula. 500 100 5 8. [2 points] In the yellow cell below, enter the number in the green (C30) cell by using a formula and make it a fixed cell with $ signs. ( =$C$30 ) 867 867 9. [2 points] Using the yellow cell below, click the yellow cell then click and drag the box in the bottom right corner and drag it down 4 cells. You sho 1 1 1 1 1 10. [2 points] In the yellow cell below, multiply the green (C42) cell and first blue (D42) cell together. Make the green cell a fixed cell with dollar signs 3 3 1 6 2 9 3 12 4 15 5 Question 11 on "Excel Plotting Practice" tab at bottom cell a fixed cell with dollar signs. Then click the yellow cell and drag it down 4 cells. You should have 5 yellow cells with numbers 11. [5 points] Use the two columns of data below and plot a scatter plot "Scatter with Lines". Plot Speed vs Time (Y-axis vs. X-Axis). Plots should alwa Hint. To create a new plot and make sure it behaves how you want it: (1) click in an empty box near your data columns, (2) go to the "Insert" tab at the (5) New plot should be blank, (6) Right-click on plot and choose "Select Data', (7) this part is different for Windows & Mac but you will add a new data se (8) Add titles and labels from the "Chart Design" tab while your plot is clicked on, then go to "Add Chart Element" to add the various components. 1950 1955 1960 1965 1970 1975 1980 1985 1990 1995 2000 2005 2010 2015 U.S. Water Withdrawal (billion gallons per day) 184 246 271 314 372 412 435 396 403 398 416 410 355 322 Water withdrawal data from USGS: https://www.usgs.gov/spe U.S. Water Withdrawal (billion gallons per day) vs. U.S. Water Withdrawal (billion gallons per day) Year 500 450 400 350 300 250 200 150 100 50 0 1940 1960 1980 Year 2000 vs. X-Axis). Plots should always have a descriptive title, axis labels on the x and y axes, a reasonable scale (all data shown on plot, but plot is not tiny), units for ) go to the "Insert" tab at the top (next to "Home" & "Draw"), (3) near the middle find "X Y (Scatter)", (4) click and select "Scatter with Lines", GS: https://www.usgs.gov/special-topic/water-science-school/science/total-water-use-united-states?qt-science_center_objects=0#qt-science_center_objects hdrawal (billion gallons per day) vs. Year U.S. Water Withdrawal (billion gallons per day) 2000 2020 ot, but plot is not tiny), units for labels (if necessary), and a legend.
Purchase answer to see full attachment