please answer in excel with data provided. will rate

1. Suppose we conduct a regression with RGDP as the dependent variable and TREND, UR, CPI and M1 as the explanatory variables. We wish to test this model for heteroscedasticity. Use the White test and the modified White's test at the 0.10 level to determine whether heteroscedasticity exists. If heteroscedasticity exists, what variables might be causing it based on your regression results? You do not need to try and correct for heteroseedasticity in this problem. (20 points) YEAR QTR 1963 1963 1963 1963 1964 1964 1964 1964 1965 1965 1965 1965 1966 1966 9961 1966 1967 1967 1967 1967 1968 1968 1968 1968 1969 1969 6961 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1969 1970 1970 1920 1970 1971 1971 1971 1971 1972 1922 1972 1972 4 View as Page 1 2 3 RGDP 4 1 2 3 4 1 2 TREND 3192.380 3194.653 3203.759 3275.757 3258.088 3274.029 3232.009 3253.826 3309.059 3372.581 3438.721 3500.054 3531.683 3575.070 3586.827 3625.981 3666.669 3747 278 3771845 3851.366 3893.296 3954.121 3966.335 4062 311 4113.629 4205 086 4301.973 4406 693 4421.747 4459 195 4495.777 4535.591 4538.370 4581309 4615853 4709.99) 4788.688 4825.799 4844.779 4920605 225228ASANGARRE 16 18 37 38 39 43 15 19 20 21 32 33 34 35 36 17 23 24 26 30 27 31 29 10 11 12 13 14* 1 2 3 8 4 5 6 7 6 UR 5.100 5.267 5.600 5.133 5.233 5.533 6.267 6.800 7.000 6.767 6.200 5.633 5.533 5.567 5.533 5,767 5.733 5.500 5.567 5.467 5.200 5.000 4.967 4.900 4.667 4.100 3.867 3.833 3.767 3.700 3.833 3833 3.300 3900 3.733 3.567 3.533 1.400 3.400 CPI 29.043 29.193 29.370 29.397 29.573 29.590 29.780 29.840 29.830 29.947 29.990 30.107 30.220 30.307 30.380 30.477 30.533 30.720 30.803 30.930 30.980 31.050 31.193 31.290 31.490 31.583 31.750 32.047 32.337 32.617 32.883 32.967 33.167 33.500 33.867 34.200 34.533 35.000 35.433 35.867 MI 140.533 141.533 140.267 139.900 139.600 140.900 140.833 141.533 142.567 143.400 144.700 145.633 146.600 146.467 147.267 148.800 150.167 151.700 153.167 154.167 155.233 157.767 159.833 161.033 161.967 163.833 166.833 169.733 171.567 171.033 171.533 173.233 175.633 179.500 182.433 184.833 188.000 191667 195.800 199.333 1972 1973 1973 1973 1973 1974 1974 1974 1974 1975 1975 1975 1975 1976 1976 1976 1976 1977 1977 1977 1977 1978 1978 1978 1978 1979 1979 1979 1979 1980 1960 1980 1980 1981 1941 1941 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 1981 1992 192 4 View as Page 4 1 2 3 4920.605 4935.564 4968.164 4943.935 4936.594 4943.600 4989.159 4935.693 5069.746 5097.179 5139.128 5151.245 5245.974 5365.045 5415.712 5506.396 5642.669 5704,098 5674.100 5727960 5678.713 5692.210 5638411 5616526 5548.156 5587.800 5683.444 5759972 5889.500 5932711 5965 265 6008504 6079.494 9990619 6309.514 630952 6329.791 6574.390 66-4LAVT 4729.355 SREFFZREFERE A 56 57 58 59 60 61 62 63 64 65 66 67 68 51 52 53 54 55 69 70 71 72 48 49 50 73 74 75 76 77 40 41 42 43 44 45 46 47 29 3.400 3.433 3.567 3.567 4.167 4.767 5.167 5.833 5.933 5.900 6.033 5.933 5.767 5.700 5.567 5.367 4.933 4.933 4.800 4,767 5.133 5.200 5.633 0099 8,267 8.867 8.467 8.300 7.333 -7.567 7.733 7.767 7.500 7.133 6.900 6.667 6.333 6.033 5.000 35.867 36.433 36.933 37.500 38.100 38.633 39.033 39.600 39.933 40.300 40.700 41.000 41.333 41.600 41.933 42.367 43.033 43.933 44.800 45.933 47.300 48 567 49.933 51.467 52.567 53.200 54.267 55.267 55.900 56.400 57,300 58.133 59.200 60.233 61.067 61967 63.033 64.467 65.967 63.500 60.200 199.333 200.933 201.833 203.467 205.633 207.167 209.900 213.667 217.233 221.833 225.667 227.767 232 233 236.033 240.967 246.867 251.800 254.767 257.700 260.967 265.267 267.767 270.133 273.400 275.100 279.267 284.500 286.433 290.633 295.600 298.000 303.933 311.233 317.333 322.333 328.633 335.567 343.900 349.300 355,333 3601 333 1983 1983 1983 1983 1984 1984 1984 1984 1985 1985 1985 1985 1986 1986 1986 1986 1987 1987 1987 1987 1988 1988 1988 1988 1989 1989 1989 1989 1990 1990 1990 1990 1991 1991 1991 1991 1992 1992 1992 1992 1 View as Page 1 2 3 4 I 2 3 4 I 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 14 6749.063 6799.200 6816.203 6837.641 6696.753 6688.794 6813.535 6947042 6895.559 6978.135 6902.105 6794.878 6825.876 6799.781 6802.497 6892.144 7048982 7189.896 7339.893 7483.371 7612.668 7686.059 7749.151 7824.247 7893.136 8013674 8073.239 8148.603 8185.303 8263.639 8308.021 8369.930 8460 233 8533.635 8680.162 900 STER 8839641 8891435 9009913 9101.508 9170.977 81 82 83 84 85 858 98 87 89 06 91 92 93 94 95 96 97 98 66 100 101 102 103 104 105 106 107 108 109 110 THE 112 113 114 115 116 117 118 119 120 121 5.700 5.867 5.967 6.300 7.333 7.667 7,400 7.433 7.400 7.400 8.233 8.833 9433 9.900 10.667 10.367 10.133 9.367 8.533 7.867 7.433 7.433 7.300 7.233 7.300 7.200 7033 7033 7.167 6.967 6.833 0099 6.267 6.000 5.833 5.700 3.467 5.467 5.335 5.200 5233 71.400 73.700 76.033 79.033 81.700 83.233 85.567 87.933 89.767 92.267 93.767 94.600 95.967 97.633 97.933 98.000 99.133 100.100 101.100 102.533 103.500 104.400 105.300 106.267 107.233 107.900 109.000 109.567 109.033 109.700 110.467 111.800 113,067 114.267 115.333 116.233 117.567 119.000 120300 121.667 123633 370.333 378.433 381.133 388.100 385.900 399.333 409,400 415.033 425.767 426.933 432.133 442.433 447.100 452.100 470.267 484.033 499.067 510.367 519.200 528.000 537.300 541.667 547.600 562.400 $75.933 596.200 613.267 626.700 651.200 678.500 708.333 731567 744,300 745.167 753.200 758.567 772.700 782.800 784.967 775.900 9238.923 9257.128 9358.289 9392.251 9398.499 9312.937 9269.367 9341.642 9388.845 9421.565 9534.346 9637.732 9732.979 1996 9834.510 1996 9850.973 1997 9908.347 1997 9955.641 1997 10091.049 1997 10188.954 1998 10327.019 1998 10387.382 1998 10506.372 1998 10543.644 1999 10575.100 1999 10665060 1999 10737478 10817.896 2000 10998.322 2000 2 11096.976 2000 3 11212.205 2000 4 11284587 2001 11472 137 2001 11615.636 2001 11715.393 2001 11832486 2002 11942.032 2002 2 12091514 3 12287.000 12403293 200 1 2003 2008 12498094 31 View as Page 1993 1993 1993 1994 1994 1994 1994 1995 1995 1995 1995 1996 9661 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 T 2 3 4 1 1 3 4 1 VIC OPALE 122 123 124 125 126 127 128 129 1.30 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 363 5.233 5.367 5.300 5.333 5.700 6.133 6.600 6.833 6.867 7.100 7367 7.600 7.633 7.367 7.133 7.067 6.800 6.633 6.567 6.200 6.000 5.633 5.467 5.667 5.667 5567 5533 5.500 5267 5.333 5.233 5.000 4367 4.667 4633 4,400 4533 4433 4.267 124.600 125.867 128.033 129.300 131.533 133.767 134.767 135.567 136.600 137.733 138.667 139.733 140.800 142.033 143.067 144.100 144.767 145.967 146.700 147.533 148.900 149.767 150.367 152.100 152.867 153.700 155.067 156.400 157.300 158.567 159.633 160.000 360.800 161.667 162.000 163.367 164.333 147 300 779.400 789.133 798.333 806.367 815.333 822.233 832.833 849.533 866.033 887.533 924.100 949.567 975.000 1014.767 1034.100 1062.867 1094.333 1122.267 1136.000 1143.200 1151.067 1150.600 1148.500 1146.267 1144.300 1132.967 1121533 1118.833 1103.400 1083.500 1077.500 1064.600 1069 233 1069.500 1077.300 1076.967 3097.133 1101.733 MAX 262 2 12662.385 3 12877.593 12924.179 13160.842 13178.419 13260.506 13222.690 13299.984 13244.784 13280859 4 13397.002 1 13478.152 2 13538.072 3 13559.032 4 13634 253 I 13751.543 2 13985.073 3 14145.645 4 14221.147 1 14329.523 2 14464984 3 14609 876 4 14771.602 14839.782 14972054 15066.597 15267.026 15302.705 15326 368 15456928 15493328 15582.085 15666.738 15761.967 15671.383 15752.308 15667032 15328.027 15155940 13134117 15189222 2003 2003 2003 2004 2004 2004 2004 2005 2005 2005 2005 2006 2006 2006 2006 2007 2007 2007 2007 2008 2008 2008 2008 2009 2009 2009 2009 2010 2010 2010 2010 2011 2011 2011 2011 2012 2012 2012 2012 2013 2013 2 View as Page 4 1 2 3 4 1 2 3 1 2 3 4 1 2 3 4 1 2 E 4 1 2 3 4 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176" 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 197 198 199 200 201 4.233 4067 4.033 3.933 4.000 3.900 4.233 4.400 4.833 5.500 5.700 5.833 5.733 5.867 5.867 6.133 6.133 5.833 5.700 5.600 5.433 5.433 5.300 5.100 4967 4.967 4.733 4633 4.633 4433 4.500 4.500 4667 4.800 5000 5.333 6.000 6367 8267 9300 9433 167,200 168.433 170.100 171.433 173.000 174.233 175.900 177.133 177.633 177.500 178.067 179.467 180.433 181.500 183.367 183.067 184.433 185.133 186.700 188.167 189.367 191.400 192.367 193.667 196.600 198.433 199.467 201 267 203 167 202.333 204317 206.631 207939 210.490 212.770 215.538 218.861 213.849 212378 213.507 215.344 1098.267 1112.067 1112.767 1107.733 1101.133 1093.233 1102.300 1120.467 1164.867 1173.233 1191.500 1189.767 1194.100 1211,233 1235.000 1266.533 1293,633 1301.033 1318.933 1336.100 1352.267 1370.900 1370.267 1367.833 1374433 1375.800 1381.533 1380867 1368.567 1369.400 1368.867 1375 167 1372.900 1375.100 1384.500 1395833 3428333 1530.300 1579 300 1628.538 1660.000 T 15752308 2 15667.032 3 15328.027 4 15155.940 1 15134.117 2 15189.222 3 15356.058 15415.145 15557.277 15671.967 15750.625 15712.754 15825.096 15820.700 16004.107 16129.418 16198.807 16220.667 16239.138 16382.964 16403.180 2 16531.685 3 16663.649 4 16621.696 1 16830.111 2 17033.572 3 17113.945 4 17254.744 17397029 17438.802 17456 225 17523.374 17622 486 17706.705 17784.185 17863 023 17995 150 18120843 18225.758 18325.963 18511 576 2012 2012 2012 2012 2013 2013 2013 2013 2014 2014 2014 2014 2015 2015 2015 2015 2016 2016 2016 2016 2017 2017 2017 2017 2018 2018 2018 2018 2019 2019 2019 2019 2020 2020 2020 2020 2021 2021 2021 2021 2002 View Dr 4 1 2 3 4 1 2 3 4 1 2 3 4 1 1 2 3 4 1 2 3 4 1 2 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 3.355 6.000 6.867 8.267 9.300 9.633 9.933 9.833 9.633 9.467 9.500 9.033 9.067 9.000 8.633 8.267 8.200 8.033 7.800 7.733 7.533 7.233 6.933 6.667 6.233 6.100 5,700 5.567 $400 5.100 5.000 4.933 4.367 4933 4.667 4.333 4.300 4.100 4.100 3.500 213.338 218.861 213.849 212.378 213.507 215.344 217.030 217.374 217.297 217.934 219.699 222.044 224.568 226.033 227.047 228.326 228.808 229.841 231.369 232.299 232.045 233.300 234.163 235.608 236.839 237459 236.920 235.355 236.912 237.816 237.888 237 848 239452 240 548 242.177 243949 244010 245.297 247.301 249.442 250,468 1428.133 1530.300 1579.300 1628.533 1660.000 1684.533 1698.333 1712.967 1744.200 1815.067 1875.033 1931.200 2079.033 2156.600 2215.733 2260.367 2351.000 2435.233 2476.633 2525.733 2559.767 2636.767 2727.167 2801.367 2834.133 2897.533 2984.600 3003.133 3035.233 3063.967 3131.067 3231-567 3296.700 3342.467 3411.500 3483.433 3552.767 3598.967 3641.900 367 367