Home Paste N3 12 mba-662-case-sutdy-ii-historical-datafall-2021-ayi3jzg4 Q Search Sheet Share Insert Draw Page Layout Formulas Data Review View Cut II Calibri (Body) 11 A A A Wrap Text Number Autosum # Copy B I U Fill A Merge & Center $ % -.0 .00 .00 -.0 Format Conditional Format Formatting as Table Cell Styles Insert Delete Format Clear Sort & Filter Find & Select A B fx 1.0128 D E F G H J K L M N P Q R S T U V W X Y Z 123 YEAR MKT INDEX T-BILLS STOCK Year mkt index t bills stock Year mkt index t bills 4 1927 1928 30.85 3.12 33.97 1969 -17.2 6.58 -10.62 2011 0.97 0.04 stock 1.01 34.88 3.56 38.44 1970 -5.65 6.52 0.87 2012 16.01 0.06 16.07 5698 1929 -17.9 4.75 -13.15 1971 11.65 4.39 16.04 2013 35.15 0.03 35.18 1930 -30.77 2.41 -28.36 1972 12.97 3.84 16.81 2014 11.35 0.02 11.37 7 1931 -44.8 1.07 -43.73 1973 -24.69 6.93 -17.76 2015 -0.2 0.01 -0.19 1932 -9.45 0.96 -8.49 1974 -35.7 8.00 -27.70 2016 13.22 0.19 13.41 9 1933 56.08 0.30 56.38 1975 32.35 5.80 38.15 10 1934 4.42 0.16 4.58 1976 21.9 5.08 26.98 11 1935 44.35 0.17 44.52 1977 -8.19 5.12 -3.07 12 1936 32.44 0.18 32.62 1978 1.04 7.18 8.22 13 1937 -34.83 0.31 -34.52 1979 13.33 10.38 23.71 14 1938 27.95 -0.02 27.93 1980 22.1 11.24 33.34 15 1939 2.95 0.02 2.97 1981 -18.05 14.71 -3.34 16 1940 -6.93 0.00 -6.93 1982 10.78 10.54 21.32 17 1941 -10.14 0.06 -10.08 1983 14.41 8.80 23.21 18 1942 15.75 0.27 16.02 1984 -4.76 9.85 5.09 19 1943 28.23 0.35 28.58 1985 24.63 7.72 32.35 20 1944 21.12 0.33 21.45 1986 10.41 6.16 16.57 21 1945 37.72 0.33 38.05 1987 -3.51 5.47 1.96 22 1946 -6.08 0.35 -5.73 1988 11.55 6.35 17.90 23 1947 3.22 0.50 3.72 1989 20.51 8.37 28.88 24 1948 1.33 0.81 2.14 1990 -13.84 7.81 -6.03 25 1949 19.23 1.10 20.33 1991 29.1 5.60 34.70 26 1950 28.26 1.20 29.46 1992 6.41 3.51 9.92 27 1951 19.09 1.49 20.58 1993 8.37 2.90 11.27 28 1952 11.89 1.66 13.55 1994 -4.11 3.90 -0.21 29 1953 -1.15 1.82 0.67 1995 31.04 5.60 36.64 30 1954 49.28 0.86 50.14 1996 16.25 5.21 21.46 31 1955 23.76 1.57 25.33 1997 26.07 5.26 31.33 32 1956 5.83 2.46 8.29 1998 19.41 4.86 24.27 33 1957 -13.27 3.14 -10.13 1999 20.21 4.68 24.89 34 1958 43.46 1.54 45.00 2000 -16.71 5.89 -10.82 35 1959 9.79 2.95 12.74 2001 -14.78 3.78 -11.00 36 1960 -1.73 2.66 0.93 2002 -22.91 1.63 -21.28 37 1961 24.88 2.13 27.01 2003 30.74 1.02 31.76 38 1962 -12.28 2.73 -9.55 2004 10.69 1.20 11.89 39 1963 17.92 3.12 21.04 2005 3.21 2.96 6.17 40 1964 12.66 3.54 16.20 2006 10.58 4.79 15.37 41 1965 10.58 3.93 14.51 2007 0.83 4.67 5.50 42 1966 -13.54 4.76 -8.78 2008 -38.39 1.47 -36.92 43 1967 24 4.21 28.21 2009 29.05 0.10 29.15 44 1968 9.02 5.21 14.23 2010 17.68 0.12 17.80 1.01 historical data + Ready + 100%