Real Homes table

Columns A, B -- from Shiller's Excel file Fig2-1.xls, downloaded early 2/22/2011
Columns C, D equal columns A, B except -- in BOLD are changes by me from S&P data releases of 2/22/2011, 5/31/2011, 8/30/2011,
11/29/2011, 2/28/2012
The plotted Real Homes price & date data are included below; plots at:
http://homepage.mac.com/ttsmyf/RD_RJShomes_PSav.html
http://homepage.mac.com/ttsmyf/RHandRD.html

A B C D E F
  Real   Real Cols. E,F include Cols. E,F include
  Home   Home PLOTTED DATA PLOTTED DATA
  Price   Price Col. D scaled  
  Index   Index to max. = 100 date
1890 100.000 1890 100.000 49.302 1890
1891 88.012 1891 88.012 43.392 1891
1892 95.422 1892 95.422 47.045 1892
1893 92.297 1893 92.297 45.505 1893
1894 123.980 1894 123.980 61.125 1894
1895 117.455 1895 117.455 57.908 1895
1896 100.303 1896 100.303 49.452 1896
1897 106.516 1897 106.516 52.515 1897
1898 110.184 1898 110.184 54.323 1898
1899 103.853 1899 103.853 51.202 1899
1900 101.574 1900 101.574 50.079 1900
1901 87.326 1901 87.326 43.054 1901
1902 100.474 1902 100.474 49.536 1902
1903 93.075 1903 93.075 45.888 1903
1904 101.854 1904 101.854 50.217 1904
1905 87.249 1905 87.249 43.016 1905
1906 103.525 1906 103.525 51.040 1906
1907 109.317 1907 109.317 53.896 1907
1908 100.819 1908 100.819 49.706 1908
1909 95.380 1909 95.380 47.025 1909
1910 93.111 1910 93.111 45.906 1910
1911 97.543 1911 97.543 48.091 1911
1912 102.365 1912 102.365 50.469 1912
1913 95.409 1913 95.409 47.039 1913
1914 96.977 1914 96.977 47.812 1914
1915 88.149 1915 88.149 43.459 1915
1916 93.725 1916 93.725 46.209 1916
1917 85.009 1917 85.009 41.912 1917
1918 75.567 1918 75.567 37.256 1918
1919 70.514 1919 70.514 34.765 1919
1920 66.074 1920 66.074 32.576 2/1/20
1921 65.614 1921 65.614 32.349 2/1/21
1922 74.796 1922 74.796 36.876 2/1/22
1923 76.350 1923 76.350 37.642 2/1/23
1924 74.287 1924 74.287 36.625 2/1/24
1925 78.163 1925 78.163 38.536 2/1/25
1926 72.491 1926 72.491 35.740 2/1/26
1927 71.380 1927 71.380 35.192 2/1/27
1928 73.282 1928 73.282 36.130 2/1/28
1929 72.614 1929 72.614 35.801 2/1/29
1930 69.492 1930 69.492 34.261 2/1/30
1931 68.645 1931 68.645 33.844 2/1/31
1932 68.337 1932 68.337 33.692 2/1/32
1933 72.866 1933 72.866 35.925 2/1/33
1934 73.279 1934 73.279 36.129 2/1/34
1935 78.070 1935 78.070 38.490 2/1/35
1936 79.415 1936 79.415 39.153 2/1/36
1937 79.718 1937 79.718 39.303 2/1/37
1938 78.465 1938 78.465 38.685 2/1/38
1939 78.550 1939 78.550 38.727 2/1/39
1940 81.731 1940 81.731 40.295 2/1/40
1941 73.816 1941 73.816 36.393 2/1/41
1942 68.503 1942 68.503 33.774 2/1/42
1943 70.923 1943 70.923 34.967 2/1/43
1944 80.309 1944 80.309 39.594 2/1/44
1945 87.750 1945 87.750 43.263 2/1/45
1946 106.506 1946 106.506 52.510 2/1/46
1947 109.330 1947 109.330 53.902 2/1/47
1948 101.223 1948 101.223 49.905 2/1/48
1949 100.047 1949 100.047 49.325 2/1/49
1950 105.895 1950 105.895 52.209 2/1/50
1951 103.899 1951 103.899 51.225 2/1/51
1952 103.974 1952 103.974 51.262 2/1/52
1953 114.713 1953 114.713 56.556 2/1/53
1954 114.199 1954 114.199 56.303 2/1/54
1955 115.462 1955 115.462 56.926 2/1/55
1956 115.317 1956 115.317 56.854 2/1/56
1957 115.096 1957 115.096 56.745 2/1/57
1958 112.685 1958 112.685 55.557 2/1/58
1959 110.980 1959 110.980 54.716 2/1/59
1960 110.525 1960 110.525 54.492 2/1/60
1961 109.194 1961 109.194 53.835 2/1/61
1962 109.672 1962 109.672 54.071 2/1/62
1963 109.360 1963 109.360 53.917 2/1/63
1964 106.982 1964 106.982 52.745 2/1/64
1965 109.695 1965 109.695 54.082 2/1/65
1966 109.409 1966 109.409 53.942 2/1/66
1967 107.226 1967 107.226 52.865 2/1/67
1968 106.410 1968 106.410 52.463 2/1/68
1969 108.552 1969 108.552 53.519 2/1/69
1970 110.440 1970 110.440 54.450 2/1/70
1971 110.684 1971 110.684 54.570 2/1/71
1972 111.611 1972 111.611 55.027 2/1/72
1973 109.917 1973 109.917 54.192 2/1/73
1974 108.055 1974 108.055 53.274 2/1/74
1975 108.573 1975 108.573 53.529 2/1/75
1976 105.689 1976 105.689 52.107 2/1/76
1977 109.423 1977 109.423 53.948 2/1/77
1978 116.301 1978 116.301 57.339 2/1/78
1979 122.090 1979 122.090 60.193 2/1/79
1980 117.138 1980 117.138 57.752 2/1/80
1981 110.816 1981 110.816 54.635 2/1/81
1982 107.254 1982 107.254 52.879 2/1/82
1983 106.146 1983 106.146 52.332 2/1/83
1984 105.855 1984 105.855 52.189 2/1/84
1985 107.745 1985 107.745 53.121 2/1/85
1986 111.173 1986 111.173 54.811 2/1/86
1987 118.925 1987 118.925 58.633 2/1/87
1988 122.849 1988 122.849 60.568 2/1/88
1989 127.511 1989 127.511 62.866 2/1/89
1990 126.477 1990 126.477 62.356 2/1/90
1991 116.306 1991 116.306 57.342 2/1/91
1992 114.702 1992 114.702 56.551 2/1/92
1993 111.321 1993 111.321 54.884 2/1/93
1994 111.497 1994 111.497 54.971 2/1/94
1995 110.271 1995 110.271 54.366 2/1/95
1996 109.925 1996 109.925 54.195 2/1/96
1997 109.639 1997 109.639 54.055 2/1/97
1998 113.074 1998 113.074 55.748 2/1/98
1999 119.482 1999 119.482 58.908 2/1/99
2000 126.300 2000 126.300 62.269 2/1/00
2001 133.042 2001 133.042 65.593 2/1/01
2002 142.049 2002 142.049 70.034 2/1/02
2003 153.096 2003 153.096 75.480 2/1/03
2004 168.368 2004 168.368 83.009 2/1/04
2005 189.147 2005 189.147 93.254 2/1/05
2006 202.830 2006 202.830 100.000 2/1/06
2007.125 194.671 2007.125 194.671 95.978 2/1/07
2007.375 188.937 2007.375 188.937 93.151 5/1/07
2007.625 184.240 2007.625 184.240 90.835 8/1/07
2007.875 174.230 2007.875 174.230 85.899 11/1/07
2008.125 160.956 2008.125 160.956 79.355 2/1/08
2008.375 154.747 2008.375 154.747 76.294 5/1/08
2008.625 145.848 2008.625 145.848 71.907 8/1/08
2008.875 137.245 2008.875 137.235 67.660 11/1/08
2009.125 130.455 2009.125 130.425 64.302 2/1/09
2009.375 133.181 2009.375 133.161 65.652 5/1/09
2009.625 136.182 2009.625 136.132 67.117 8/1/09
2009.875 134.163 2009.875 134.113 66.121 11/1/09
2010.125 129.990 2010.125 129.980 64.083 2/1/10
2010.375 135.236 2010.375 135.196 66.655 5/1/10
2010.625 132.486 2010.625 132.682 65.415 8/1/10
    2010.875 127.647 62.933 11/1/10
    2011.125 121.697 60.000 2/1/11
    2011.375 123.969 61.120 5/1/11
    2011.625 123.299 60.789 8/1/11
    2011.875 118.328 58.339 11/1/11