Excel

profilenader91
correlation-2.xlsx
Home>Business & Finance homework help>Economics homework help>Excel

Sheet1

United States California
Year Vehicle Miles Taveled (VMT) Population GDP (Billions of 2009 dollas) Gas Price (2011 Dollars) GDP per capita VMT per capita Year Unemployment Rate Interest Rate on New Vehicles Number of Passenger Cars Number of Light Duty Trucks Total number of vehicles Population VMT (millions) VMT per capita
1966 927,899 125,697,033 $ 4,235 $ 1.73 1966 3.8 7.23 8,693,303 1,638,920 18,789,242 100,958
1967 966,005 127,576,707 $ 4,351 $ 1.72 1967 3.9 7.62 9,088,947 1,740,729 19,095,782 103,818
1968 1,019,726 129,594,374 $ 4,565 $ 1.71 1968 3.7 8.305 9,314,496 1,788,714 19,302,322 106,070
1969 1,066,108 131,797,049 $ 4,708 $ 1.65 1969 3.5 9.175 9,686,302 1,894,444 19,607,863 111,744
1970 1,114,098 133,595,295 $ 4,718 $ 1.62 1970 4.9 10.21 9,883,790 1,996,334 20,023,181 116,992
1971 1,183,524 136,954,829 $ 4,873 $ 1.58 1971 5.9 10.695 10,234,172 2,111,817 20,364,238 118,023
1972 1,264,614 139,735,203 $ 5,129 $ 1.55 1972 5.7 10.975 10,560,142 2,270,630 20,622,120 126,488
1973 1,316,207 142,398,950 $ 5,418 $ 1.45 1973 4.9 11.145 10,910,604 2,479,152 20,923,727 129,849
1974 1,282,790 145,093,729 $ 5,390 $ 1.43 1974 5.4 11.79 11,162,119 2,498,811 21,247,201 127,600
1975 1,330,074 147,970,069 $ 5,380 $ 1.80 1975 8.8 12.24 11,226,325 2,643,397 21,630,031 132,600
1976 1,409,163 150,917,244 $ 5,669 $ 1.81 1976 7.6 12.12 11,478,776 2,814,744 22,046,484 139,700
1977 1,476,567 153,837,969 $ 5,931 $ 1.77 1977 7.2 12.03 11,694,053 3,241,523 22,480,890 150,300
1978 1,548,213 156,795,149 $ 6,260 $ 1.74 1978 5.9 12.085 11,974,736 3,468,092 22,988,266 162,389
1979 1,529,133 159,869,630 $ 6,459 $ 1.62 1979 5.7 12.765 12,466,173 3,771,658 23,423,038 159,746
1980 1,527,295 162,789,000 $ 6,443 $ 2.03 1980 7.6 14.56 13,268,006 3,580,834 23,800,800 155,890
1981 1,555,308 166,218,463 $ 6,611 $ 2.58 1981 7.5 16.355 13,208,593 3,557,517 24,299,875 159,900
1982 1,595,010 168,784,927 $ 6,484 $ 2.68 1982 9.6 16.49 13,420,945 3,675,347 24,847,891 169,999
1983 1,652,788 171,118,390 $ 6,785 $ 2.40 1983 10.1 13.25 13,935,390 3,797,926 25,401,849 182,652
1984 1,720,269 173,201,853 $ 7,277 $ 2.19 1984 7.2 14.165 14,095,912 3,835,287 25,900,165 196,537
1985 1,774,826 175,124,316 $ 7,586 $ 2.08 1985 7.4 12.445 13,968,518 4,896,268 26,510,817 207,600
1986 1,834,872 177,052,780 $ 7,852 $ 2.01 1986 7.2 10.385 14,415,379 5,309,069 27,185,890 214,913
1987 1,921,204 178,986,243 $ 8,124 $ 1.50 1987 6.2 10.59 14,629,229 5,627,769 27,874,754 226,301
1988 2,025,962 180,973,706 $ 8,465 $ 1.52 1988 5.4 11.73 15,224,990 6,074,441 28,575,786 241,575
1989 2,096,487 183,037,169 $ 8,777 $ 1.46 1989 5.3 12.345 15,338,606 6,243,373 29,343,644 251,482
1990 2,144,362 185,286,966 $ 8,945 $ 1.57 1990 5.2 12.16 15,364,023 6,521,728 29,959,515 258,926
1991 2,172,050 187,589,654 $ 8,939 $ 1.73 1991 6.9 11.775 15,017,681 7,194,679 30,482,523 257,976
1992 2,247,151 189,987,074 $ 9,257 $ 1.67 1992 7.8 9.61 14,545,660 7,615,805 30,998,233 262,548
1993 2,296,378 192,379,730 $ 9,511 $ 1.60 1993 7.0 8.785 14,691,068 8,091,221 31,310,290 266,408
1994 2,357,588 194,611,985 $ 9,895 $ 1.58 1994 6.1 8.955 14,504,566 7,792,048 31,531,584 271,943
1995 2,422,823 196,985,922 $ 10,164 $ 1.59 1995 5.6 10.38 14,297,486 8,091,364 31,755,518 276,371
1996 2,482,202 199,405,561 $ 10,550 $ 1.68 1996 5.3 9.445 15,398,720 9,771,261 32,089,557 278,043
1997 2,552,233 202,011,889 $ 11,023 $ 1.65 1997 5.0 8.075 15,705,806 9,194,701 32,568,521 279,096
1998 2,628,148 204,723,819 $ 11,513 $ 1.40 1998 4.5 7.515 16,174,220 9,380,604 33,081,973 290,630
1999 2,690,241 207,418,583 $ 12,071 $ 1.52 1999 4.3 7.55 16,657,441 9,658,010 33,605,289 300,066
2000 2,746,925 209,877,652 $ 12,565 $ 1.93 2000 4.0 7.975 17,321,413 10,329,198 34,010,375 306,649
2001 2,781,462 212,660,928 $ 12,684 $ 1.83 2001 4.5 7.07 17,918,760 10,812,255 34,596,900 310,703
2002 2,855,756 215,013,936 $ 12,910 $ 1.67 2002 5.8 5.955 18,449,629 11,118,654 34,980,962 320,942
2003 2,890,893 217,623,683 $ 13,270 $ 1.92 2003 6.3 5.165 18,699,434 11,496,248 35,445,913 323,592
2004 2,962,513 220,246,939 $ 13,774 $ 2.20 2004 5.6 5.48 19,255,690 12,090,263 35,827,786 328,917
2005 2,989,807 222,738,806 $ 14,236 $ 2.60 2005 5.0 6.545 19,638,969 12,793,485 36,114,333 329,267
2006 3,014,116 225,420,985 $ 14,615 $ 2.84 2006 4.6 6.355 19,835,554 13,289,690 36,436,172 327,478
2007 3,029,822 227,472,684 $ 14,877 $ 2.99 2007 4.6 6.32 20,037,727 13,839,571 36,352,594 328,312
2008 2,973,509 229,795,293 $ 14,834 $ 3.41 2008 5.6 6.27 19,919,068 13,504,551 36,728,163 327,286
2009 2,977,591 232,095,429 $ 14,418 $ 2.43 2009 9.5 5.27 19,972,837 14,400,834 36,929,598 324,486
Correlation between Your Guess Corelation Tstat Significant Correlation between Your Guess Corelation Tstat Significant
Direction Strength Coefficient (r) at 95% level? Direction Strength Coefficient (r) at 95% level?
VMT and Population Interest rate and number of vehicles
VMT and GDP VMT per capita and unemployment rate
VMT per capita and GDP per capita Number of vehicles and VMT
Gas price and VMT per capita Unemployment rate and population

Sheet2

Sheet3