finishing 2 questions about CO2, Chemistry homework help

Anonymous

Question Description

See the questions and answer them. just questions 1,and 2. Make sure it's typed.

Unformatted Attachment Preview

Make-Up Lab Assignment CO2 Graphing CHEM 132L Expt. 7 Include the following information at the top of the first page of your assignment: Your Name Chemistry Lab Section Number Experiment Title Due Date Directions: Complete this assignment and turn in a typed set of answers to all questions. To complete this assignment your instructor will provide you with an Excel file called “CO2 Data Make-up Assignment.xlsx”. The data in the spreadsheet are monthly average CO2 concentrations from the Mauna Loa Observatory in Hawaii. The first worksheet is the entire 55-year record of CO2 data listed in two columns. One column represents the raw CO2 monthly average concentration and the second column is a seasonally corrected value to normalize for drawdown of CO2 during active plant photosynthesis in the northern hemisphere. The second worksheets represent the 8-year period from 1959-1966. On each worksheet there are two graphs. The first is a graph of the entire record represented in that worksheet. Both the raw and seasonally corrected data are plotted in the first graph. The second graph is a plot of just one year of data (the first year in each). For all the graphs, a linear trendline has been fitted to the seasonally corrected data and the equation of that line is shown. Follow the directions below and answer the questions for the time period 19591966. Data and Calculations 1. Open the sheet for the 8-year period. Record the equation of the trendline in the one year graph (slope, intercept and R2 value). Then replace the data in this plot with the next year and record the equation for the trendline. Plot each year from your assigned timeframe, and record the values from the equation for each year. Create a typed table that concisely presents the trendline data for all eight years. 2. Using the equation for each year, predict what the CO2 concentration should on December 31,1967. Add all eight of these values to the table in question 1 above. Then, make the same prediction for the CO2 concentration using the equation for the entire 8-year period. You should have nine predictions of the CO2 concentration using the different time ranges. ***Note you will have to convert the date to a number to make this calculation by using the date converter (in bold at the top of the worksheet). Questions – All answers should be typed and answered in complete sentences. 1. Why was the seasonally corrected data used for the one year plots instead of the raw CO2 data? Specifically, how would using the raw data have affected the trend line? 2. Are the CO2 concentration predictions based on the one-year time frames that you calculated above similar to each other? 3. How do the one-year models compare with the 8-year model? Explain. 4. Look up the actual CO2 concentration on December 31,1967 at http://www.esrl.noaa.gov/gmd/ccgg/trends/and compare this with your predictions? Which model is the most accurate? Why? 5. Find the last CO2 concentration in the 8-year data set and double the concentration value. Using your 8-year model, predict the date that the CO2 concentration would reach this doubled value. Now make the same prediction using the model for the total 55-year record and compare the two predictions. Show your calculations for each prediction. You will need to convert the numeric date you calculate to a m/dd/yyyy format. To do this simply type the number you calculate into any blank cell in Excel. Then change the cell format from ‘general’ to ‘date’. For example, 104582 is equal to May 2186. 6. Why are the predictions for the year the CO2 concentration will double different from each other, and what does this tell you about making predictions using a model generated from existing data? Year Month Date 1958 1958 1958 1958 1958 1958 1958 1958 1958 1958 1959 1959 1959 1959 1959 1959 1959 1959 1959 1959 1959 1959 1960 1960 1960 1960 1960 1960 1960 1960 1960 1960 1960 1960 1961 1961 1961 1961 1961 1961 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 Mar-58 Apr-58 May-58 Jun-58 Jul-58 Aug-58 Sep-58 Oct-58 Nov-58 Dec-58 Jan-59 Feb-59 Mar-59 Apr-59 May-59 Jun-59 Jul-59 Aug-59 Sep-59 Oct-59 Nov-59 Dec-59 Jan-60 Feb-60 Mar-60 Apr-60 May-60 Jun-60 Jul-60 Aug-60 Sep-60 Oct-60 Nov-60 Dec-60 Jan-61 Feb-61 Mar-61 Apr-61 May-61 Jun-61 CO2 (ppm) Seasonally Corrected CO2 Trend (ppm) 315.71 317.45 317.5 317.1 315.86 314.93 313.2 312.66 313.33 314.67 315.62 316.38 316.71 317.72 318.29 318.15 316.54 314.8 313.84 313.26 314.8 315.58 316.43 316.97 317.58 319.02 320.03 319.59 318.18 315.91 314.16 313.83 315 316.19 316.93 317.7 318.54 319.48 320.58 319.77 314.61 315.29 314.71 314.85 314.98 315.94 315.91 315.61 315.31 315.62 315.7 315.88 315.61 315.56 315.5 315.92 315.66 315.81 316.55 316.19 316.78 316.52 316.51 316.47 316.48 316.86 317.24 317.36 317.3 316.92 316.87 316.76 316.98 317.13 317.04 317.28 317.47 317.27 317.7 317.48 400 390 380 370 360 350 340 330 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 Jul-61 Aug-61 Sep-61 Oct-61 Nov-61 Dec-61 Jan-62 Feb-62 Mar-62 Apr-62 May-62 Jun-62 Jul-62 Aug-62 Sep-62 Oct-62 Nov-62 Dec-62 Jan-63 Feb-63 Mar-63 Apr-63 May-63 Jun-63 Jul-63 Aug-63 Sep-63 Oct-63 Nov-63 Dec-63 Jan-64 Feb-64 Mar-64 Apr-64 May-64 Jun-64 Jul-64 Aug-64 Sep-64 Oct-64 Nov-64 318.57 316.79 314.8 315.38 316.1 317.01 317.94 318.56 319.68 320.63 321.01 320.55 319.58 317.4 316.26 315.42 316.69 317.69 318.74 319.08 319.86 321.39 322.25 321.47 319.74 317.77 316.21 315.99 317.12 318.31 319.57 320.07 320.73 321.77 322.25 321.89 320.44 318.7 316.7 316.79 317.79 317.7 317.8 317.49 318.35 318.13 317.94 318.06 318.11 318.57 318.45 318.2 318.27 318.67 318.48 319.03 318.33 318.62 318.61 318.91 318.68 318.69 319.09 319.39 319.16 318.76 318.83 319.06 319 319.1 319.25 319.67 319.61 319.55 319.48 319.42 319.69 319.58 319.81 319.56 319.79 319.72 320 310 300 Mar-58 1961 1961 1961 1961 1961 1961 1962 1962 1962 1962 1962 1962 1962 1962 1962 1962 1962 1962 1963 1963 1963 1963 1963 1963 1963 1963 1963 1963 1963 1963 1964 1964 1964 1964 1964 1964 1964 1964 1964 1964 1964 1964 1965 1965 1965 1965 1965 1965 1965 1965 1965 1965 1965 1965 1966 1966 1966 1966 1966 1966 1966 1966 1966 1966 1966 1966 1967 1967 1967 1967 1967 1967 1967 1967 1967 1967 1967 1967 1968 1968 1968 1968 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 Dec-64 Jan-65 Feb-65 Mar-65 Apr-65 May-65 Jun-65 Jul-65 Aug-65 Sep-65 Oct-65 Nov-65 Dec-65 Jan-66 Feb-66 Mar-66 Apr-66 May-66 Jun-66 Jul-66 Aug-66 Sep-66 Oct-66 Nov-66 Dec-66 Jan-67 Feb-67 Mar-67 Apr-67 May-67 Jun-67 Jul-67 Aug-67 Sep-67 Oct-67 Nov-67 Dec-67 Jan-68 Feb-68 Mar-68 Apr-68 318.71 319.44 320.44 320.89 322.13 322.16 321.87 321.39 318.81 317.81 317.3 318.87 319.42 320.62 321.59 322.39 323.87 324.01 323.75 322.39 320.37 318.64 318.1 319.79 321.08 322.07 322.5 323.04 324.42 325 324.09 322.55 320.92 319.31 319.31 320.72 321.96 322.57 323.15 323.89 325.02 319.59 319.48 319.97 319.65 319.8 319.36 319.65 320.51 319.93 320.68 320.36 320.87 320.26 320.62 321.1 321.16 321.51 321.18 321.52 321.49 321.5 321.54 321.18 321.84 321.95 322.07 321.94 321.72 322.05 322.27 321.94 321.66 322.04 322.19 322.36 322.78 322.86 322.55 322.56 322.59 322.73 1968 1968 1968 1968 1968 1968 1968 1968 1969 1969 1969 1969 1969 1969 1969 1969 1969 1969 1969 1969 1970 1970 1970 1970 1970 1970 1970 1970 1970 1970 1970 1970 1971 1971 1971 1971 1971 1971 1971 1971 1971 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 May-68 Jun-68 Jul-68 Aug-68 Sep-68 Oct-68 Nov-68 Dec-68 Jan-69 Feb-69 Mar-69 Apr-69 May-69 Jun-69 Jul-69 Aug-69 Sep-69 Oct-69 Nov-69 Dec-69 Jan-70 Feb-70 Mar-70 Apr-70 May-70 Jun-70 Jul-70 Aug-70 Sep-70 Oct-70 Nov-70 Dec-70 Jan-71 Feb-71 Mar-71 Apr-71 May-71 Jun-71 Jul-71 Aug-71 Sep-71 325.57 325.36 324.14 322.03 320.41 320.25 321.31 322.84 324 324.42 325.64 326.66 327.34 326.76 325.88 323.67 322.38 321.78 322.85 324.11 325.03 325.99 326.87 328.13 328.07 327.66 326.35 324.69 323.1 323.16 323.98 325.13 326.17 326.68 327.18 327.78 328.92 328.57 327.34 325.46 323.36 322.87 323.2 323.25 323.15 323.31 323.32 323.32 323.69 323.98 323.89 324.41 324.35 324.57 324.63 325.07 324.8 325.28 324.84 324.78 324.88 325.04 325.42 325.69 325.86 325.27 325.52 325.51 325.76 325.93 326.15 325.96 326.06 326.26 326.09 325.94 325.47 326.11 326.41 326.46 326.49 326.18 1971 1971 1971 1972 1972 1972 1972 1972 1972 1972 1972 1972 1972 1972 1972 1973 1973 1973 1973 1973 1973 1973 1973 1973 1973 1973 1973 1974 1974 1974 1974 1974 1974 1974 1974 1974 1974 1974 1974 1975 1975 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 Oct-71 Nov-71 Dec-71 Jan-72 Feb-72 Mar-72 Apr-72 May-72 Jun-72 Jul-72 Aug-72 Sep-72 Oct-72 Nov-72 Dec-72 Jan-73 Feb-73 Mar-73 Apr-73 May-73 Jun-73 Jul-73 Aug-73 Sep-73 Oct-73 Nov-73 Dec-73 Jan-74 Feb-74 Mar-74 Apr-74 May-74 Jun-74 Jul-74 Aug-74 Sep-74 Oct-74 Nov-74 Dec-74 Jan-75 Feb-75 323.57 324.8 326.01 326.77 327.63 327.75 329.72 330.07 329.09 328.05 326.32 324.93 325.06 326.5 327.55 328.54 329.56 330.3 331.5 332.48 332.07 330.87 329.31 327.51 327.18 328.16 328.64 329.35 330.71 331.48 332.65 333.19 332.12 330.99 329.17 327.41 327.21 328.34 329.5 330.68 331.41 326.58 326.82 327.02 326.86 327.05 326.52 327.41 327.21 326.94 327.24 327.37 327.73 328.05 328.5 328.56 328.58 328.87 328.99 329.12 329.6 329.96 330.1 330.43 330.43 330.23 330.17 329.66 329.44 330.11 330.19 330.25 330.25 329.93 330.2 330.31 330.35 330.29 330.33 330.47 330.81 330.86 1975 1975 1975 1975 1975 1975 1975 1975 1975 1975 1976 1976 1976 1976 1976 1976 1976 1976 1976 1976 1976 1976 1977 1977 1977 1977 1977 1977 1977 1977 1977 1977 1977 1977 1978 1978 1978 1978 1978 1978 1978 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 Mar-75 Apr-75 May-75 Jun-75 Jul-75 Aug-75 Sep-75 Oct-75 Nov-75 Dec-75 Jan-76 Feb-76 Mar-76 Apr-76 May-76 Jun-76 Jul-76 Aug-76 Sep-76 Oct-76 Nov-76 Dec-76 Jan-77 Feb-77 Mar-77 Apr-77 May-77 Jun-77 Jul-77 Aug-77 Sep-77 Oct-77 Nov-77 Dec-77 Jan-78 Feb-78 Mar-78 Apr-78 May-78 Jun-78 Jul-78 331.85 333.29 333.91 333.4 331.74 329.88 328.57 328.36 329.33 330.59 331.66 332.75 333.46 334.78 334.78 334.06 332.95 330.64 328.96 328.77 330.18 331.65 332.69 333.23 334.97 336.03 336.82 336.1 334.79 332.53 331.19 331.21 332.35 333.47 335.09 335.26 336.61 337.77 338 337.98 336.48 330.49 330.77 330.94 331.18 330.92 331.06 331.54 331.46 331.39 331.6 331.82 332.19 331.99 332.24 331.86 331.74 332.06 331.87 331.94 331.92 332.33 332.69 332.75 332.6 333.36 333.39 333.87 333.76 333.96 333.92 334.27 334.43 334.59 334.48 335.11 334.58 334.95 335.11 335.05 335.6 335.68 1978 1978 1978 1978 1978 1979 1979 1979 1979 1979 1979 1979 1979 1979 1979 1979 1979 1980 1980 1980 1980 1980 1980 1980 1980 1980 1980 1980 1980 1981 1981 1981 1981 1981 1981 1981 1981 1981 1981 1981 1981 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 Aug-78 Sep-78 Oct-78 Nov-78 Dec-78 Jan-79 Feb-79 Mar-79 Apr-79 May-79 Jun-79 Jul-79 Aug-79 Sep-79 Oct-79 Nov-79 Dec-79 Jan-80 Feb-80 Mar-80 Apr-80 May-80 Jun-80 Jul-80 Aug-80 Sep-80 Oct-80 Nov-80 Dec-80 Jan-81 Feb-81 Mar-81 Apr-81 May-81 Jun-81 Jul-81 Aug-81 Sep-81 Oct-81 Nov-81 Dec-81 334.37 332.33 332.41 333.76 334.83 336.21 336.65 338.13 338.95 339.01 339.2 337.6 335.56 333.93 334.12 335.26 336.78 337.8 338.28 340.04 340.86 341.47 341.26 339.34 337.45 336.1 336.05 337.21 338.29 339.35 340.51 341.57 342.56 343.01 342.49 340.68 338.49 336.92 337.12 338.59 339.9 335.88 335.49 335.66 336.01 335.79 336.21 335.92 336.37 336.2 336.03 336.82 336.8 337.12 337.18 337.45 337.53 337.74 337.94 337.71 338.4 338.2 338.48 338.82 338.5 338.93 339.27 339.32 339.37 339.21 339.4 339.87 339.95 339.93 340.01 340.05 339.84 339.98 340.17 340.44 340.74 340.79 1982 1982 1982 1982 1982 1982 1982 1982 1982 1982 1982 1982 1983 1983 1983 1983 1983 1983 1983 1983 1983 1983 1983 1983 1984 1984 1984 1984 1984 1984 1984 1984 1984 1984 1984 1984 1985 1985 1985 1985 1985 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 Jan-82 Feb-82 Mar-82 Apr-82 May-82 Jun-82 Jul-82 Aug-82 Sep-82 Oct-82 Nov-82 Dec-82 Jan-83 Feb-83 Mar-83 Apr-83 May-83 Jun-83 Jul-83 Aug-83 Sep-83 Oct-83 Nov-83 Dec-83 Jan-84 Feb-84 Mar-84 Apr-84 May-84 Jun-84 Jul-84 Aug-84 Sep-84 Oct-84 Nov-84 Dec-84 Jan-85 Feb-85 Mar-85 Apr-85 May-85 340.92 341.69 342.84 343.84 344.3 343.42 341.85 339.82 337.98 338.09 339.24 340.67 341.42 342.67 343.46 345.08 345.76 345.33 343.93 342.08 340 340.12 341.35 342.89 343.87 344.59 345.28 346.59 347.36 346.8 345.37 343.06 341.24 341.54 342.9 344.35 345.09 345.89 347.49 348.03 348.75 341.02 341.04 341.18 341.21 341.29 341 341.1 341.32 341.19 341.42 341.37 341.54 341.56 342.07 341.88 342.45 342.62 342.87 343.23 343.55 343.15 343.44 343.47 343.78 343.95 344 343.78 343.99 344.2 344.35 344.67 344.53 344.41 344.84 345 345.22 345.17 345.29 346.04 345.45 345.61 1985 1985 1985 1985 1985 1985 1985 1986 1986 1986 1986 1986 1986 1986 1986 1986 1986 1986 1986 1987 1987 1987 1987 1987 1987 1987 1987 1987 1987 1987 1987 1988 1988 1988 1988 1988 1988 1988 1988 1988 1988 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 Jun-85 Jul-85 Aug-85 Sep-85 Oct-85 Nov-85 Dec-85 Jan-86 Feb-86 Mar-86 Apr-86 May-86 Jun-86 Jul-86 Aug-86 Sep-86 Oct-86 Nov-86 Dec-86 Jan-87 Feb-87 Mar-87 Apr-87 May-87 Jun-87 Jul-87 Aug-87 Sep-87 Oct-87 Nov-87 Dec-87 Jan-88 Feb-88 Mar-88 Apr-88 May-88 Jun-88 Jul-88 Aug-88 Sep-88 Oct-88 348.19 346.48 344.71 343.04 342.92 344.22 345.62 346.42 346.95 347.88 349.57 350.35 349.7 347.78 345.89 344.88 344.33 345.67 346.89 348.2 348.55 349.55 351.14 351.85 351.46 349.77 347.66 346.39 346.51 347.8 349.03 350.23 351.58 352.22 353.53 354.14 353.64 352.53 350.42 348.84 348.94 345.75 345.72 346.1 346.17 346.2 346.37 346.56 346.44 346.39 346.52 347.01 347.22 347.27 346.99 347.3 348.01 347.56 347.8 347.81 348.12 347.85 348.12 348.59 348.75 349.09 349.08 349.16 349.57 349.74 349.92 349.92 350.18 350.87 350.71 350.87 350.96 351.26 351.9 351.97 352.04 352.21 1988 1988 1989 1989 1989 1989 1989 1989 1989 1989 1989 1989 1989 1989 1990 1990 1990 1990 1990 1990 1990 1990 1990 1990 1990 1990 1991 1991 1991 1991 1991 1991 1991 1991 1991 1991 1991 1991 1992 1992 1992 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 Nov-88 Dec-88 Jan-89 Feb-89 Mar-89 Apr-89 May-89 Jun-89 Jul-89 Aug-89 Sep-89 Oct-89 Nov-89 Dec-89 Jan-90 Feb-90 Mar-90 Apr-90 May-90 Jun-90 Jul-90 Aug-90 Sep-90 Oct-90 Nov-90 Dec-90 Jan-91 Feb-91 Mar-91 Apr-91 May-91 Jun-91 Jul-91 Aug-91 Sep-91 Oct-91 Nov-91 Dec-91 Jan-92 Feb-92 Mar-92 349.99 351.29 352.72 353.1 353.64 355.43 355.7 355.11 353.79 351.42 349.83 350.1 351.26 352.66 353.63 354.72 355.49 356.11 357.08 356.11 354.67 352.67 351.05 351.36 352.81 354.21 354.87 355.66 357 358.4 359 357.99 355.96 353.78 352.2 352.22 353.7 354.98 356.08 356.88 357.73 352.16 352.21 352.63 352.37 352.17 352.76 352.47 352.69 353.16 353.03 353.08 353.35 353.43 353.61 353.55 354.01 354.02 353.49 353.9 353.7 354.06 354.32 354.32 354.59 354.88 355.06 354.82 354.96 355.5 355.77 355.84 355.64 355.37 355.42 355.51 355.46 355.69 355.79 355.99 356.15 356.19 1992 1992 1992 1992 1992 1992 1992 1992 1992 1993 1993 1993 1993 1993 1993 1993 1993 1993 1993 1993 1993 1994 1994 1994 1994 1994 1994 1994 1994 1994 1994 1994 1994 1995 1995 1995 1995 1995 1995 1995 1995 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 Apr-92 May-92 Jun-92 Jul-92 Aug-92 Sep-92 Oct-92 Nov-92 Dec-92 Jan-93 Feb-93 Mar-93 Apr-93 May-93 Jun-93 Jul-93 Aug-93 Sep-93 Oct-93 Nov-93 Dec-93 Jan-94 Feb-94 Mar-94 Apr-94 May-94 Jun-94 Jul-94 Aug-94 Sep-94 Oct-94 Nov-94 Dec-94 Jan-95 Feb-95 Mar-95 Apr-95 May-95 Jun-95 Jul-95 Aug-95 358.91 359.46 359.18 356.71 354.76 352.8 353.21 354.15 355.41 356.76 357.17 358.26 359.16 360.07 359.41 357.36 355.29 353.96 354.03 355.27 356.7 358.04 358.8 359.67 361.13 361.48 360.6 359.2 357.23 355.42 355.89 357.41 358.74 359.73 360.65 361.59 363.04 363.62 363.07 361.55 358.91 356.21 356.24 356.79 356.14 356.49 356.16 356.49 356.2 356.24 356.7 356.31 356.6 356.5 356.89 356.98 356.78 357 357.33 357.38 357.4 357.59 357.93 357.97 358.03 358.39 358.25 358.2 358.61 358.94 358.85 359.28 359.56 359.61 359.61 359.84 360.02 360.38 360.46 360.68 360.88 360.54 1995 1995 1995 1995 1996 1996 1996 1996 1996 1996 1996 1996 1996 1996 1996 1996 1997 1997 1997 1997 1997 1997 1997 1997 1997 1997 1997 1997 1998 1998 1998 1998 1998 1998 1998 1998 1998 1998 1998 1998 1999 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 Sep-95 Oct-95 Nov-95 Dec-95 Jan-96 Feb-96 Mar-96 Apr-96 May-96 Jun-96 Jul-96 Aug-96 Sep-96 Oct-96 Nov-96 Dec-96 Jan-97 Feb-97 Mar-97 Apr-97 May-97 Jun-97 Jul-97 Aug-97 Sep-97 Oct-97 Nov-97 Dec-97 Jan-98 Feb-98 Mar-98 Apr-98 May-98 Jun-98 Jul-98 Aug-98 Sep-98 Oct-98 Nov-98 Dec-98 Jan-99 357.93 357.8 359.22 360.44 361.83 362.94 363.87 364.27 364.93 364.7 363.3 361.16 359.38 359.33 360.62 361.96 362.82 363.87 364.24 366.02 366.46 365.36 364.1 361.96 360.12 360.49 362.21 364.12 365 365.8 366.95 368.44 369.31 368.78 367.6 365.63 363.84 364.19 365.37 366.92 367.96 361.31 361.15 361.35 361.32 361.61 362.07 362.27 361.59 361.88 362.41 362.6 362.78 362.82 362.69 362.76 362.82 362.62 363.07 362.66 363.37 363.54 363.17 363.39 363.54 363.49 363.78 364.26 364.89 364.81 365 365.34 365.83 366.42 366.57 366.91 367.21 367.16 367.46 367.42 367.69 367.75 1999 1999 1999 1999 1999 1999 1999 1999 1999 1999 1999 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2001 2001 2001 2001 2001 2001 2001 2001 2001 2001 2001 2001 2002 2002 2002 2002 2002 2002 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 Feb-99 Mar-99 Apr-99 May-99 Jun-99 Jul-99 Aug-99 Sep-99 Oct-99 Nov-99 Dec-99 Jan-00 Feb-00 Mar-00 Apr-00 May-00 Jun-00 Jul-00 Aug-00 Sep-00 Oct-00 Nov-00 Dec-00 Jan-01 Feb-01 Mar-01 Apr-01 May-01 Jun-01 Jul-01 Aug-01 Sep-01 Oct-01 Nov-01 Dec-01 Jan-02 Feb-02 Mar-02 Apr-02 May-02 Jun-02 368.82 369.41 370.78 370.52 370.14 369.09 366.69 364.71 365.17 366.5 367.85 369.07 369.31 370.37 371.67 371.35 371.51 369.69 368.15 366.86 366.94 368.28 369.62 370.47 371.44 372.39 373.33 373.78 373.13 371.51 369.59 368.15 368.38 369.64 371.11 372.37 373.08 373.86 374.93 375.59 375.43 368.02 367.84 368.26 367.7 367.96 368.42 368.23 368 368.43 368.49 368.53 368.87 368.6 368.87 369.15 368.49 369.32 369.03 369.72 370.13 370.16 370.23 370.27 370.31 370.72 370.85 370.75 370.87 370.93 370.87 371.15 371.39 371.61 371.64 371.81 372.15 372.21 372.17 372.26 372.67 373.24 2002 2002 2002 2002 2002 2002 2003 2003 2003 2003 2003 2003 2003 2003 2003 2003 2003 2003 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 Jul-02 Aug-02 Sep-02 Oct-02 Nov-02 Dec-02 Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Jan-04 Feb-04 Mar-04 Apr-04 May-04 Jun-04 Jul-04 Aug-04 Sep-04 Oct-04 Nov-04 Dec-04 Jan-05 Feb-05 Mar-05 Apr-05 May-05 Jun-05 Jul-05 Aug-05 Sep-05 Oct-05 Nov-05 373.92 371.8 370.64 370.5 372.18 373.71 374.86 375.64 376.47 377.73 378.6 378.21 376.73 374.36 373.2 373.11 374.67 375.96 377.03 377.82 378.75 380.43 380.65 379.56 377.62 376.17 374.13 374.46 375.96 377.45 378.46 379.74 381.04 382.19 382.44 382.16 380.76 378.72 376.65 376.97 378.28 373.29 373.42 373.98 373.82 374.31 374.49 374.63 374.78 374.81 375.02 375.56 376 376.18 376.01 376.5 376.44 376.84 376.77 376.81 376.97 377.1 377.66 377.52 377.28 377.05 377.86 377.5 377.8 378.15 378.3 378.21 378.94 379.55 379.53 379.3 379.84 380.15 380.37 379.97 380.27 380.44 200 ...
Purchase answer to see full attachment

Tutor Answer

ProfessorBond
School: Purdue University

Hey I have uploaded some one year graphs (into your excel file) that help with question 2. Also the questions 1 and 2 answered as described above. If you need anything else just let me know :)

Why was the seasonally corrected data used for the one year plots instead of the raw CO 2
data? Specifically, how would using the raw data have affected the trend line?
The seasonally corrected data is used for the one year plots in order to remove seasonal
trends observed year in effect creating a yearly baseline. For example, in the winter all the
leaves and branches that have fallen during the fall season are broken down by microbes and
slowly releasing CO2 into the atmosphere. During the spring, the trees grow their leaves back
and begin the process of photosynthesis drawing in CO2 from the atmosphere and lowering the
CO2 levels. Using the uncorrected seasonal data would case spikes in CO2 levels in the winter
and decreases in the spring overall having a graph that has a jagged shape.
Are the CO2 concentration predictions based on the one-year frames that you calculated
above similar to each other?
The CO2 from one-year frames at first glance look similar to each other (comparing
trend lines for multiple one year plots) . However, upon plotting multiple years one can see a
steady increase in CO2 levels. This is further proven by the yearly plots and comparing the trend
lines for the month of January of each year. We see that for years 1961, 1963, and 1965 we
have CO2 levels of approximate 317, 318, and 319 respectively.


Year Month Date
1958
1958
1958
1958
1958
1958
1958
1958
1958
1958
1959
1959
1959
1959
1959
1959
1959
1959
1959
1959
1959
1959
1960
1960
1960
1960
1960
1960
1960
1960
1960
1960
1960
1960
1961
1961
1961
1961
1961
1961

3
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6

Mar-58
Apr-58
May-58
Jun-58
Jul-58
Aug-58
Sep-58
Oct-58
Nov-58
Dec-58
Jan-59
Feb-59
Mar-59
Apr-59
May-59
Jun-59
Jul-59
Aug-59
Sep-59
Oct-59
Nov-59
Dec-59
Jan-60
Feb-60
Mar-60
Apr-60
May-60
Jun-60
Jul-60
Aug-60
Sep-60
Oct-60
Nov-60
Dec-60
Jan-61
Feb-61
Mar-61
Apr-61
May-61
Jun-61

CO2 (ppm) Seasonally Corrected CO2 Trend (ppm)
315,71
317,45
317,5
317,1
315,86
314,93
313,2
312,66
313,33
314,67
315,62
316,38
316,71
317,72
318,29
318,15
316,54
314,8
313,84
313,26
314,8
315,58
316,43
316,97
317,58
319,02
320,03
319,59
318,18
315,91
314,16
313,83
315
316,19
316,93
317,7
318,54
319,48
320,58
319,77

314,61
315,29
314,71
314,85
314,98
315,94
315,91
315,61
315,31
315,62
315,7
315,88
315,61
315,56
315,5
315,92
315,66
315,81
316,55
316,19
316,78
316,52
316,51
316,47
316,48
316,86
317,24
317,36
317,3
316,92
316,87
316,76
316,98
317,13
317,04
317,28
317,47
317,27
317,7
317,48

400

390

380

370

360

350

340

330

7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11

Jul-61
Aug-61
Sep-61
Oct-61
Nov-61
Dec-61
Jan-62
Feb-62
Mar-62
Apr-62
May-62
Jun-62
Jul-62
Aug-62
Sep-62
Oct-62
Nov-62
Dec-62
Jan-63
Feb-63
Mar-63
Apr-63
May-63
Jun-63
Jul-63
Aug-63
Sep-63
Oct-63
Nov-63
Dec-63
Jan-64
Feb-64
Mar-64
Apr-64
May-64
Jun-64
Jul-64
Aug-64
Sep-64
Oct-64
Nov-64

318,57
316,79
314,8
315,38
316,1
317,01
317,94
318,56
319,68
320,63
321,01
320,55
319,58
317,4
316,26
315,42
316,69
317,69
318,74
319,08
319,86
321,39
322,25
321,47
319,74
317,77
316,21
315,99
317,12
318,31
319,57
320,07
320,73
321,77
322,25
321,89
320,44
318,7
316,7
316,79
317,79

317,7
317,8
317,49
318,35
318,13
317,94
318,06
318,11
318,57
318,45
318,2
318,27
318,67
318,48
319,03
318,33
318,62
318,61
318,91
318,68
318,69
319,09
319,39
319,16
318,76
318,83
319,06
319
319,1
319,25
319,67
319,61
319,55
319,48
319,42
319,69
319,58
319,81
319,56
319,79
319,72

320

310

300

Mar-58

1961
1961
1961
1961
1961
1961
1962
1962
1962
1962
1962
1962
1962
1962
1962
1962
1962
1962
1963
1963
1963
1963
1963
1963
1963
1963
1963
1963
1963
1963
1964
1964
1964
1964
1964
1964
1964
1964
1964
1964
1964

1964
1965
1965
1965
1965
1965
1965
1965
1965
1965
1965
1965
1965
1966
1966
1966
1966
1966
1966
1966
1966
1966
1966
1966
1966
1967
1967
1967
1967
1967
1967
1967
1967
1967
1967
1967
1967
1968
1968
1968
1968

12
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
4

Dec-64
Jan-65
Feb-65
Mar-65
Apr-65
May-65
Jun-65
Jul-65
Aug-65
Sep-65
Oct-65
Nov-65
Dec-65
Jan-66
Feb-66
Mar-66
Apr-66
May-66
Jun-66
Jul-66
Aug-66
Sep-66
Oct-66
Nov-66
Dec-66
Jan-67
Feb-67
Mar-67
Apr-67
May-67
Jun-67
Jul-67
Aug-67
Sep-67
Oct-67
Nov-67
Dec-67
Jan-68
Feb-68
Mar-68
Apr-68

318,71
319,44
320,44
320,89
322,13
322,16
321,87
321,39
318,81
317,81
317,3
318,87
319,42
320,62
321,59
322,39
323,87
324,01
323,75
322,39
320,37
318,64
318,1
319,79
321,08
322,07
322,5
323,04
324,42
325
324,09
322,55
320,92
319,31
319,31
320,72
321,96
322,57
323,15
323,89
325,02

319,59
319,48
319,97
319,65
319,8
319,36
319,65
320,51
319,93
320,68
320,36
320,87
320,26
320,62
321,1
321,16
321,51
321,18
321,52
321,49
321,5
321,54
321,18
321,84
321,95
322,07
321,94
321,72
322,05
322,27
321,94
321,66
322,04
322,19
322,36
322,78
322,86
322,55
322,56
322,59
322,73

1968
1968
1968
1968
1968
1968
1968
1968
1969
1969
1969
1969
1969
1969
1969
1969
1969
1969
1...

flag Report DMCA
Review

Anonymous
The tutor managed to follow the requirements for my assignment and helped me understand the concepts on it.

Anonymous
The tutor was knowledgeable, will be using the service again.

Anonymous
Awesome quality of the tutor. They were helpful and accommodating given my needs.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors