Excel Homework

profileJcotto1990
HW_Rainfall_Data.xlsx
Home>Engineering homework help>Civil Engineering homework help>Excel Homework

Monthly Rainfall

Rainfall Data in inches, per year, from 1928 to 2011 in Miami Dade County, Florida
Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Tot Year
1928 2.25 2.84 1.29 6.01 4.28 3.1 8.53 3.4 8.5 7.52 6.85 4.75 59.34
1929 3.75 3.11 1.95 1.78 5.17 10.93 8.89 6.84 7.79 9.08 5.28 2.02 66.59
1930 1.69 1.92 0.48 3.28 5.33 9.73 6.18 6.65 6.31 8.74 3.77 0.65 54.74
1931 0.33 1.11 3.36 2.44 2.86 6.74 5.12 5.68 13.47 5.98 0.57 1.31 48.98
1932 1.49 0.9 3.81 5.02 2.54 5.84 5.17 5.16 9.49 6.36 0.92 1.77 48.46
1933 1.31 3.47 4.84 3.08 6.85 9.19 6.03 6.8 4.56 3.11 3.74 1.12 54.1
1934 1.62 2.79 1.23 4.92 6.89 4.75 10.57 4.52 9.03 5.17 4.48 1.26 57.23
1935 0.49 2.58 5.3 1.1 4.55 1.93 5.15 3.97 1.8 15.7 1.93 0.7 45.19
1936 1.32 1.47 0.33 1.67 8.34 9.26 7.84 8.39 12.27 15.04 3.71 1.22 70.85
1937 0.33 1.05 1.14 3.88 10.68 10.25 7.42 7.97 6.24 3.39 0.61 1.1 54.06
1938 4.09 1.93 1.44 3.79 3.45 5.36 8.13 5.07 7.91 16.3 0.63 0.59 58.66
1939 5.26 1.76 3.29 3.18 11.45 6.22 4.43 9.65 3.08 1.49 5.47 2.57 57.84
1940 5.07 0.82 0.81 3.46 4.13 8.23 11.34 8.96 9.25 5.66 1.91 0.49 60.12
1941 0.75 2.55 1.55 3.07 1.53 5.63 7.51 7.88 8.17 6.16 0.97 0.71 46.46
1942 0.54 1.37 2.64 1.7 4.27 7.73 7.13 12.76 14.55 3.62 1.19 1.23 58.74
1943 1.48 0.64 2.01 2.42 5.67 8.17 7.92 6.63 13.99 8.5 1.96 2.9 62.3
1944 2.34 3.29 5.07 5.13 6.61 17.35 4.77 6.6 7.97 5.93 1.33 2.23 68.61
1945 3.82 1.74 5.21 5.64 3.37 2.16 3.76 5.54 10.49 4.93 1.23 1.23 49.12
1946 1.85 1.2 1.93 1.71 9.86 10.17 3.21 12.82 6.46 6.9 5.88 0.47 62.47
1947 1.07 0.91 3.27 5.68 3.47 6.53 11.02 9 6.37 10.88 2.26 0.27 60.74
1948 1.07 2.86 3.11 3.8 12.32 8.13 6.43 7.08 9.13 2.92 1.03 0.67 58.55
1949 1.08 1.2 0.39 5.98 2.51 8.01 7.92 5.5 14.03 6.43 1.94 1.54 56.54
1950 2.43 4.29 3.86 1.33 6.42 19.14 6.58 7.87 5.71 4.49 3.09 1.64 66.84
1951 1.86 2.33 4.88 3.22 3.65 7.94 6.05 7.39 10.2 5.95 2.38 0.51 56.37
1952 1.29 1.21 1.29 0.42 4.85 6.25 9.12 2.37 6.5 3.8 2.68 0.91 40.68
1953 0.78 0.52 1.05 2.83 5.73 7 8.72 9.16 6.22 8.8 1.27 1.61 53.7
1954 2.59 2.86 3.74 1.55 3.65 8.83 5.69 8.95 14.94 2.42 0.54 5.05 60.83
1955 4.51 4.55 4.22 6.36 1.8 7.46 11.03 4.3 8.24 5.06 3.39 1.36 62.27
1956 2.44 2.59 3.44 5.63 5.03 14.41 3.15 4.9 6.59 1.89 1.17 2.08 53.3
1957 1.04 0.58 1.69 2.55 5.57 6.16 8.18 6.88 6.97 4.49 2.73 0.45 47.28
1958 1.07 0.07 1.87 2.09 5.1 4.23 8.31 7.51 5.01 6.49 0.25 0.56 42.56
1959 1.93 0.75 0.58 2.13 2.01 6.4 9.07 7.12 11.3 5.85 1.67 1.38 50.19
1960 1.01 1.2 2.14 0.54 7.55 7.31 8.08 6.43 7.83 2.39 3.55 2.15 50.17
1961 1.3 2.22 5.86 3.96 4.84 13.88 10.8 8.22 13.69 12.97 3.88 1.56 83.2
1962 3.2 0.34 1.11 4.58 3.51 3.25 7.01 8.37 19.17 7.25 0.69 0.8 59.27
1963 0.17 0.55 0.77 3.12 4.38 9.72 8.83 9.12 10.02 4.47 1.72 4.18 57.05
1964 0.34 0.95 1.83 2.65 3.72 3.46 7.29 8.96 5.6 9.38 1.6 1.66 47.43
1965 0.34 1.92 0.66 4.58 2.81 4.19 9.26 6.83 5.71 7.91 1.11 0.28 45.61
1966 1.01 4.09 2.2 1.52 4.75 4.37 7.75 8.1 7.24 10.98 0.6 0.73 53.34
1967 3.17 2.05 2.05 3.96 2.07 10.03 8.73 9.13 12.09 8.81 1.65 1.48 65.24
1968 0.52 2.13 2.95 6.11 8.32 11.54 8.91 6.57 9.39 3.56 2.72 1.02 63.73
1969 1.22 0.92 1.26 2.14 4.46 12.69 6.26 5.37 6.63 3.33 0.76 2.39 47.44
1970 1.13 0.9 0.52 2.41 3.22 5.17 5.26 7.66 6.38 7.12 0.49 0.43 40.69
1971 2.4 4.79 3.02 5.92 7.2 6 8.01 9.01 8.85 5.38 1.4 5.4 67.37
1972 7.33 1.05 7.19 2.32 10.04 7.18 6.5 6.37 6.04 4.6 1.45 4.92 65
1973 1.99 1.12 5.8 2.02 7.48 13.75 8.08 7.64 9.06 10 5.28 1.31 73.54
1974 0.32 2.96 1.97 5.66 4.65 8.02 9.47 8.11 16.7 6.12 2.12 0.57 66.68
1975 2.79 0.78 1.7 1.23 7.91 5.66 4.86 6.95 3.16 3.47 1.01 0.23 39.75
1976 1.35 0.62 3.12 1.86 2.87 11.93 7.18 7.05 10.04 2.51 1.88 0.48 50.9
1977 1.1 4.17 0.71 0.64 6.84 6.34 3.52 7.1 10.49 3.13 2.54 3.96 50.54
1978 1.63 2.52 1.44 3.51 4.13 9.58 6.08 8.64 6.24 7.69 1.6 2.16 55.22
1979 0.7 3.6 2.02 1.2 1.46 8.22 7.82 6.5 7.78 9.79 1.49 0.85 51.42
1980 4.1 2.73 1.26 2.69 5.62 15.85 9.11 6.58 7.68 5.96 0.61 0.68 62.88
1981 1.64 2.48 1.47 0.13 1.71 13.04 6.48 5.51 7.83 6.59 1.2 1.86 49.95
1982 0.92 2.62 1.27 0.7 11.86 15.4 7.2 6.12 8.25 7.52 1.83 0.14 63.83
1983 2.73 1.91 4.13 2.74 5.86 13.68 6.38 7.38 7.41 11.11 3.05 1.57 67.96
1984 3.46 2.36 9.32 0.31 6.06 8 6.87 5.47 5.44 4.61 0.17 0.22 52.3
1985 0.66 1.33 0.59 0.36 4.86 8.62 6.4 6.92 7.91 6.24 2.43 1.92 48.25
1986 1.33 2.49 2.78 4.27 6.84 9.65 5.73 5.53 3.96 2.29 3.79 1.68 50.35
1987 2.53 1.95 2.87 1.02 2.9 8.21 9.26 9.54 7.4 3.32 0.96 2.33 52.3
1988 1.9 0.3 0.54 1.2 3.7 11.01 9.87 7.6 5.92 2.34 2.41 1.24 48.03
1989 0.38 1.09 0.69 1.07 7.86 8.58 7.62 4.61 8.69 3.87 0.99 0.5 45.96
1990 0.69 2.76 1.07 1.87 10.36 8.43 4.71 8.84 7.03 1.71 2.03 2.13 51.62
1991 3 1 0.53 0.91 6.78 7.2 5.54 7.31 9.35 1.19 3.82 3.59 50.23
1992 3.04 3.86 3.03 2.49 5.38 8.33 8.04 6.72 6.04 4.68 2.85 3.31 57.76
1993 4.56 0.51 1.13 5.08 6.26 4.7 4.65 10.45 10.64 3.05 2.74 2.75 56.53
1994 3.22 1.53 2 4.74 4.18 4.61 6.03 6.68 5.11 2.12 4.09 1.1 45.41
1995 0.67 3.01 1.3 0.16 2.89 4.93 5.74 13.67 7.43 1.91 2.15 0.25 44.09
1996 0.55 1.81 4.54 4.14 7.9 13.32 6.8 5.83 7.25 4.65 3.63 0.97 61.38
1997 5.69 8.81 4.72 2.6 1.85 10.41 5.49 7.79 7.95 5.63 2 3.97 66.91
1998 0.54 2.32 4.55 2.29 8.37 5.39 7.85 5.48 7.18 1.33 3.54 0.47 49.3
1999 0.62 0.25 2.16 3.9 3.71 6.64 11.54 6.25 7.99 3.79 1.74 2.17 50.75
2000 2.66 1.33 5.5 0.76 2.58 12.39 5.51 7.37 4.37 4.06 2.01 3.88 52.43
2001 1.89 1.8 5.84 1.11 3.57 4.4 5.58 4.33 8.94 5.43 6.15 1.07 50.11
2002 2.24 1.81 2.15 1.68 4.82 8.28 9.31 11.05 2.69 1.51 2.49 0.66 48.71
2003 1 0.45 2.24 3.91 2.56 5.97 6.54 7.85 6.35 3.48 1.17 1.57 43.11
2004 0.9 1.72 1.58 3.04 5.5 6.19 7.23 9.21 4.59 3.63 1.04 0.89 45.53
2005 5.65 2.51 4.06 5.68 7.36 8.8 8.61 7.21 6.36 6.04 2.18 0.94 65.41
2006 1.63 3.18 2.14 3.53 1.2 16.66 3.58 10.2 5.12 1.66 5.13 0.61 54.64
2007 6.72 1.88 3.85 2.73 4.2 5.33 5.92 5.97 6.4 7.23 1.49 0.8 52.52
2008 3.32 3.48 2.32 3.61 3.94 7.57 6.08 8.42 10.26 6.14 7.7 6.47 69.29
2009 3.29 1.93 2.42 2.76 3.56 11.24 8.35 11.32 7.19 11.03 0.84 0.9 64.84
2010 1.85 0.69 3.83 2.21 8.41 10.22 4.14 6.48 5.05 7.04 0.98 0.93 51.84
2011 2.13 1.83 2.61 4.96 4.91 11.16 6.88 7.79 7.9 1.27 3.66 5.71 60.82

Sheet2