Ref www phdcomics com Note Only use Excel Functions for all computations Problem 1 (50 Points) Illinois Temp contains temperature data for Northern Illinois from 1895 to 1998 a Compute the Average Temperature for each year (Fill Column N) b Convert the Data available into a Table and choose a Design of your choice c Obtain the Mean, Median, Standard Deviation, Variance, Quartiles (Q1, Q2, Q3, Q4), IQR for the entire data (1895 1998), using ONLY Excel Functions (not using the Analysis Tool Pak Add In)the data on the temperatures, not the years All the temperatures on the data sheet d Use the Statistical measurements generated from the Analysis Toolpak (Add In) and compare the values obtained in (d) Comment on your findings e Identify the Outliers in the data, if any Comment on your findings f Record a Macro titled 'Filter over25' with a Keyboard Shortcut Ctrl Shift D' The Macro should be able to filter temperatures that are above 25 degrees Hint Record a macro for one month (one column) Note You will now be required to save the file with a xlsm extension g Test the Macro for every Month h Lastly, include a Form control button (titled appropriately), that allows any end user to run the Macro defined in (f) by the click of this button Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Average Temp 1895 16 4 14 9 32 9 53 2 60 2 72 9 72 0 72 6 67 6 46 2 35 7 29 5 47 84 1896 25 8 25 4 31 2 54 3 66 3 69 6 73 2 72 3 60 5 48 3 37 0 32 1 49 67 1897 21 7 27 5 34 6 46 1 55 4 67 3 75 5 69 2 68 7 57 6 36 8 23 4 48 65 1898 26 8 26 0 39 8 46 7 57 9 70 7 74 0 71 6 66 7 49 9 35 6 22 8 49 04 1899 21 9 15 6 29 1 50 9 59 6 70 7 73 4 73 9 62 4 56 3 43 3 26 2 48 61 1900 28 0 18 7 29 3 49 6 60 4 68 0 72 8 77 4 65 9 59 9 37 0 28 4 49 62 1901 25 1 17 2 34 4 46 8 57 8 71 3 78 7 72 7 64 4 53 7 34 8 22 3 48 27 1902 23 8 17 9 39 7 46 6 62 8 65 3 74 0 68 6 60 7 53 7 45 4 24 1 48 55 1903 22 3 23 8 41 8 48 3 61 9 63 8 73 2 69 1 63 6 52 4 34 6 19 1 47 83 1904 14 4 15 6 34 1 43 0 59 0 67 1 71 1 67 8 63 8 52 2 40 0 24 9 46 08 1905 17 0 15 2 39 6 47 3 58 7 68 1 71 6 72 9 66 3 51 7 38 2 28 6 47 93 1906 28 3 23 3 27 7 50 5 59 8 67 9 72 1 74 5 68 3 51 6 37 8 28 8 49 22 1907 25 9 24 9 41 3 39 5 51 4 65 9 72 8 69 9 62 8 49 7 36 7 30 0 47 57 1908 25 2 24 0 38 7 47 6 58 5 68 1 73 6 71 4 68 4 53 4 40 1 28 1 49 76 1909 24 1 28 6 34 7 44 8 56 0 69 1 71 2 74 9 62 4 48 1 46 2 18 6 48 23 1910 21 5 21 2 46 9 50 6 54 0 68 3 74 5 71 3 63 3 55 5 33 7 23 1 48 66 1911 24 9 29 8 36 9 45 8 64 9 72 4 74 1 70 6 65 4 50 4 32 7 31 6 49 96 1912 7 4 17 9 26 4 49 1 60 5 66 1 72 9 69 4 65 7 53 7 39 7 30 9 46 64 1913 25 7 34 3 32 7 48 2 58 5 71 2 75 0 74 6 64 4 51 3 44 2 34 4 51 21 1914 29 7 15 9 33 7 48 2 61 6 70 6 76 1 73 1 64 1 56 4 40 6 20 0 49 17 1915 18 3 31 8 33 1 54 6 54 9 64 5 70 4 65 9 65 9 53 4 41 4 26 0 48 35 1916 26 0 21 4 31 4 46 8 59 3 63 3 78 9 74 7 62 6 52 1 39 7 22 7 48 24 1917 21 9 17 2 37 1 44 8 52 9 64 6 72 8 69 5 62 0 43 6 39 8 18 0 45 35 1918 9 3 24 6 41 9 43 9 63 2 67 7 71 2 75 2 57 7 54 7 40 7 35 1 48 77 1919 28 5 28 1 38 1 49 2 56 3 73 8 76 2 71 2 67 2 54 0 36 5 18 5 49 80 1920 15 8 23 8 37 9 42 7 57 3 69 7 71 6 70 6 67 4 59 2 37 9 29 8 48 64 1921 30 6 31 4 44 4 52 8 62 0 74 4 79 2 71 7 68 3 53 3 37 5 29 5 52 93 1922 21 6 26 9 38 5 49 1 62 9 70 5 72 3 72 8 67 4 55 5 41 9 26 5 50 49 1923 27 7 19 7 31 6 46 6 57 0 71 3 74 7 70 5 63 8 49 7 41 1 37 3 49 25 1924 16 9 26 0 33 2 49 4 53 2 66 2 69 9 70 7 59 3 57 7 39 4 19 9 46 82 1925 22 6 30 3 38 9 54 3 55 8 71 4 73 1 72 4 69 3 43 3 36 3 23 1 49 23 1926 25 5 29 2 30 0 42 2 61 0 64 6 74 0 72 9 63 9 50 7 34 5 24 0 47 71 1927 21 0 33 1 41 0 47 6 56 5 64 8 72 1 67 4 68 5 56 2 41 6 24 0 49 48 1928 24 8 28 5 36 1 44 0 59 6 63 8 75 8 72 8 60 4 54 5 40 6 30 7 49 30 1929 16 3 18 6 42 5 50 7 56 5 66 0 73 7 69 8 63 5 51 7 34 6 26 1 47 50 1930 17 4 33 7 36 2 50 4 61 0 69 6 75 8 73 9 66 6 51 3 40 6 27 9 50 37 1931 33 4 33 6 33 7 49 1 55 7 71 7 76 2 72 0 69 6 56 1 46 7 35 1 52 74 1932 31 3 32 3 28 1 47 1 60 4 70 5 74 3 72 1 62 1 51 1 34 0 25 7 49 08 1933 34 2 22 9 35 4 47 2 60 0 75 6 74 4 69 9 68 9 49 9 36 6 28 7 50 31 1934 29 7 21 1 32 0 48 7 65 3 75 0 77 6 72 2 62 6 54 5 43 3 23 1 50 43 1935 22 8 27 6 41 2 45 3 52 8 64 9 76 5 72 6 63 8 52 5 37 4 22 7 48 34 1936 15 6 11 6 38 9 44 1 63 9 67 2 78 9 75 8 66 2 51 4 35 5 31 2 48 36 1937 23 6 24 1 32 6 46 3 59 5 67 5 73 7 75 6 63 1 49 2 35 1 24 1 47 87 1938 23 4 32 8 43 8 49 4 59 0 67 2 73 5 74 4 64 3 56 3 41 7 27 4 51 10 1939 29 5 24 7 37 4 44 9 62 6 71 0 73 7 71 2 68 9 54 1 39 0 33 5 50 88 1940 13 6 27 5 31 7 45 9 55 6 69 8 74 6 72 1 63 1 55 6 36 1 30 9 48 04 1941 26 1 23 0 31 8 53 0 63 2 69 5 73 7 72 4 67 1 54 3 41 1 33 7 50 74 1942 22 8 23 7 39 3 52 9 59 3 69 4 74 5 70 9 61 5 52 2 39 9 21 5 48 99 1943 21 5 26 5 32 0 45 9 56 3 72 1 74 6 73 4 60 4 52 1 34 6 26 9 48 03 1944 29 9 27 3 31 9 44 6 63 8 72 4 73 3 73 4 65 5 52 7 41 8 21 2 49 82 1945 18 2 27 0 48 1 49 3 53 7 65 0 71 1 71 3 63 0 50 5 38 7 20 5 48 03 1946 25 8 27 5 46 1 51 2 56 5 68 1 74 3 69 3 64 9 57 4 40 8 31 2 51 09 1947 27 2 19 6 31 5 47 1 54 2 65 9 70 9 79 4 66 3 61 2 32 9 29 3 48 79 1948 17 4 25 1 35 7 52 8 55 2 67 6 74 0 72 6 66 8 50 7 42 1 28 8 49 07 1949 26 3 26 1 36 6 47 1 60 7 72 8 76 5 73 2 59 1 56 7 39 6 30 5 50 43 1950 28 6 25 1 32 0 41 5 59 7 68 3 70 9 68 7 63 3 57 7 33 6 18 3 47 31 1951 22 1 25 8 34 1 46 0 61 3 65 8 71 2 68 7 61 4 53 8 31 2 24 3 47 14 1952 25 1 30 9 33 6 50 3 58 0 73 1 75 8 71 0 64 3 47 6 41 4 30 8 50 16 1953 27 4 30 6 37 6 45 4 60 0 72 6 74 5 73 4 65 7 57 7 42 4 30 1 51 45 1954 25 6 35 8 33 6 52 1 55 3 73 5 74 2 71 1 67 2 53 5 40 5 29 7 51 01 1955 23 4 26 3 36 1 55 1 61 9 66 8 79 0 76 5 66 0 54 6 34 8 24 7 50 43 1956 26 8 27 8 35 7 47 2 60 0 72 3 71 7 72 5 64 1 59 3 39 4 31 5 50 69 1957 17 4 31 8 36 8 48 6 58 1 69 7 75 0 72 0 62 9 50 7 38 9 33 1 49 58 1958 23 9 18 3 35 2 49 8 60 4 63 9 71 7 72 8 64 9 56 1 41 5 20 9 48 28 1959 16 8 24 3 36 1 48 2 64 7 71 4 73 0 76 7 67 3 50 4 31 8 34 3 49 58 1960 26 1 24 2 24 2 51 8 57 0 66 9 72 1 73 3 68 3 53 7 41 3 24 4 48 61 1961 21 8 32 3 39 1 43 4 55 6 68 6 72 7 72 6 66 9 54 4 39 3 24 3 49 25 1962 16 0 24 0 32 8 48 1 65 4 69 2 70 2 72 5 62 0 56 0 40 2 23 7 48 34 1963 11 3 17 4 39 7 51 1 57 6 71 1 73 2 69 4 64 2 62 4 43 5 15 7 48 05 1964 28 3 27 2 34 7 49 4 64 3 70 9 74 1 69 8 64 3 50 1 42 6 25 1 50 07 1965 22 2 24 5 27 9 46 4 63 6 68 1 72 1 69 3 63 4 53 1 40 7 34 8 48 84 1966 16 8 26 2 38 8 45 5 54 1 70 1 76 3 70 0 62 8 51 7 41 1 26 7 48 34 1967 26 9 20 1 36 6 48 9 54 1 70 5 69 9 66 8 62 0 51 6 35 5 29 0 47 66 1968 22 2 22 4 41 8 50 5 56 1 70 3 72 3 72 9 64 3 53 8 39 0 26 7 49 36 1969 19 2 27 9 32 5 49 2 59 4 64 3 72 8 72 9 64 2 50 9 36 5 26 2 48 00 1970 14 6 24 3 32 9 49 7 61 6 69 0 74 0 72 6 64 7 54 2 38 4 28 9 1971 16 9 25 8 33 2 47 9 56 7 73 6 70 8 70 4 67 9 60 0 39 6 32 9 1972 19 7 23 2 33 7 44 9 60 7 65 6 72 1 71 8 64 4 49 7 36 9 24 2 1973 27 4 28 1 43 6 48 0 55 5 71 2 74 4 73 8 65 5 57 7 40 5 26 4 1974 23 6 26 3 37 9 51 1 56 3 65 7 74 8 70 3 60 5 52 6 40 0 29 7 1975 26 0 25 6 32 5 43 0 62 3 70 4 73 2 73 4 60 0 54 6 44 9 29 5 1976 17 9 33 2 40 7 50 9 55 2 69 9 73 5 69 2 62 2 46 8 30 9 18 0 1977 8 0 24 9 42 7 53 9 67 1 67 4 75 6 68 9 63 9 49 9 39 2 22 5 1978 14 8 15 5 31 1 48 4 58 4 69 2 72 0 71 5 68 8 50 8 39 9 23 9 1979 10 1 14 7 35 1 44 9 59 0 69 2 71 5 70 2 64 7 51 8 39 1 31 7 1980 22 6 20 8 32 3 46 7 60 3 66 6 75 0 73 8 64 4 48 1 39 6 27 0 1981 22 2 27 5 37 8 52 3 55 6 69 9 71 5 70 7 62 1 49 4 41 3 25 2 1982 12 4 21 5 33 9 43 9 64 5 63 4 73 1 68 7 62 1 53 4 39 6 35 9 1983 26 7 31 1 38 3 44 3 55 0 69 9 77 1 76 4 64 2 53 0 42 5 14 8 1984 17 8 33 6 29 6 46 4 56 2 71 1 71 3 73 2 62 3 54 3 39 3 31 2 1985 15 3 20 9 40 1 53 3 61 9 65 8 72 8 68 7 65 3 52 4 38 1 17 6 1986 23 2 24 3 39 7 52 8 59 9 67 7 74 9 68 0 66 1 52 8 35 5 29 9 1987 24 9 32 8 40 4 50 1 63 2 72 3 76 0 71 1 63 5 46 0 43 3 31 5 1988 18 1 22 1 37 4 47 9 61 2 71 9 76 1 76 5 65 3 45 8 40 9 27 5 1989 31 2 19 0 35 9 46 6 57 4 67 8 73 5 70 5 61 4 53 1 36 7 15 9 1990 32 9 31 0 40 8 49 0 55 4 69 2 71 5 70 8 65 4 50 7 44 4 28 4 1991 20 3 30 4 40 1 52 1 65 8 72 8 75 3 73 5 63 4 52 5 35 0 30 0 1992 27 7 32 9 38 0 45 6 58 0 65 6 69 4 66 4 61 9 50 4 38 3 28 5 1993 25 3 24 6 33 7 45 7 60 8 67 1 74 2 72 9 59 0 49 9 38 6 29 2 1994 15 2 21 4 37 5 50 8 58 0 70 4 72 1 68 3 65 1 54 0 43 4 33 4 1995 22 6 25 9 39 1 45 0 57 4 71 3 75 7 77 7 61 3 52 8 31 8 25 1 1996 22 0 25 5 30 5 44 7 54 9 68 0 69 8 71 4 62 6 51 7 31 9 26 5 1997 18 0 28 7 38 1 44 7 53 4 68 2 72 8 68 4 63 9 52 4 36 4 30 5 1998 28 3 38 4 38 3 49 7 64 7 68 9 73 4 73 3 68 2 54 1 43 9 34 2

The Answer is in the image, click to view ...

Question: Ref: www.phdcomics.com Note: Only use Excel Functions for all computations. Problem 1: (50 Points) Illinois Temp contains temperature data for Northern Illinois from 1895 to

Ref: www.phdcomics.com Note: Only use Excel Functions for all computations. Problem 1: (50 Points) Illinois Temp contains temperature data for Northern Illinois from 1895 to 1998

a. Compute the Average Temperature for each year (Fill Column N).

b. Convert the Data available into a Table and choose a Design of your choice.

c. Obtain the Mean, Median, Standard Deviation, Variance, Quartiles (Q1, Q2, Q3, Q4), IQR for the entire data (1895-1998), using ONLY Excel Functions (not using the Analysis Tool Pak Add-In)the data on the temperatures, not the years.

All the temperatures on the data sheet.

d. Use the Statistical measurements generated from the Analysis Toolpak (Add-In) and compare the values obtained in (d). Comment on your findings.

e. Identify the Outliers in the data, if any. Comment on your findings.

f. Record a Macro titled 'Filter_over25' with a Keyboard Shortcut - Ctrl+Shift+D'. The Macro should be able to filter temperatures that are above 25 degrees. Hint: Record a macro for one month (one column). Note: You will now be required to save the file with a .xlsm extension.

g. Test the Macro for every Month.

h. Lastly, include a Form control button (titled appropriately), that allows any end user to run the Macro defined in (f) by the click of this button.

Year	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Average Temp.
1895	16.4	14.9	32.9	53.2	60.2	72.9	72.0	72.6	67.6	46.2	35.7	29.5	47.84
1896	25.8	25.4	31.2	54.3	66.3	69.6	73.2	72.3	60.5	48.3	37.0	32.1	49.67
1897	21.7	27.5	34.6	46.1	55.4	67.3	75.5	69.2	68.7	57.6	36.8	23.4	48.65
1898	26.8	26.0	39.8	46.7	57.9	70.7	74.0	71.6	66.7	49.9	35.6	22.8	49.04
1899	21.9	15.6	29.1	50.9	59.6	70.7	73.4	73.9	62.4	56.3	43.3	26.2	48.61
1900	28.0	18.7	29.3	49.6	60.4	68.0	72.8	77.4	65.9	59.9	37.0	28.4	49.62
1901	25.1	17.2	34.4	46.8	57.8	71.3	78.7	72.7	64.4	53.7	34.8	22.3	48.27
1902	23.8	17.9	39.7	46.6	62.8	65.3	74.0	68.6	60.7	53.7	45.4	24.1	48.55
1903	22.3	23.8	41.8	48.3	61.9	63.8	73.2	69.1	63.6	52.4	34.6	19.1	47.83
1904	14.4	15.6	34.1	43.0	59.0	67.1	71.1	67.8	63.8	52.2	40.0	24.9	46.08
1905	17.0	15.2	39.6	47.3	58.7	68.1	71.6	72.9	66.3	51.7	38.2	28.6	47.93
1906	28.3	23.3	27.7	50.5	59.8	67.9	72.1	74.5	68.3	51.6	37.8	28.8	49.22
1907	25.9	24.9	41.3	39.5	51.4	65.9	72.8	69.9	62.8	49.7	36.7	30.0	47.57
1908	25.2	24.0	38.7	47.6	58.5	68.1	73.6	71.4	68.4	53.4	40.1	28.1	49.76
1909	24.1	28.6	34.7	44.8	56.0	69.1	71.2	74.9	62.4	48.1	46.2	18.6	48.23
1910	21.5	21.2	46.9	50.6	54.0	68.3	74.5	71.3	63.3	55.5	33.7	23.1	48.66
1911	24.9	29.8	36.9	45.8	64.9	72.4	74.1	70.6	65.4	50.4	32.7	31.6	49.96
1912	7.4	17.9	26.4	49.1	60.5	66.1	72.9	69.4	65.7	53.7	39.7	30.9	46.64
1913	25.7	34.3	32.7	48.2	58.5	71.2	75.0	74.6	64.4	51.3	44.2	34.4	51.21
1914	29.7	15.9	33.7	48.2	61.6	70.6	76.1	73.1	64.1	56.4	40.6	20.0	49.17
1915	18.3	31.8	33.1	54.6	54.9	64.5	70.4	65.9	65.9	53.4	41.4	26.0	48.35
1916	26.0	21.4	31.4	46.8	59.3	63.3	78.9	74.7	62.6	52.1	39.7	22.7	48.24
1917	21.9	17.2	37.1	44.8	52.9	64.6	72.8	69.5	62.0	43.6	39.8	18.0	45.35
1918	9.3	24.6	41.9	43.9	63.2	67.7	71.2	75.2	57.7	54.7	40.7	35.1	48.77
1919	28.5	28.1	38.1	49.2	56.3	73.8	76.2	71.2	67.2	54.0	36.5	18.5	49.80
1920	15.8	23.8	37.9	42.7	57.3	69.7	71.6	70.6	67.4	59.2	37.9	29.8	48.64
1921	30.6	31.4	44.4	52.8	62.0	74.4	79.2	71.7	68.3	53.3	37.5	29.5	52.93
1922	21.6	26.9	38.5	49.1	62.9	70.5	72.3	72.8	67.4	55.5	41.9	26.5	50.49
1923	27.7	19.7	31.6	46.6	57.0	71.3	74.7	70.5	63.8	49.7	41.1	37.3	49.25
1924	16.9	26.0	33.2	49.4	53.2	66.2	69.9	70.7	59.3	57.7	39.4	19.9	46.82
1925	22.6	30.3	38.9	54.3	55.8	71.4	73.1	72.4	69.3	43.3	36.3	23.1	49.23
1926	25.5	29.2	30.0	42.2	61.0	64.6	74.0	72.9	63.9	50.7	34.5	24.0	47.71
1927	21.0	33.1	41.0	47.6	56.5	64.8	72.1	67.4	68.5	56.2	41.6	24.0	49.48
1928	24.8	28.5	36.1	44.0	59.6	63.8	75.8	72.8	60.4	54.5	40.6	30.7	49.30
1929	16.3	18.6	42.5	50.7	56.5	66.0	73.7	69.8	63.5	51.7	34.6	26.1	47.50
1930	17.4	33.7	36.2	50.4	61.0	69.6	75.8	73.9	66.6	51.3	40.6	27.9	50.37
1931	33.4	33.6	33.7	49.1	55.7	71.7	76.2	72.0	69.6	56.1	46.7	35.1	52.74
1932	31.3	32.3	28.1	47.1	60.4	70.5	74.3	72.1	62.1	51.1	34.0	25.7	49.08
1933	34.2	22.9	35.4	47.2	60.0	75.6	74.4	69.9	68.9	49.9	36.6	28.7	50.31
1934	29.7	21.1	32.0	48.7	65.3	75.0	77.6	72.2	62.6	54.5	43.3	23.1	50.43
1935	22.8	27.6	41.2	45.3	52.8	64.9	76.5	72.6	63.8	52.5	37.4	22.7	48.34
1936	15.6	11.6	38.9	44.1	63.9	67.2	78.9	75.8	66.2	51.4	35.5	31.2	48.36
1937	23.6	24.1	32.6	46.3	59.5	67.5	73.7	75.6	63.1	49.2	35.1	24.1	47.87
1938	23.4	32.8	43.8	49.4	59.0	67.2	73.5	74.4	64.3	56.3	41.7	27.4	51.10
1939	29.5	24.7	37.4	44.9	62.6	71.0	73.7	71.2	68.9	54.1	39.0	33.5	50.88
1940	13.6	27.5	31.7	45.9	55.6	69.8	74.6	72.1	63.1	55.6	36.1	30.9	48.04
1941	26.1	23.0	31.8	53.0	63.2	69.5	73.7	72.4	67.1	54.3	41.1	33.7	50.74
1942	22.8	23.7	39.3	52.9	59.3	69.4	74.5	70.9	61.5	52.2	39.9	21.5	48.99
1943	21.5	26.5	32.0	45.9	56.3	72.1	74.6	73.4	60.4	52.1	34.6	26.9	48.03
1944	29.9	27.3	31.9	44.6	63.8	72.4	73.3	73.4	65.5	52.7	41.8	21.2	49.82
1945	18.2	27.0	48.1	49.3	53.7	65.0	71.1	71.3	63.0	50.5	38.7	20.5	48.03
1946	25.8	27.5	46.1	51.2	56.5	68.1	74.3	69.3	64.9	57.4	40.8	31.2	51.09
1947	27.2	19.6	31.5	47.1	54.2	65.9	70.9	79.4	66.3	61.2	32.9	29.3	48.79
1948	17.4	25.1	35.7	52.8	55.2	67.6	74.0	72.6	66.8	50.7	42.1	28.8	49.07
1949	26.3	26.1	36.6	47.1	60.7	72.8	76.5	73.2	59.1	56.7	39.6	30.5	50.43
1950	28.6	25.1	32.0	41.5	59.7	68.3	70.9	68.7	63.3	57.7	33.6	18.3	47.31
1951	22.1	25.8	34.1	46.0	61.3	65.8	71.2	68.7	61.4	53.8	31.2	24.3	47.14
1952	25.1	30.9	33.6	50.3	58.0	73.1	75.8	71.0	64.3	47.6	41.4	30.8	50.16
1953	27.4	30.6	37.6	45.4	60.0	72.6	74.5	73.4	65.7	57.7	42.4	30.1	51.45
1954	25.6	35.8	33.6	52.1	55.3	73.5	74.2	71.1	67.2	53.5	40.5	29.7	51.01
1955	23.4	26.3	36.1	55.1	61.9	66.8	79.0	76.5	66.0	54.6	34.8	24.7	50.43
1956	26.8	27.8	35.7	47.2	60.0	72.3	71.7	72.5	64.1	59.3	39.4	31.5	50.69
1957	17.4	31.8	36.8	48.6	58.1	69.7	75.0	72.0	62.9	50.7	38.9	33.1	49.58
1958	23.9	18.3	35.2	49.8	60.4	63.9	71.7	72.8	64.9	56.1	41.5	20.9	48.28
1959	16.8	24.3	36.1	48.2	64.7	71.4	73.0	76.7	67.3	50.4	31.8	34.3	49.58
1960	26.1	24.2	24.2	51.8	57.0	66.9	72.1	73.3	68.3	53.7	41.3	24.4	48.61
1961	21.8	32.3	39.1	43.4	55.6	68.6	72.7	72.6	66.9	54.4	39.3	24.3	49.25
1962	16.0	24.0	32.8	48.1	65.4	69.2	70.2	72.5	62.0	56.0	40.2	23.7	48.34
1963	11.3	17.4	39.7	51.1	57.6	71.1	73.2	69.4	64.2	62.4	43.5	15.7	48.05
1964	28.3	27.2	34.7	49.4	64.3	70.9	74.1	69.8	64.3	50.1	42.6	25.1	50.07
1965	22.2	24.5	27.9	46.4	63.6	68.1	72.1	69.3	63.4	53.1	40.7	34.8	48.84
1966	16.8	26.2	38.8	45.5	54.1	70.1	76.3	70.0	62.8	51.7	41.1	26.7	48.34
1967	26.9	20.1	36.6	48.9	54.1	70.5	69.9	66.8	62.0	51.6	35.5	29.0	47.66
1968	22.2	22.4	41.8	50.5	56.1	70.3	72.3	72.9	64.3	53.8	39.0	26.7	49.36
1969	19.2	27.9	32.5	49.2	59.4	64.3	72.8	72.9	64.2	50.9	36.5	26.2	48.00
1970	14.6	24.3	32.9	49.7	61.6	69.0	74.0	72.6	64.7	54.2	38.4	28.9
1971	16.9	25.8	33.2	47.9	56.7	73.6	70.8	70.4	67.9	60.0	39.6	32.9
1972	19.7	23.2	33.7	44.9	60.7	65.6	72.1	71.8	64.4	49.7	36.9	24.2
1973	27.4	28.1	43.6	48.0	55.5	71.2	74.4	73.8	65.5	57.7	40.5	26.4
1974	23.6	26.3	37.9	51.1	56.3	65.7	74.8	70.3	60.5	52.6	40.0	29.7
1975	26.0	25.6	32.5	43.0	62.3	70.4	73.2	73.4	60.0	54.6	44.9	29.5
1976	17.9	33.2	40.7	50.9	55.2	69.9	73.5	69.2	62.2	46.8	30.9	18.0
1977	8.0	24.9	42.7	53.9	67.1	67.4	75.6	68.9	63.9	49.9	39.2	22.5
1978	14.8	15.5	31.1	48.4	58.4	69.2	72.0	71.5	68.8	50.8	39.9	23.9
1979	10.1	14.7	35.1	44.9	59.0	69.2	71.5	70.2	64.7	51.8	39.1	31.7
1980	22.6	20.8	32.3	46.7	60.3	66.6	75.0	73.8	64.4	48.1	39.6	27.0
1981	22.2	27.5	37.8	52.3	55.6	69.9	71.5	70.7	62.1	49.4	41.3	25.2
1982	12.4	21.5	33.9	43.9	64.5	63.4	73.1	68.7	62.1	53.4	39.6	35.9
1983	26.7	31.1	38.3	44.3	55.0	69.9	77.1	76.4	64.2	53.0	42.5	14.8
1984	17.8	33.6	29.6	46.4	56.2	71.1	71.3	73.2	62.3	54.3	39.3	31.2
1985	15.3	20.9	40.1	53.3	61.9	65.8	72.8	68.7	65.3	52.4	38.1	17.6
1986	23.2	24.3	39.7	52.8	59.9	67.7	74.9	68.0	66.1	52.8	35.5	29.9
1987	24.9	32.8	40.4	50.1	63.2	72.3	76.0	71.1	63.5	46.0	43.3	31.5
1988	18.1	22.1	37.4	47.9	61.2	71.9	76.1	76.5	65.3	45.8	40.9	27.5
1989	31.2	19.0	35.9	46.6	57.4	67.8	73.5	70.5	61.4	53.1	36.7	15.9
1990	32.9	31.0	40.8	49.0	55.4	69.2	71.5	70.8	65.4	50.7	44.4	28.4
1991	20.3	30.4	40.1	52.1	65.8	72.8	75.3	73.5	63.4	52.5	35.0	30.0
1992	27.7	32.9	38.0	45.6	58.0	65.6	69.4	66.4	61.9	50.4	38.3	28.5
1993	25.3	24.6	33.7	45.7	60.8	67.1	74.2	72.9	59.0	49.9	38.6	29.2
1994	15.2	21.4	37.5	50.8	58.0	70.4	72.1	68.3	65.1	54.0	43.4	33.4
1995	22.6	25.9	39.1	45.0	57.4	71.3	75.7	77.7	61.3	52.8	31.8	25.1
1996	22.0	25.5	30.5	44.7	54.9	68.0	69.8	71.4	62.6	51.7	31.9	26.5
1997	18.0	28.7	38.1	44.7	53.4	68.2	72.8	68.4	63.9	52.4	36.4	30.5
1998	28.3	38.4	38.3	49.7	64.7	68.9	73.4	73.3	68.2	54.1	43.9	34.2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

. Illinois Temp contains temperature data for Northern Illinois from 1 8 9 5 to 1 9 9 8 a . Compute the Average Temperature for each year ( Fill Column N ) . b . Convert the Data available into a...

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

I need some help with both Case 1 and Case 2 of this assignment. See attached document for full assignment. Here is an excerpt from each. Case 1: Purchase Point Media Corporation (PPMC) Media...

Midterm Examination Questions - Spring 2016 1. The final examination grades of random samples of students from three different classes are shown below. Class A Class B Class C 92 91 85 85 85 93 96 90...

The description of the assignment Short Writing Assignment 2: Quantitative Immigration Data Analysis Please submit answers to the questions below in the PDF file that results from printing your...

Foundations of Business Statistics HOMEWORK - CORRELATION Name: Simina Fluture DUE: Monday, November 28th CORRELATION This homework will use the following formulae (use a scientific calculator): r= n...

Can someone do 5-11 in the Internal Audit program file( some parts may have errors) to do this you will need to use the case appendix D to answer the questions also please answer one of the questions...

Hey I have an audit case that I was wondering if you can help me with. You have helped me in the past. I was hoping if 25 would be fine. Please let me know. I have uploaded the files that are...

Identify types of third-party plans in Canada, how does one apply for them? What are the benefits of having third-party insurance? Can third-party insurance be used across Canada? What are the pro...

On 1 January 2022, Cassie Ltd acquired all the shares of Jasmine Ltd for $262 000 on a cum-div. basis. On this date, the equity and liabilities of Jasmine Ltd included the following balances: Share...

For Capital Budgeting purposes, "Allocated Costs" should not be included in the cash flow. Group of answer choices True False

When a company uses normal costing, the resulting MOH difference at year - end may be prorated to which accounts? why are these accounts used and what is the purpose of this proration process? what...

The quality of the proposed ideas

The number of new ideas that emerge

7. Develop a circular model, with positive and negative feedback loops, showing the following critical variables: