Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please use megastat and excel if you have it if not excel screenshot is fine. will rate. provided all data below . Suppose we conduct

please use megastat and excel if you have it if not excel screenshot is fine. will rate. provided all data below
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
. Suppose we conduct a regression with RGDP as the dependent variable and TREND, UR, CPI and M1 as the explanatory variables. Run this regression and test for multicollinearity. If multicollinearity exists, eliminate variables that cause the problem and provide your final model that does not display any multicollinearity. (12 points) RGDP: UR Real GDP in 2012 dollars millions of dollars) Civilian Unemployment Race (percent) Consumer Price Index MI Money Supply (millions of dollars) Trend (observation number CPI: MI: TREND: YEAR QTR RGDP TREND UR CPI MI 1962 4 3192380 3.100 290413 140.533 1963 1 3194 653 2 5.267 29,193 141533 1963 2 3203.759 3 S7600 29 370 14012671 1963 3 3275757 4 5.133 29.997 39.900 1963 4 3258088 52233 29573 19.00 1964 1 3274029 6 5-533 29.590 1:10.9 1964 2 3232.009 6.267 29.780 140/833 1954 3 3253 826 6.100 29 840 141633 1984 4 3309.059 9 7.000 29 830 1621567 1965 1 3372.581 10 6.767 29.97 143:40 1965 2 3438.321 14 6.200 29 30 44.700 1965 3500054 12 5633 30107 145.633 1965 4 353) 683 13 5533 30.220 146.000 1900 1 3575070 14 5.567 30307 246.467 1906 2 3586 827 15 5533 30.380 147.267 1966 3625981 16 5.767 30472 148 800 1966 3666 509 17 5.733 30.533 150.167 1967 1 3747 278 18 5.500 30.720 151.700 1967 2 3771.845 19 5.567 30.803 153.167 1967 3 3851 366 20 5.467 30.930 154.167 1967 4 3893.296 21 5.200 30.980 155.233 1968 1 3954.121 22 5.000 31.050 157.767 1988 2 3966335 23 4.967 31.193 159.833 1968 3 4062.311 24 4.900 31.290 . 161.033 1968 4 4113.629 25 4.667 31.490 161.967 1969 1 4205 086 26 4.367 31.583 163.833 1969 2 4301.973 27 4.100 31.750 166,833 1969 3 4406,693 28 3.867 32.047 169.733 1969 4 4421.747 29 9 mm w% man # * % 3.833 32.337 171.567 1970 1 4459.195 30 3.767 32.617 171.033 1970 2 4495.777 31 3.700 32883 171533 1970 3 4535.591 32 3.833 32.967 173.233 1970 4 4538 370 33 3.833 175.633 1971 1 4581309 33.167 33.500 34 3.800 179.500 1971 2 4615.853 35 3.900 33.867 182.433 1971 3 4709.993 36 3.733 34.200 184.833 1971 4 4788 688 37 3.567 34 533 188.000 1972 1 3.533 35.000 191.667 1972 2 4825.799 4844.779 4920.605 39 3.400 35.433 195 800 1972 3 40 3400 35.862 1972 199.333 4935 564 41 3.433 200.933 1973 1 4968.164 36433 3699; 42 3.567 1973 201.833 2 4943.925 3.567 37.500 1973 3 203.467 4936 594 4.167 38.100 1973 205 633 4 45 4943.600 4989.159 4.767 38.633 1974 1 46 5.167 99.033 1974 207.162 209.900 213667 2 4935.693 E 5.833 1974 39.600 3 35 5.931 1974 39.933 4 217,233 49 5069.746 5097.179 5139.125 3151 245 5.900 1975 40.300 || 221.833 6,033 1975 40.700 225.667 51 5933 Cut 227.767 1975 1 5139.128 6.033 40.700 225.667 2 5151.245 51 5.933 41.000 227.767 1975 1975 3 5245 974 52 5.767 41.333 232.233 1975 4 5365.045 53 5.700 41.600 236,033 1976 1 5415.712 54 41.933 5567 5.367 1976 2 5506.396 3 55 42.367 240.967 246.867 251.800 1976 3 5642.669 56 4933 43.033 1976 4 5704.098 57 4.933 43.933 254.767 1977 1 5674.100 58 4.800 44.800 257.700 1977 2 5727.960 59 4.767 45.933 260.967 1977 3 5678.713 60 5.133 47.300 265.267 1977 4 5692.210 61 5.200 48.567 267.767 1978 1 5638 411 62 5.633 49.933 270.133 1978 2 5616526 63 6,600 51.467 273.400 1978 3 5548.156 64 8.267 52.567 275.100 1978 4 5587.800 65 8.867 279.267 53.200 54.267 1979 1 5683.444 8.467 284.500 1979 2 5759.972 67 8300 286.433 1979 55.267 55.900 3 5889.500 68 7.733 290.633 1979 4 69 7.567 56.400 5932.711 5965.265 1980 1 295.600 298.600 20 7.733 57300 1980 2 7.767 58.133 303.933 6008.504 6079.494 1980 3 72 59.200 311233 1980 7.500 7.133 4 6197 686 mm" 317333 23 7-- 1981 1 6309,514 60 233 61.067 6.900 322333 1981 2 6309.652 75 6.667 61.967 328.633 1981 3 76 6329.791 6574390 63033 1981 6.333 6.000 4. 77 335 567 343.900 64.467 1982 1 6640.497 78 6033 349.800 1982 2 6729.755 65.967 67.500 79 355 333 1982 3 6741854 5900 5.867 1982 4 6749263 69.200 21400 360.333 370.333 1963 1 82 5.700 5.567 5967 378.433 1983 6799-200 6816.203 6837661 2 83 73.700 76037 79.033 3 1983 1983 6300 381.133 388.100 4 6696.753 HS 7.333 81.700 580 - 5.867 82 378.433 73.700 1983 1 6799 200 5.967 83 76.033 381.133 1983 2 6816.203 84 6.300 29.033 388.100 1983 6837.641 3 7333 81.700 385.900 85 1983 4 6696.753 86 7.667 83.233 399.333 1984 1 6688.794 7.400 85.567 409.400 87 1984 2 6813.535 88 7.433 87.933 415.033 1984 6947042 3 89 7.400 425.767 89.767 1984 6895.559 4 90 7.400 6978.135 92.267 426.933 1985 1 . 8.233 91 6902.105 93.767 432.133 1985 2 442.433 8.833 94.600 1985 6794.878 3 92 93 9.433 6825.876 95 967 447.100 1985 4 94 1 6799.781 452.100 9.900 97.633 1986 470.267 1986 2 6802.497 97.933 95 30.567 1986 6892.144 98.000 3 96 484033 10.367 1986 99.133 97 4 499.067 7048982 10.133 1987 7189.896 1 98 100.100 9.367 S10.367 $19.200 1987 7339.893 2 99 101.100 8.533 1987 3 7483371 100 $28.000 7567 302.533 1987 4 7612.668 101 7433 103.500 537.300 541.667 1988 1 102 7.433 7686.059 7749.151 104.400 105.300 1988 2 103 7300 547-800 1988 3 7824247 104 7223 306,257 1988 4 7893.136 105 7.300 107.233 562.400 575933 596.200 1989 1 8013674 105 107 900 7.200 7033 1989 2 8073 239 107 209 DOO 613.267 626.700 1989 3 8148.603 IOS 7030 309 567 4 109 7.167 8185303 8263.639 052200 678.500 1 110 6.967 1989 1990 1990 1920 109.033 109.700 110467 2 8308.021 151 6233 708333 > 369 930 112 6600 731567 744.300 19990 4 460.223 113 6.267 1991 1 114 6.000 113.00 113.067 124.367 115335 116233 8333615 5680.162 745.167 2 115 3830 753.200 1991 1991 8725000 116 200 4 5839541 117 117.363 7722700 1991 1 8533.635 114 6.000 114267 745.167 1991 2 8680.162 115 5833 115.333 753.200 1991 3 8725.006 116 5.700 116.233 758.567 1991 4 8839.641 117 5.467 117.567 772.700 1992 1 8891.435 118 5.467 119.000 782.800 1992 2 9009.913 119 5.333 120 300 784.967 1992 3 9101.508 120 5.200 121.667 784.167 775.900 1992 4 9170.977 121 5.233 123.633 1993 9238.923 122 5.233 124.600 779.400 1993 2 9257.128 123 5367 125.867 789.133 1993 3 9358.289 124 5.300 128.033 798.333 1993 4 125 5333 129.300 806.367 1994 1 126 5.700 131533 815.333 1994 2 9392.251 9398 499 9312.937 9269367 9341.642 127 6.133 333.767 822 233 1994 3 128 6.600 134.767 832.833 1994 4 129 6.833 135 567 849533 36633 1995 1 9388,845 130 136.500 1995 6.867 7.100 2 9421565 131 137.733 887533 1995 3 9534.346 132 7.367 924.100 1995 138.667 139.733 4 9637.732 133 7.600 949.567 1996 1 9732979 134 7.633 140.800 975.000 1996 2 9834.510 135 7367 142.033 3 136 7.133 1996 1996 143.067 9850 973 9908.347 1014.767 1034.100 1062 867 4 137 7067 144.100 1997 1 9955.641 138 6.800 144.767 1094333 1997 2 10091.049 139 6.633 145.967 1122.267 3 10188954 140 1997 1997 6.567 6200 4 141 10327.019 10387382 1998 1 146.700 147533 148.900 349.767 142 1136.000 1143 200 1151.067 1150.600 6.000 1995 2 143 5633 10506372 10543.654 3 144 5.467 1998 1995 150 567 4 10575.100 145 . 152.100 1 | DESTWO 1446 5.667 1999 1999 152.567 142 5367 1348 300 1 146.267 1132.967 1121313 1318833 153.700 1999 10737478 30817 996 10998322 3 145 5533 155067 4 156.00 1999 1 10665.080 146 5.667 152.867 1144.300 1999 2 10737.478 147 153.700 1132.967 5567 5533 1999 3 10817.896 148 155067 1121533 1999 4 10998372 149 5.500 156.400 1118.833 2000 1 11096976 150 5.267 1103.400 157300 158.667 2000 2 11212205 151 5333 1083.500 2000 3 11284.587 152 5.233 159.633 1077500 2000 4 153 5.000 160.000 1064.600 11472.137 11615,636 2001 1 154 4867 160.800 1069233 . 2001 2 11715393 155 4.687 161.667 1069.600 2001 3 156 4633 162.000 1076.233 11832.486 11942.032 2001 4 157 4.400 162.533 1077 300 2002 1 12091 614 158 4533 163.367 1076.967 2002 2 12287.000 159 4.433 164.133 1091.967 2002 3 12403.293 160 4300 164.733 1097.133 2002 4 161 4.267 165.967 1101.733 12498.694 12662 385 2003 1 162 4.233 167,200 1098.267 2003 2 12877593 163 4.067 168.433 1112.067 2003 12924.179 164 4.033 170.100 1112.767 2003 4 13160.842 165 3.933 171433 1107.733 2004 1 13178 419 166 4.000 1101.133 2004 2 173.000 174 233 167 3.900 13260.506 13222.680 2004 3 168 1093.233 1102.300 4.233 175 900 2004 4 13299.984 4.400 177.133 2005 169 120 1 1120467 1164.867 4833 177.633 2 13244.784 13280.859 13397.002 2005 2005 171 5500 1173 233 3 5.200 1191 500 122 123 4 177.500 278.067 179.467 180433 5833 1189.767 1 174 5733 2005 2006 2006 2006 2006 2 175 13478.152 13538 072 13559.032 13634 253 13751543 13985073 181 500 3 5.567 5867 196 183.167 1194.100 1211233 1235 000 1266,333 4 127 6.133 2007 1 175 6130 183D67 184433 185.133 1293.613 2 14145.645 2007 2007 179 5803 3 14221.147 150 186.700 730100 1378.933 1336.100 2007 4 5700 5.600 14329.523 151 188.167 2007 1 13985073 178 6.133 184433 1293.633 2007 2 14145.645 179 5.833 185.133 1301.033 2007 3 14221.147 180 5.700 186.700 2007 1318.933 1336.100 4 181 5.600 188.167 2008 1 14329 523 14464984 14609.876 182 5433 189.367 1352.267 2008 2 183 5.433 191.400 1370.900 2008 3 14771.602 184 5300 192367 1370.267 2008 4 14839.782 185 5.100 193.667 1367833 2009 1 186 4967 196.600 14972054 15066.597 2009 1374433 1375 800 2 187 4.967 198.433 2009 3 15267026 188 4.733 199 467 2009 1381.533 1380.867 4 15302.705 189 4.633 201.267 2010 1 15326368 190 4.633 203.167 1368 567 2010 2 15456.928 191 4.433 202333 1369 400 2010 3 15493 328 192 4.500 204317 1368 867 2010 4 15582.085 193 4500 206,631 1375.167 2011 1 15666.738 194 4.667 1372.900 2011 2 207.939 210.490 15761.967 195 4.800 1375.100 2011 3 15671.383 196 212.770 1384.500 2011 4 15752308 197 215.538 1395.833 5.000 5.333 6.000 6.867 2012 1 15667032 198 218.861 1428.133 2012 2 199 213.849 15328.027 15155940 2012 3 1530.300 1579.300 200 8.267 212.378 2012 4 201 9300 1628533 2013 15134.117 15189 222 15356.058 213.507 215344 1 202 9.633 3660.000 2013 2 203 9.933 1684533 217.030 217.374 2013 3 204 9833 35415.145 15557.277 4 1698-333 1712.967 205 2013 2014 9.633 1 15671.967 206 9.467 2014 2 15750.625 207 1744.200 1815.067 2014 9.500 9.033 3 217.297 217934 219.699 222.044 224568 226.033 208 1875 033 15712.754 15825.096 2014 4 209 9067 1 1931.200 2079 033 15820.700 210 2015 2015 9.000 2 16004.107 211 8633 227017 2015 3 16129418 212 2356.800 2235733 8.267 228.326 2015 4 16198 307 213 8.200 228 SOK 2260.367 2016 1 16220 567 214 KO 229 341 225.000 2012 4 15134.117 201 9.300 213.507 1628533 2013 1 15189.222 202 9.633 215344 1660.000 2013 2 15356.058 203 9.933 217030 1684.533 2013 15415.145 204 9.833 217374 1698 333 2013 4 15557.277 205 9.633 217.297 1712.967 2014 1 15671.967 206 9.467 217934 1744 200 2 15750.625 207 9.500 1815.067 2014 2014 219.699 222054 3 15712.754 9,033 1875.033 2014 4 15825.096 209 9.067 1931.200 224566 226.033 1 15820.700 210 9.000 2079.033 2015 2015 2 18004.107 211 8,633 2270472156.600 2015 3 16129 A18 212 8.267 228 326 2215.733 2260.367 2015 4 213 8.200 228 SOS 16198.807 16220.667 2016 L 214 8.0 229 841 2351.000 2016 2 16239.138 215 7.800 231.369 232.299 2435 233 2476,633 2016 3 16382.964 216 7.733 4 217 7.533 2016 2017 232.045 16403.180 16531.685 ] 218 7.233 233.300 2525.733 2559.767 2636.767 2017 2 16663 649 219 6.933 234.163 2017 3 16621.696 220 6.667 6,233 2017 235.608 236.839 2727.167 2801367 4 16830.111 221 2018 1 17033572 222 6.100 238 2834.133 2018 2 17113.945 223 5.700 236.920 2897533 2018 3 224 5567 235.355 2954.600 2018 + 17254.744 17397.029 17438 802 225 5.400 3003 133 236912 237516 1 2019 2019 5.100 3085 211 2 226 222 228 17456 225 17520374 5.000 2019 2 2019 237545 239.452 24058 4 4933 2167 4.933 1 229 230 231 2020 2020 3063 967 3131067 3231 567 3296.700 3342.467 3411 500 2 17622.486 17706.705 74 185 37863023 17995.150 18120.54 4733 3 232 4667 2030 2021 1 4.300 4.100 10 245 293 247301 2 18223.758 215 2021 2021 2021 3 3552.767 3998.567 3641900 3657567 78322963 4100 4 18511.576 237 3.900 250466 . Suppose we conduct a regression with RGDP as the dependent variable and TREND, UR, CPI and M1 as the explanatory variables. Run this regression and test for multicollinearity. If multicollinearity exists, eliminate variables that cause the problem and provide your final model that does not display any multicollinearity. (12 points) RGDP: UR Real GDP in 2012 dollars millions of dollars) Civilian Unemployment Race (percent) Consumer Price Index MI Money Supply (millions of dollars) Trend (observation number CPI: MI: TREND: YEAR QTR RGDP TREND UR CPI MI 1962 4 3192380 3.100 290413 140.533 1963 1 3194 653 2 5.267 29,193 141533 1963 2 3203.759 3 S7600 29 370 14012671 1963 3 3275757 4 5.133 29.997 39.900 1963 4 3258088 52233 29573 19.00 1964 1 3274029 6 5-533 29.590 1:10.9 1964 2 3232.009 6.267 29.780 140/833 1954 3 3253 826 6.100 29 840 141633 1984 4 3309.059 9 7.000 29 830 1621567 1965 1 3372.581 10 6.767 29.97 143:40 1965 2 3438.321 14 6.200 29 30 44.700 1965 3500054 12 5633 30107 145.633 1965 4 353) 683 13 5533 30.220 146.000 1900 1 3575070 14 5.567 30307 246.467 1906 2 3586 827 15 5533 30.380 147.267 1966 3625981 16 5.767 30472 148 800 1966 3666 509 17 5.733 30.533 150.167 1967 1 3747 278 18 5.500 30.720 151.700 1967 2 3771.845 19 5.567 30.803 153.167 1967 3 3851 366 20 5.467 30.930 154.167 1967 4 3893.296 21 5.200 30.980 155.233 1968 1 3954.121 22 5.000 31.050 157.767 1988 2 3966335 23 4.967 31.193 159.833 1968 3 4062.311 24 4.900 31.290 . 161.033 1968 4 4113.629 25 4.667 31.490 161.967 1969 1 4205 086 26 4.367 31.583 163.833 1969 2 4301.973 27 4.100 31.750 166,833 1969 3 4406,693 28 3.867 32.047 169.733 1969 4 4421.747 29 9 mm w% man # * % 3.833 32.337 171.567 1970 1 4459.195 30 3.767 32.617 171.033 1970 2 4495.777 31 3.700 32883 171533 1970 3 4535.591 32 3.833 32.967 173.233 1970 4 4538 370 33 3.833 175.633 1971 1 4581309 33.167 33.500 34 3.800 179.500 1971 2 4615.853 35 3.900 33.867 182.433 1971 3 4709.993 36 3.733 34.200 184.833 1971 4 4788 688 37 3.567 34 533 188.000 1972 1 3.533 35.000 191.667 1972 2 4825.799 4844.779 4920.605 39 3.400 35.433 195 800 1972 3 40 3400 35.862 1972 199.333 4935 564 41 3.433 200.933 1973 1 4968.164 36433 3699; 42 3.567 1973 201.833 2 4943.925 3.567 37.500 1973 3 203.467 4936 594 4.167 38.100 1973 205 633 4 45 4943.600 4989.159 4.767 38.633 1974 1 46 5.167 99.033 1974 207.162 209.900 213667 2 4935.693 E 5.833 1974 39.600 3 35 5.931 1974 39.933 4 217,233 49 5069.746 5097.179 5139.125 3151 245 5.900 1975 40.300 || 221.833 6,033 1975 40.700 225.667 51 5933 Cut 227.767 1975 1 5139.128 6.033 40.700 225.667 2 5151.245 51 5.933 41.000 227.767 1975 1975 3 5245 974 52 5.767 41.333 232.233 1975 4 5365.045 53 5.700 41.600 236,033 1976 1 5415.712 54 41.933 5567 5.367 1976 2 5506.396 3 55 42.367 240.967 246.867 251.800 1976 3 5642.669 56 4933 43.033 1976 4 5704.098 57 4.933 43.933 254.767 1977 1 5674.100 58 4.800 44.800 257.700 1977 2 5727.960 59 4.767 45.933 260.967 1977 3 5678.713 60 5.133 47.300 265.267 1977 4 5692.210 61 5.200 48.567 267.767 1978 1 5638 411 62 5.633 49.933 270.133 1978 2 5616526 63 6,600 51.467 273.400 1978 3 5548.156 64 8.267 52.567 275.100 1978 4 5587.800 65 8.867 279.267 53.200 54.267 1979 1 5683.444 8.467 284.500 1979 2 5759.972 67 8300 286.433 1979 55.267 55.900 3 5889.500 68 7.733 290.633 1979 4 69 7.567 56.400 5932.711 5965.265 1980 1 295.600 298.600 20 7.733 57300 1980 2 7.767 58.133 303.933 6008.504 6079.494 1980 3 72 59.200 311233 1980 7.500 7.133 4 6197 686 mm" 317333 23 7-- 1981 1 6309,514 60 233 61.067 6.900 322333 1981 2 6309.652 75 6.667 61.967 328.633 1981 3 76 6329.791 6574390 63033 1981 6.333 6.000 4. 77 335 567 343.900 64.467 1982 1 6640.497 78 6033 349.800 1982 2 6729.755 65.967 67.500 79 355 333 1982 3 6741854 5900 5.867 1982 4 6749263 69.200 21400 360.333 370.333 1963 1 82 5.700 5.567 5967 378.433 1983 6799-200 6816.203 6837661 2 83 73.700 76037 79.033 3 1983 1983 6300 381.133 388.100 4 6696.753 HS 7.333 81.700 580 - 5.867 82 378.433 73.700 1983 1 6799 200 5.967 83 76.033 381.133 1983 2 6816.203 84 6.300 29.033 388.100 1983 6837.641 3 7333 81.700 385.900 85 1983 4 6696.753 86 7.667 83.233 399.333 1984 1 6688.794 7.400 85.567 409.400 87 1984 2 6813.535 88 7.433 87.933 415.033 1984 6947042 3 89 7.400 425.767 89.767 1984 6895.559 4 90 7.400 6978.135 92.267 426.933 1985 1 . 8.233 91 6902.105 93.767 432.133 1985 2 442.433 8.833 94.600 1985 6794.878 3 92 93 9.433 6825.876 95 967 447.100 1985 4 94 1 6799.781 452.100 9.900 97.633 1986 470.267 1986 2 6802.497 97.933 95 30.567 1986 6892.144 98.000 3 96 484033 10.367 1986 99.133 97 4 499.067 7048982 10.133 1987 7189.896 1 98 100.100 9.367 S10.367 $19.200 1987 7339.893 2 99 101.100 8.533 1987 3 7483371 100 $28.000 7567 302.533 1987 4 7612.668 101 7433 103.500 537.300 541.667 1988 1 102 7.433 7686.059 7749.151 104.400 105.300 1988 2 103 7300 547-800 1988 3 7824247 104 7223 306,257 1988 4 7893.136 105 7.300 107.233 562.400 575933 596.200 1989 1 8013674 105 107 900 7.200 7033 1989 2 8073 239 107 209 DOO 613.267 626.700 1989 3 8148.603 IOS 7030 309 567 4 109 7.167 8185303 8263.639 052200 678.500 1 110 6.967 1989 1990 1990 1920 109.033 109.700 110467 2 8308.021 151 6233 708333 > 369 930 112 6600 731567 744.300 19990 4 460.223 113 6.267 1991 1 114 6.000 113.00 113.067 124.367 115335 116233 8333615 5680.162 745.167 2 115 3830 753.200 1991 1991 8725000 116 200 4 5839541 117 117.363 7722700 1991 1 8533.635 114 6.000 114267 745.167 1991 2 8680.162 115 5833 115.333 753.200 1991 3 8725.006 116 5.700 116.233 758.567 1991 4 8839.641 117 5.467 117.567 772.700 1992 1 8891.435 118 5.467 119.000 782.800 1992 2 9009.913 119 5.333 120 300 784.967 1992 3 9101.508 120 5.200 121.667 784.167 775.900 1992 4 9170.977 121 5.233 123.633 1993 9238.923 122 5.233 124.600 779.400 1993 2 9257.128 123 5367 125.867 789.133 1993 3 9358.289 124 5.300 128.033 798.333 1993 4 125 5333 129.300 806.367 1994 1 126 5.700 131533 815.333 1994 2 9392.251 9398 499 9312.937 9269367 9341.642 127 6.133 333.767 822 233 1994 3 128 6.600 134.767 832.833 1994 4 129 6.833 135 567 849533 36633 1995 1 9388,845 130 136.500 1995 6.867 7.100 2 9421565 131 137.733 887533 1995 3 9534.346 132 7.367 924.100 1995 138.667 139.733 4 9637.732 133 7.600 949.567 1996 1 9732979 134 7.633 140.800 975.000 1996 2 9834.510 135 7367 142.033 3 136 7.133 1996 1996 143.067 9850 973 9908.347 1014.767 1034.100 1062 867 4 137 7067 144.100 1997 1 9955.641 138 6.800 144.767 1094333 1997 2 10091.049 139 6.633 145.967 1122.267 3 10188954 140 1997 1997 6.567 6200 4 141 10327.019 10387382 1998 1 146.700 147533 148.900 349.767 142 1136.000 1143 200 1151.067 1150.600 6.000 1995 2 143 5633 10506372 10543.654 3 144 5.467 1998 1995 150 567 4 10575.100 145 . 152.100 1 | DESTWO 1446 5.667 1999 1999 152.567 142 5367 1348 300 1 146.267 1132.967 1121313 1318833 153.700 1999 10737478 30817 996 10998322 3 145 5533 155067 4 156.00 1999 1 10665.080 146 5.667 152.867 1144.300 1999 2 10737.478 147 153.700 1132.967 5567 5533 1999 3 10817.896 148 155067 1121533 1999 4 10998372 149 5.500 156.400 1118.833 2000 1 11096976 150 5.267 1103.400 157300 158.667 2000 2 11212205 151 5333 1083.500 2000 3 11284.587 152 5.233 159.633 1077500 2000 4 153 5.000 160.000 1064.600 11472.137 11615,636 2001 1 154 4867 160.800 1069233 . 2001 2 11715393 155 4.687 161.667 1069.600 2001 3 156 4633 162.000 1076.233 11832.486 11942.032 2001 4 157 4.400 162.533 1077 300 2002 1 12091 614 158 4533 163.367 1076.967 2002 2 12287.000 159 4.433 164.133 1091.967 2002 3 12403.293 160 4300 164.733 1097.133 2002 4 161 4.267 165.967 1101.733 12498.694 12662 385 2003 1 162 4.233 167,200 1098.267 2003 2 12877593 163 4.067 168.433 1112.067 2003 12924.179 164 4.033 170.100 1112.767 2003 4 13160.842 165 3.933 171433 1107.733 2004 1 13178 419 166 4.000 1101.133 2004 2 173.000 174 233 167 3.900 13260.506 13222.680 2004 3 168 1093.233 1102.300 4.233 175 900 2004 4 13299.984 4.400 177.133 2005 169 120 1 1120467 1164.867 4833 177.633 2 13244.784 13280.859 13397.002 2005 2005 171 5500 1173 233 3 5.200 1191 500 122 123 4 177.500 278.067 179.467 180433 5833 1189.767 1 174 5733 2005 2006 2006 2006 2006 2 175 13478.152 13538 072 13559.032 13634 253 13751543 13985073 181 500 3 5.567 5867 196 183.167 1194.100 1211233 1235 000 1266,333 4 127 6.133 2007 1 175 6130 183D67 184433 185.133 1293.613 2 14145.645 2007 2007 179 5803 3 14221.147 150 186.700 730100 1378.933 1336.100 2007 4 5700 5.600 14329.523 151 188.167 2007 1 13985073 178 6.133 184433 1293.633 2007 2 14145.645 179 5.833 185.133 1301.033 2007 3 14221.147 180 5.700 186.700 2007 1318.933 1336.100 4 181 5.600 188.167 2008 1 14329 523 14464984 14609.876 182 5433 189.367 1352.267 2008 2 183 5.433 191.400 1370.900 2008 3 14771.602 184 5300 192367 1370.267 2008 4 14839.782 185 5.100 193.667 1367833 2009 1 186 4967 196.600 14972054 15066.597 2009 1374433 1375 800 2 187 4.967 198.433 2009 3 15267026 188 4.733 199 467 2009 1381.533 1380.867 4 15302.705 189 4.633 201.267 2010 1 15326368 190 4.633 203.167 1368 567 2010 2 15456.928 191 4.433 202333 1369 400 2010 3 15493 328 192 4.500 204317 1368 867 2010 4 15582.085 193 4500 206,631 1375.167 2011 1 15666.738 194 4.667 1372.900 2011 2 207.939 210.490 15761.967 195 4.800 1375.100 2011 3 15671.383 196 212.770 1384.500 2011 4 15752308 197 215.538 1395.833 5.000 5.333 6.000 6.867 2012 1 15667032 198 218.861 1428.133 2012 2 199 213.849 15328.027 15155940 2012 3 1530.300 1579.300 200 8.267 212.378 2012 4 201 9300 1628533 2013 15134.117 15189 222 15356.058 213.507 215344 1 202 9.633 3660.000 2013 2 203 9.933 1684533 217.030 217.374 2013 3 204 9833 35415.145 15557.277 4 1698-333 1712.967 205 2013 2014 9.633 1 15671.967 206 9.467 2014 2 15750.625 207 1744.200 1815.067 2014 9.500 9.033 3 217.297 217934 219.699 222.044 224568 226.033 208 1875 033 15712.754 15825.096 2014 4 209 9067 1 1931.200 2079 033 15820.700 210 2015 2015 9.000 2 16004.107 211 8633 227017 2015 3 16129418 212 2356.800 2235733 8.267 228.326 2015 4 16198 307 213 8.200 228 SOK 2260.367 2016 1 16220 567 214 KO 229 341 225.000 2012 4 15134.117 201 9.300 213.507 1628533 2013 1 15189.222 202 9.633 215344 1660.000 2013 2 15356.058 203 9.933 217030 1684.533 2013 15415.145 204 9.833 217374 1698 333 2013 4 15557.277 205 9.633 217.297 1712.967 2014 1 15671.967 206 9.467 217934 1744 200 2 15750.625 207 9.500 1815.067 2014 2014 219.699 222054 3 15712.754 9,033 1875.033 2014 4 15825.096 209 9.067 1931.200 224566 226.033 1 15820.700 210 9.000 2079.033 2015 2015 2 18004.107 211 8,633 2270472156.600 2015 3 16129 A18 212 8.267 228 326 2215.733 2260.367 2015 4 213 8.200 228 SOS 16198.807 16220.667 2016 L 214 8.0 229 841 2351.000 2016 2 16239.138 215 7.800 231.369 232.299 2435 233 2476,633 2016 3 16382.964 216 7.733 4 217 7.533 2016 2017 232.045 16403.180 16531.685 ] 218 7.233 233.300 2525.733 2559.767 2636.767 2017 2 16663 649 219 6.933 234.163 2017 3 16621.696 220 6.667 6,233 2017 235.608 236.839 2727.167 2801367 4 16830.111 221 2018 1 17033572 222 6.100 238 2834.133 2018 2 17113.945 223 5.700 236.920 2897533 2018 3 224 5567 235.355 2954.600 2018 + 17254.744 17397.029 17438 802 225 5.400 3003 133 236912 237516 1 2019 2019 5.100 3085 211 2 226 222 228 17456 225 17520374 5.000 2019 2 2019 237545 239.452 24058 4 4933 2167 4.933 1 229 230 231 2020 2020 3063 967 3131067 3231 567 3296.700 3342.467 3411 500 2 17622.486 17706.705 74 185 37863023 17995.150 18120.54 4733 3 232 4667 2030 2021 1 4.300 4.100 10 245 293 247301 2 18223.758 215 2021 2021 2021 3 3552.767 3998.567 3641900 3657567 78322963 4100 4 18511.576 237 3.900 250466

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Investing

Authors: Scott B. Smart, Lawrence J. Gitman, Michael D. Joehnk

12th edition

978-0133075403, 133075354, 9780133423938, 133075400, 013342393X, 978-0133075359

More Books

Students also viewed these Finance questions

Question

Explain why the FOMC is the key policy group within the Fed.

Answered: 1 week ago

Question

What is Ramayana, who is its creator, why was Ramayana written?

Answered: 1 week ago

Question

To solve by the graphical methods 2x +3y = 9 9x - 8y = 10

Answered: 1 week ago