Excel

regression_1.xlsx

California

	independent var (y)	dependent var(x)
Year	CA Gas Price (2011 Dollars)	CA Vehicle Miles Traveled Per Capita	xi - xbar	yi - ybar	(xi - xbar)2
1966	$ 2.26	8,162
1967	$ 2.27	8,201
1968	$ 2.19	8,307				average (y)
1969	$ 2.11	8,580				average (x)
1970	$ 2.03	8,778				corelation(x,y)
1971	$ 1.97	8,620				std dev (y)
1972	$ 1.88	9,045				std dev (x)
1973	$ 1.95	9,068
1974	$ 2.55	8,695				b
1975	$ 2.53	8,792				a
1976	$ 2.49	9,004
1977	$ 2.47	9,421
1978	$ 2.36	9,877
1979	$ 2.89	9,461
1980	$ 3.48	9,022
1981	$ 3.51	8,962
1982	$ 3.15	9,299
1983	$ 2.53	9,770
1984	$ 2.37	10,305
1985	$ 2.27	10,641
1986	$ 1.71	10,755
1987	$ 1.72	11,057
1988	$ 1.68	11,521
1989	$ 1.74	11,693
1990	$ 1.84	11,782
1991	$ 1.69	11,607
1992	$ 1.84	11,652
1993	$ 1.77	11,745
1994	$ 1.78	11,959
1995	$ 1.78	12,101
1996	$ 1.89	12,075
1997	$ 1.86	11,895
1998	$ 1.59	12,132
1999	$ 1.79	12,280
2000	$ 2.13	12,410
2001	$ 2.01	12,313
2002	$ 1.83	12,525
2003	$ 2.17	12,429
2004	$ 2.46	12,484
2005	$ 2.80	12,430
2006	$ 3.08	12,130
2007	$ 3.26	12,047
2008	$ 3.60	11,906
2009	$ 2.74	11,742