EXCEL GRAPHING EXERCISE-CHEMISTRY
THE FOLLOWING SHOULD BE DONE WITH EXCEL GRAPHING PROGRAM:
THIS A COMPILATION OF MONTHLY AND ANNUAL PRECIPITATION FOR THE DALLAS- WORTH AREA FOR
THE YEARS OF 1898 TO 2016 FEBRUARY. Dallas/Fort Worth - Monthly and Annual Precipitation
See note below concerning the following information Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Annual Year 2016 1.04 2.20 2016 2015 3.62 2.96 2.53 5.56 16.96 3.95 0.92 0.46 2.14 9.82 9.86 3.83 62.61 2015 2014 0.33 0.41 1.45 1.74 3.40 3.26 0.98 4.34 0.06 2.09 2.13 1.13 21.32 2014 2013 4.06 1.68 2.27 1.98 3.17 2.14 2.05 1.32 2.72 3.13 2.12 2.76 29.40 2013 2012 6.18 1.88 5.74 4.24 1.66 2.82 0.78 3.19 1.75 1.02 0.05 1.95 31.26 2012 2011 1.60 0.92 0.07 2.46 7.95 2.84 0.09 0.96 0.66 3.12 0.86 4.35 25.88 2011 2010 2.76 2.83 3.57 2.03 1.09 2.08 3.13 0.41 9.09 1.16 1.50 2.05 31.70 2010 2009 0.82 0.72 5.56 3.54 4.36 3.98 2.09 1.64 6.52 8.05 1.76 1.85 40.89 2009 2008 0.27 2.30 6.07 3.85 2.21 0.84 0.81 2.82 0.84 2.29 4.53 0.27 27.10 2008 2007 5.58 0.43 3.81 2.82 8.34 11.10 5.54 0.35 4.99 3.53 1.22 2.34 50.05 2007 2006 2.25 3.85 4.40 1.86 1.90 0.34 1.78 0.52 2.60 4.34 2.58 3.33 29.75 2006 2005 4.33 1.62 2.17 0.56 3.35 1.14 0.74 2.46 1.36 0.89 0.02 0.33 18.97 2005 2004 3.04 3.84 1.71 2.96 4.73 10.49 4.16 4.24 1.02 5.72 5.01 0.65 47.57 2004 2003 0.22 3.07 0.85 1.90 2.53 5.17 0.08 1.85 3.99 0.78 3.15 0.96 24.55 2003 2002 4.90 0.94 7.39 5.68 5.40 3.10 3.07 1.47 1.38 6.44 0.52 4.13 44.42 2002 2001 2.44 6.17 5.27 0.89 5.58 1.28 3.85 2.72 3.72 1.87 1.11 3.24 38.14 2001 Year Year Jan Feb Mar Apr May Jun Jul Aug 2000 1.59 3.30 2.91 4.28 3.17 5.93 T 0.00 0.17 4.38 6.95 3.57 36.26 1999 1.44 0.48 2.84 2.74 6.91 0.99 0.77 T Sep Oct Nov Dec Annual 2000 2.30 2.26 0.31 2.55 23.59 1999 1998 5.07 3.22 4.45 1.25 2.38 1.75 0.11 0.35 0.68 5.64 4.91 4.43 34.24 1998 1997 0.33 7.40 2.21 6.73 3.92 3.99 1.68 3.13 2.01 5.66 1.01 6.93 45.00 1997 1996 0.97 0.35 2.36 2.14 0.95 3.42 3.85 5.02 1.51 6.56 5.54 0.47 33.14 1996 1995 2.11 0.44 6.69 6.83 7.50 2.41 3.45 0.86 1.54 0.75 0.74 2.07 35.39 1995 1994 1.43 2.01 1.69 3.62 5.80 2.05 4.58 4.89 1.39 8.19 6.03 2.42 44.10 1994 1993 1.74 5.78 3.03 3.49 1.75 3.75 0.00 0.75 3.28 5.10 1.62 2.54 32.83 1993 1992 3.25 2.40 3.24 2.46 6.93 5.23 2.48 2.08 3.25 3.05 3.56 4.26 42.19 1992 1991 2.72 2.60 1.35 3.63 6.97 4.26 3.99 4.30 4.61 9.32 1.04 8.75 53.54 1991 1990 4.54 4.72 5.89 6.90 7.16 1.89 2.60 2.37 1.12 2.81 3.81 1.46 45.27 1990 1989 2.56 3.70 3.72 1.86 9.62 8.75 2.61 1.89 2.40 2.02 0.49 0.33 39.95 1989 1988 0.88 1.23 2.03 2.21 2.11 3.23 2.47 0.44 4.04 1.64 2.28 2.48 25.04 1988 1987 1.22 3.67 1.70 0.11 5.95 3.45 1.77 0.81 1.38 0.12 4.17 2.90 27.25 1987 1986 T 2.49 1.08 5.30 5.52 3.92 0.41 1.63 4.60 1.81 3.25 2.44 32.45 1986 1985 0.81 2.62 3.70 3.75 2.13 3.78 2.40 0.53 3.35 3.91 3.11 0.61 30.70 1985 1984 1.07 3.11 4.92 1.41 3.04 2.79 0.43 1.47 0.09 6.50 2.97 6.09 33.89 1984 1983 2.55 1.25 4.36 0.59 5.83 2.07 1.56 5.55 0.22 4.04 2.22 0.83 31.07 1983 1982 2.33 1.89 1.71 2.71 13.66 4.28 2.73 0.52 0.58 3.36 4.22 2.76 40.75 1982 1981 0.58 1.44 3.39 2.69 6.24 7.85 1.81 2.32 2.40 14.18 1.53 0.17 44.60 1981 1980 2.52 0.84 1.24 2.23 3.01 1.25 0.71 6.54 1.08 1.23 1.43 22.08 1980 1979 3.35 1.52 6.33 2.03 5.90 1.36 1.94 2.47 0.99 3.38 0.43 2.72 32.42 1979 1978 1.41 3.33 2.66 1.34 8.01 0.77 0.33 1.53 0.93 0.55 2.73 0.78 24.37 1978 1977 2.39 1.68 5.88 4.31 0.99 0.69 2.20 2.33 1.72 2.96 1.79 0.25 27.19 1977 1976 0.13 0.52 2.29 5.71 6.03 1.40 3.83 4.75 5.02 3.46 0.50 1.99 35.63 1976 Year Year Jan Feb Mar Apr May Jun Jul T Aug Sep 1975 3.34 3.72 1.67 3.40 6.88 1.95 5.06 0.30 0.87 Oct Nov Dec Annual
T 0.42 1.49 29.10 1975 1974 1.79 1.01 0.80 2.51 6.00 5.44 0.67 4.19 6.04 5.93 3.32 1.93 39.63 1974 1973 3.26 1.92 2.28 6.06 3.18 5.88 11.13 0.01 7.16 6.85 2.06 0.83 50.62 1973 1972 1.09 0.26 0.10 3.25 2.35 1.50 0.59 0.81 2.42 6.89 2.36 0.61 22.23 1972 1971 0.19 1.32 0.34 2.76 1.88 0.83 3.60 5.70 3.24 7.64 1.77 6.99 36.26 1971 1970 0.72 4.78 3.49 4.68 3.62 0.61 0.94 6.85 6.25 2.95 0.20 1.01 36.10 1970 1969 1.26 1.99 3.62 3.40 7.12 0.63 0.77 2.56 4.55 5.82 1.22 2.75 35.69 1969 1968 3.60 1.48 6.39 2.41 6.02 3.50 1.88 2.71 2.53 2.18 4.58 1.20 38.48 1968 1967 0.28 0.32 2.09 3.84 4.02 0.72 2.20 0.48 5.94 4.19 0.92 2.30 27.30 1967 1966 1.68 2.84 1.38 10.74 3.13 5.47 3.26 3.38 4.23 1.48 0.53 1.17 39.29 1966 1965 2.77 6.20 1.45 2.15 8.97 1.50 0.09 2.26 5.04 1.97 2.43 1.73 36.56 1965 1964 3.53 1.17 3.35 2.71 2.85 0.40 0.25 2.43 9.52 0.62 6.23 1.25 34.31 1964 1963 0.86 0.15 0.48 6.20 2.52 0.57 2.28 2.73 1.70 0.23 1.29 1.45 20.46 1963 1962 1.00 2.01 1.80 5.66 1.58 6.94 6.36 3.22 3.79 4.15 3.93 0.99 41.43 1962 1961 3.29 2.20 2.95 2.23 1.06 5.93 2.32 0.02 2.92 2.82 2.72 2.12 30.58 1961 1960 2.29 2.16 0.74 1.67 1.89 1.72 3.96 2.76 1.25 1.82 0.49 4.22 24.97 1960 1959 0.36 1.61 2.31 0.92 3.27 5.27 3.27 0.93 2.40 9.22 1.74 2.84 34.14 1959 1958 1.70 0.84 5.49 8.63 1.50 0.67 3.69 3.64 5.10 1.07 2.26 1.09 35.68 1958 1957 1.72 1.77 4.18 12.19 12.64 3.96 0.65 0.12 3.23 3.53 4.72 1.78 50.49 1957 1956 1.34 2.54 0.11 3.12 3.83 0.88 0.38 0.23 0.23 1.20 2.61 2.08 18.55 1956 1955 1.17 2.01 2.15 1.94 6.58 4.99 0.64 1.00 3.68 0.20 0.59 0.21 25.16 1955 1954 2.08 0.73 0.66 3.62 4.38 1.20 0.24 0.81 1.46 2.35 1.24 0.78 19.55 1954 1953 0.54 1.34 2.52 4.82 3.55 0.55 0.97 1.09 1.68 4.27 2.09 1.32 24.74 1953 1952 0.58 1.12 1.39 6.51 3.21 0.56 0.44 0.54 0.01 5.84 2.49 22.69 1952 1951 1.39 2.42 1.33 2.27 4.60 4.12 2.22 0.47 1.84 1.62 1.00 0.09 23.37 1951 Year Year T Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Annual 1950 5.01 2.47 1.58 4.73 6.16 3.16 4.53 3.05 3.21 0.30 0.02 T 34.22 1950 1949 5.45 4.75 3.69 2.47 10.64 3.52 0.10 2.27 3.13 6.50 0.09 1.04 43.65 1949 1948 0.96 4.12 1.07 1.11 4.34 2.46 1.93 0.90 0.19 2.09 0.50 0.44 20.11 1948 1947 1.21 0.55 2.92 2.98 2.50 4.08 0.10 4.18 2.81 2.14 2.23 4.50 30.20 1947 1946 2.79 2.93 2.80 2.49 12.09 0.65 0.90 6.84 2.69 1.31 6.50 3.40 45.39 1946 1945 1.92 6.96 6.19 2.87 1.81 4.12 3.07 0.62 2.17 2.31 1.13 0.55 33.72 1945 1944 2.58 4.81 1.30 2.70 6.42 0.76 2.52 2.65 0.80 2.53 3.82 3.60 34.49 1944 1943 0.20 0.51 4.05 1.63 7.83 3.93 0.73 7.31 0.73 0.51 3.32 30.75 1943 1942 0.39 0.64 1.37 16.97 2.85 3.23 0.62 4.69 3.82 6.18 0.92 1.59 43.27 1942 1941 1.45 3.42 1.52 3.52 2.02 7.12 1.49 2.71 1.28 3.68 1.08 1.88 31.17 1941 1940 0.59 2.00 0.40 5.97 7.15 7.30 2.86 2.16 0.68 1.47 6.35 4.72 41.65 1940 1939 2.66 2.42 1.64 1.48 2.54 4.04 2.02 1.44 0.12 0.55 2.72 0.68 22.31 1939 1938 2.74 4.57 3.89 3.03 2.80 1.61 2.16 0.11 0.78 0.11 1.17 1.26 24.23 1938 1937 1.71 0.30 3.88 0.58 1.00 5.74 1.93 1.02 0.32 3.55 4.39 5.31 29.73 1937 1936 0.67 0.45 0.63 0.99 9.48 0.03 2.35 0.23 7.30 3.72 0.46 1.84 28.15 1936 1935 3.70 3.29 1.40 3.06 9.15 7.22 0.89 0.70 3.61 4.01 1.65 2.26 40.94 1935 1934 1.86 1.67 4.26 2.39 0.82 0.08 0.13 4.90 0.12 2.30 0.56 19.09 1934 1933 1.96 2.47 2.18 1.57 4.67 0.03 5.70 2.25 4.94 1.24 0.66 2.13 29.80 1933 1932 9.07 4.92 0.63 3.43 6.03 3.04 2.07 2.92 10.80 1.66 1.56 4.90 51.03 1932 1931 1.79 2.84 4.20 1.97 2.42 2.43 0.44 3.38 1.25 3.39 2.78 2.73 29.62 1931 1930 0.84 1.08 2.86 2.37 10.37 1.87 0.37 3.12 1.19 7.96 1.71 2.08 35.82 1930 1929 2.08 2.78 1.39 2.06 5.83 0.20 0.43 2.29 2.12 1.50 0.41 21.09 1929 1928 0.46 3.53 1.10 5.70 3.77 11.58 4.24 2.13 0.45 4.15 1.97 5.50 44.58 1928 1927 1.45 1.77 2.19 3.66 0.44 3.33 1.53 0.80 4.00 4.47 0.58 2.59 26.81 1927 1926 4.04 0.08 3.60 3.73 3.79 3.32 4.13 4.39 1.41 3.16 0.73 3.03 35.41 1926 Year Year T Jan Feb Mar Apr May Jun Jul T T Aug Sep Oct Nov Dec Annual 1925 1.44 0.74 0.02 3.59 8.11 0.29 0.98 0.40 1.79 3.77 2.05 0.04 23.22 1925 1924 0.89 1.97 4.66 2.33 4.00 1.25 0.96 3.77 3.78 1.60 1.23 26.44 1924 1923 4.60 2.05 1.52 5.30 0.54 6.74 0.99 1.68 2.06 6.05 1.63 4.68 37.84 1923 1922 1.63 2.00 1.57 17.64 4.58 1.76 1.35 0.52 0.41 2.33 2.57 0.06 36.42 1922 1921 2.87 2.62 2.67 1.99 1.04 2.63 1.14 0.95 0.11 0.31 1.24 0.34 17.91 1921 1920 3.48 0.76 4.42 0.51 8.66 2.33 3.49 4.22 2.76 6.52 1.70 1.31 40.16 1920

1919 3.03 2.03 3.34 2.06 3.99 3.72 5.25 5.00 4.12 9.44 3.32 0.44 45.74 1919 1918 1.36 0.01 0.93 6.21 1.99 5.16 1.10 0.29 2.09 3.31 7.94 4.08 34.47 1918 1917 1.43 1.47 2.42 4.11 3.92 1.97 2.65 1.92 2.41 0.17 1.35 0.05 23.87 1917 1916 4.01 0.01 3.68 6.99 3.70 3.30 1.38 3.84 0.73 1.89 1.82 0.11 31.46 1916 1915 1.32 2.18 1.40 4.98 2.49 6.88 0.30 10.33 1.62 2.58 0.29 1.99 36.36 1915 1914 0.43 1.17 2.89 5.99 10.71 2.97 0.73 9.02 1.61 0.28 6.44 4.40 46.64 1914 1913 2.30 0.87 1.04 2.47 2.74 3.03 4.36 7.29 2.28 5.90 5.42 37.70 1913 1912 0.17 1.22 3.34 3.20 2.71 4.26 0.27 6.56 0.83 1.51 0.33 1.95 26.35 1912 1911 0.21 3.84 1.87 3.33 0.22 0.43 6.26 2.39 1.38 0.99 1.05 5.06 27.03 1911 1910 1.36 1.14 1.02 2.65 5.76 1.38 0.14 0.26 2.21 0.68 0.14 1.23 17.97 1910 1909 0.09 0.11 0.41 1.66 1.09 2.97 0.02 2.38 2.08 2.20 5.11 2.81 20.93 1909 1908 0.96 2.45 2.95 9.63 10.69 2.90 2.66 2.74 3.52 4.49 2.05 0.03 45.07 1908 1907 0.51 1.90 0.70 1.31 6.53 2.22 4.15 0.29 1.92 3.01 5.81 2.18 30.53 1907 1906 0.93 2.08 1.99 2.56 8.24 4.13 2.56 4.98 4.16 0.91 2.19 1.22 35.95 1906 1905 1.52 1.93 3.39 7.73 5.45 2.69 8.35 0.56 0.83 4.21 3.19 3.60 43.45 1905 1904 1.30 1.79 4.01 2.21 3.86 5.42 2.15 3.26 2.63 5.29 0.02 0.36 32.30 1904 1903 1.83 5.07 2.03 0.59 1.84 4.84 1.84 1.57 2.70 4.53 0.00 0.30 27.14 1903 1902 0.42 0.36 3.80 1.81 4.31 0.58 6.29 2.40 1.40 6.89 1.05 29.31 1902 1901 0.08 1.59 1.57 2.04 4.50 0.33 1.99 1.29 1.67 1.90 2.10 0.59 19.65 1901 1900 0.70 0.12 0.73 7.34 6.58 0.84 5.90 1.43 9.12 3.22 0.56 0.35 36.89 1900 1899 1.24 0.21 0.32 2.32 2.01 2.78 1.66 0.02 1.02 1.49 3.06 1.98 18.11 1899 1898 1898 Year T T T 0.29 1.59 1.42 2.70
Jan Feb Mar Apr May Jun Jul Aug Sep NA Oct Nov Dec Annual Year YOUR TASK FOR THIS GRAPHING EXERCISE INVOLVES THE FOLLOWING:
1) ON THE EXCEL GRAPHING PROGAM, PLOT A GRAPH COMPARING THE FOLLOWING YEARS OF
PRECIPITATION: 1899, 1950 & 2015. IN THIS GRAPH SHOW THE BEST STRAIGHT LINE FOR EACH
YEAR, AND PROPOSE A CONCLUSION TO THE DATA ON THE BASIS OF RAINFALL, WHETHER THERE IS AN INCREASE, DECREASE OR NO CHANGE. COMMENT ON IF THERE WERE RAINIER MONTHS
THAN OTHERS.
2) ON GRAPHING PAPER USING A PENCIL, PLOT THE GRAPH COMPARING THE FOLLOWING YEARS
OF PRECIPITATION: 1920, 1970 AND 1990. IN THIS GRAPH ALSO SHOW THE BEST STRAIGHT LINE
FOR EACH YEAR BY YOUR GUESTIMATION, AND PROPOSE A CONCLUSION TO THE DATA ON THE
BASIS OF RAINFALL, WHETHER THERE IS AN INCREASE, DECREASE OR NO CHANGE. COMMENT
ON IF THERE WERE RAINIER MONTHS THAN OTHERS.
3) AFTERWARDS, COMMENT IN YOUR CONCLUSION SECTION ON WHICH TECHNIQUE (EXCEL
GRAPHING VS. PENCIL AND GRAPH PAPER) WAS THE EASIEST TO USE, WHICH WAS THE MOST
ACCURATE, WHICH YOU LEARNED THE MOST FROM AND, COMPARING EXCEL GRAPHING DATA
TO PENCIL-GRAPHING PAPER DATA, WHETHER THERE WAS AN INCREASE, DECREASE OR NO
CHANGE IN PRECIPITATION TOTALS FORM EACH GRAPH.
Please report all information according to the laboratory format. Have fun!