calculating r-squared

[karate718]

Hi,

I'd like to calculate the r-sqaured of the S&P 500 performance in an election year to see if that has any effect on the market's performance.

The data I have is below. The election years start in 1928 and are every 4 greater than that. How would I set it up to use the rsq forumla?

Thank you.

S&P 500 Index
1926 12%
1927 37%
1928 44%
1929 -8%
1930 -25%
1931 -43%
1932 -8%
1933 54%
1934 -1%
1935 48%
1936 34%
1937 -35%
1938 31%
1939 0%
1940 -10%
1941 -12%
1942 20%
1943 26%
1944 20%
1945 36%
1946 -8%
1947 6%
1948 6%
1949 19%
1950 32%
1951 24%
1952 18%
1953 -1%
1954 53%
1955 32%
1956 7%
1957 -11%
1958 43%
1959 12%
1960 0%
1961 27%
1962 -9%
1963 23%
1964 17%
1965 12%
1966 -10%
1967 24%
1968 11%
1969 -8%
1970 4%
1971 14%
1972 19%
1973 -15%
1974 -26%
1975 37%
1976 24%
1977 -7%
1978 7%
1979 18%
1980 32%
1981 -5%
1982 21%
1983 23%
1984 6%
1985 32%
1986 18%
1987 5%
1988 17%
1989 31%
1990 -3%
1991 30%
1992 8%
1993 10%
1994 1%
1995 38%
1996 23%
1997 33%
1998 29%
1999 21%
2000 -9%
2001 -12%
2002 -22%
2003 29%
2004 11%
2005 5%
2006 16%

 

[fastglass]

It's just one of the keys I've hardly ever had to use before, and just totally forgot to check across the number keys on the keyboard!

 

[RoryA]

It's Alt+0094 if you really want.

 

[slomobonobo]

Heh heh, yup, pretty sure I was staring at the keyboard awhile first time I needed the caret!