HELP CHEMISTRY

looni
EXCELGRAPHINGEXERCISEDATA.docx

EXCEL GRAPHING EXERCISE-CHEMISTRY 1406

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:

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!