EXCEL GRAPHING EXERCISE-CHEMISTRY

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	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Annual	Year
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	2000
1999	1.44	0.48	2.84	2.74	6.91	0.99	0.77	T	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	T	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	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Annual	Year
1975	3.34	3.72	1.67	3.40	6.88	1.95	5.06	0.30	0.87	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	T	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	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Annual	Year
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	T	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	T	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	T	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	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Annual	Year
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	T	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	T	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	T	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									0.29	1.59	1.42	2.70	NA	1898
Year	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Annual	Year

 

YOUR TASK FOR THIS GRAPHING EXERCISE INVOLVES THE FOLLOWING:

• 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.

 

• 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.

 

• 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.

 

Format for Laboratory Report

 

1. Title Page (leave Blank)

 

• The title of the experiment
• Your name
• Your instructor’s name
• The date the lab was performed or the date the report was submitted

2. Title

 

The title says what you did. It should be brief (aim for ten words or less) and describe the main point of the experiment or investigation. An example of a title would be: “Effects of Ultraviolet Light on Borax Crystal Growth Rate”. If you can, begin your title using a keyword rather than an article like ‘The’ or ‘A’.

 

3. Introduction / Purpose

 

Usually, the Introduction is one paragraph that explains the objectives or purpose of the lab. In one sentence, state the hypothesis. Sometimes an introduction may contain background information, briefly summarize how the experiment was performed, state the findings of the experiment, and list the conclusions of the investigation. Even if you don’t write a whole introduction, you need to state the purpose of the experiment, or why you did it. This would be where you state your hypothesis.

 

4. Materials

 

List everything needed to complete your experiment.

 

5. Methods

 

Describe the steps you completed during your investigation. This is your procedure. Be sufficiently detailed that anyone could read this section and duplicate your experiment. Write it as if you were giving direction for someone else to do the lab. It may be helpful to provide a Figure to diagram your experimental setup. DO NOT USE “I”, “YOU”, “WE”, “US” OR “THEY.”

 

6. Data

 

Numerical data obtained from your procedure usually is presented as a table. Data encompasses what you recorded when you conducted the experiment. It’s just the facts, not any interpretation of what they mean.

 

7. Results

 

Describe in words what the data means. Sometimes the Results section is combined with the Discussion (Results & Discussion).

 

8. Discussion or Analysis

 

Discuss the experiment and the results obtained. This does not mean you simply report the results again, but rather interpret and discuss their significance. Results should also be compared with those in the literature, if possible. (Be sure to give proper citations). If problems were encountered during the course of the experiment, how might they be rectified in the future? Are there any other things we could do to make this a better experiment or to more specifically address the initial question posed? Are there any better techniques available that would allow one to more accurately generate data? Is there more than one way to explain the results? Your results may support your initial hypothesis, but there may be more than one conclusion that could be drawn from your results. Lastly, do not spend enormous amounts of time explaining data that cannot be explained!

 

9. Conclusions

 

Most of the time the conclusion is a single paragraph that sums up what happened in the experiment, whether your hypothesis was accepted or rejected, and what this means.

 

10. Figures & Graphs

Graphs and figures must both be labeled with a descriptive title. Label the axes on a graph, being sure to include units of measurement. The independent variable is on the X-axis. The dependent variable (the one you are measuring) is on the Y-axis. Be sure to refer to figures and graphs in the text of your report. The first figure is Figure 1, the second figure is Figure 2, etc.

 

11. References

 

If your research was based on someone else’s work or if you cited facts that require documentation, then you should list these references.