Regression with excel

User Generated

Hmv727

Mathematics

Description

See attachments.See attachments.See attachments.See attachments.See attachments.See attachments.See attachments.See attachments.See attachments.See attachments.See attachments.See attachments.See attachments.See attachments.See attachments.See attachments.

Unformatted Attachment Preview

Data Source World Development Indicators Last Updated Date 12/22/2015 http://data.worldbank.org/indicator Year Country Name Afghanistan Albania Algeria American Samoa Andorra Angola Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Bahamas, The Bahrain Bangladesh Barbados Belarus Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Darussalam Bulgaria Burkina Faso Burundi Cabo Verde Cambodia Cameroon Canada Cayman Islands Central African Republic Chad Channel Islands Chile China Country Code AFG ALB DZA ASM AND AGO ATG ARG ARM ABW AUS AUT AZE BHS BHR BGD BRB BLR BEL BLZ BEN BMU BTN BOL BIH BWA BRA BRN BGR BFA BDI CPV KHM CMR CAN CYM CAF TCD CHI CHL CHN per capita GDP 666.7950511 4411.258241 5491.614414 42806.52255 5900.52957 13342.085 14443.06565 3716.828923 67627.77333 50557.80381 7811.621418 22315.60365 24378.94483 954.3963997 15153.82138 7722.123351 46625.31752 4719.137955 882.6386333 85748.06541 2383.04473 2948.032918 4666.219586 6882.258373 11711.0044 39151.23423 7656.638506 708.8416819 259.3652082 3623.22243 1024.60887 1331.200021 52305.25839 326.4371085 985.0952473 15741.71166 6991.853866 Colombia Comoros Congo, Dem. Rep. Congo, Rep. Costa Rica Cote d'Ivoire Croatia Cuba Curacao Cyprus Czech Republic Denmark Djibouti Dominica Dominican Republic Ecuador Egypt, Arab Rep. El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Faeroe Islands Fiji Finland France French Polynesia Gabon Gambia, The Georgia Germany Ghana Greece Greenland Grenada Guam Guatemala Guinea Guinea-Bissau Guyana Haiti Honduras Hong Kong SAR, China Hungary Iceland India Indonesia COL COM COD COG CRI CIV HRV CUB CUW CYP CZE DNK DJI DMA DOM ECU EGY SLV GNQ ERI EST ETH FRO FJI FIN FRA PYF GAB GMB GEO DEU GHA GRC GRL GRD GUM GTM GIN GNB GUY HTI HND HKG HUN ISL IND IDN 8027.97816 796.7645736 413.6970577 3205.457783 10461.57682 1447.222821 13574.97804 6789.849597 27910.61983 19813.87157 59818.63153 1683.429923 7036.548388 5968.669476 6051.611129 3104.219707 3998.739499 21497.89443 19155.42125 503.9026066 54117.84438 4765.658997 49492.82806 42627.65244 10658.77273 484.1126879 3596.90832 46441.67713 1827.101368 21719.22796 7956.141831 3432.022106 521.5389059 538.7338705 3918.40629 810.3265496 2356.516704 38364.1949 13585.43018 47493.24904 1455.102191 3623.53236 Iran, Islamic Rep. Iraq Ireland Isle of Man Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Korea, Dem. Rep. Korea, Rep. Kosovo Kuwait Kyrgyz Republic Lao PDR Latvia Lebanon Lesotho Liberia Libya Liechtenstein Lithuania Luxembourg Macao SAR, China Macedonia, FYR Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands Mauritania Mauritius Mexico Micronesia, Fed. Sts. Moldova Monaco Mongolia Montenegro Morocco Mozambique Myanmar Namibia IRN IRQ IRL IMN ISR ITA JAM JPN JOR KAZ KEN KIR PRK KOR KSV KWT KGZ LAO LVA LBN LSO LBR LBY LIE LTU LUX MAC MKD MDG MWI MYS MDV MLI MLT MHL MRT MUS MEX FSM MDA MCO MNG MNE MAR MOZ MMR NAM 6631.29827 6882.406872 51814.8593 36281.1999 35420.87761 5226.090903 38633.70806 5200.285397 13611.53736 1257.202838 1556.525787 25997.88105 3890.300665 48463.15167 1282.437162 1700.987378 15025.80932 9870.486278 1064.828322 453.339457 10454.79255 15692.01291 113726.639 90331.81913 5195.283488 462.9739991 239.8697314 10973.65594 7100.915779 659.5201611 22776.19469 3602.853944 1306.007652 9479.86959 10172.72255 3044.077373 2243.979662 4387.707056 7186.429787 3156.17515 605.2344447 1106.983824 5435.48932 Nepal Netherlands New Caledonia New Zealand Nicaragua Niger Nigeria Northern Mariana Islands Norway Oman Pakistan Palau Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Puerto Rico Qatar Romania Russian Federation Rwanda Samoa San Marino Sao Tome and Principe Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Sint Maarten (Dutch part) Slovak Republic Slovenia Small states Solomon Islands Somalia South Africa South Sudan Spain Sri Lanka St. Kitts and Nevis St. Lucia St. Martin (French part) St. Vincent and the Grenadines NPL NLD NCL NZL NIC NER NGA MNP NOR OMN PAK PLW PAN PNG PRY PER PHL POL PRT PRI QAT ROU RUS RWA WSM SMR STP SAU SEN SRB SYC SLE SGP SXM SVK SVN SST SLB SOM ZAF SSD ESP LKA KNA LCA MAF VCT 692.3363094 51425.07899 1824.988076 418.492422 2979.834679 102832.2587 20011.34778 1275.363648 10926.3179 11206.42471 2108.841038 4497.435166 6603.809596 2786.950468 13776.45476 21618.73534 28681.70071 96076.99638 9587.177764 14487.27987 678.9981669 4179.597681 1675.747572 24646.02087 1051.376421 6353.826383 15695.61461 783.0111438 55979.75705 18109.50021 23144.12252 5924.836131 1889.991818 521.2230393 6889.786999 1157.486958 29370.66387 3628.268052 14498.63477 7319.523755 6591.56649 Sudan Suriname Swaziland Sweden Switzerland Syrian Arab Republic Tajikistan Tanzania Thailand Timor-Leste Togo Tonga Trinidad and Tobago Tunisia Turkey Turkmenistan Turks and Caicos Islands Tuvalu Uganda Ukraine United Arab Emirates United Kingdom United States Uruguay Uzbekistan Vanuatu Venezuela, RB Vietnam Virgin Islands (U.S.) West Bank and Gaza Yemen, Rep. Zambia Zimbabwe SDN SUR SWZ SWE CHE SYR TJK TZA THA TLS TGO TON TTO TUN TUR TKM TCA TUV UGA UKR ARE GBR USA URY UZB VUT VEN VNM VIR PSE YEM ZMB ZWE 1726.080156 9618.350531 3648.074903 60283.24522 84669.29294 1048.659569 910.3792327 6229.172886 1117.731251 626.1728645 4117.341436 20217.07833 4309.991625 10975.07493 7826.773607 3880.352322 674.3416307 4029.715504 42831.08913 42309.03992 52980.04363 16879.45316 1877.964512 3167.055303 1908.64034 2991.53805 1408.146193 1759.192902 905.5003218 Year=2013 per capita spending on healthcare % of children immunized for DPT 54.96414784 239.5770924 313.5202115 70 99 95 2947.964163 267.2242988 665.260099 1074.066944 158.6215569 96 93 99 94 95 6109.822819 5427.260142 436.0227778 1620.67683 1067.202693 31.63443186 1007.215496 462.8784385 5092.601211 262.4178502 36.69098425 91 83 93 97 99 95 91 98 99 95 69 89.74884249 173.9238388 448.7593504 397.3182644 1084.578689 973.5598014 555.0197963 45.68480052 21.46176493 164.6873127 75.75721305 67.17278529 5717.973612 97 94 89 95 97 99 95 88 96 93 92 89 96 13.0493878 37.20064104 23 48 1203.839842 366.8630274 91 99 533.07933 51.49240938 15.91195894 130.7115635 1005.090239 86.75579136 981.7638329 603.3826228 91 83 74 85 95 80 96 96 1884.079448 1367.024736 6269.540641 137.3641429 417.2184202 314.5126078 431.0726731 151.2641386 265.7710897 713.8579651 16.50864578 1071.605128 24.51864915 99 99 94 82 96 83 87 97 92 3 94 94 72 188.879045 4449.131065 4863.55014 99 98 99 441.3910658 28.91017917 349.9031357 5006.499458 99.52846516 2146.240311 79 97 96 96 90 99 499.241073 97 222.4509871 24.75235174 31.83837079 250.0119286 76.66639644 196.4436278 85 63 80 98 68 87 1055.761923 4125.877176 61.40821318 106.6333479 99 91 83 85 432.2817846 305.3529361 4232.865883 98 68 96 2598.892176 3154.900148 304.6260753 3965.582074 335.7851655 580.0623034 44.50922642 166.3223792 1880.044545 94 96 93 98 98 98 76 95 93 99 1507.213644 86.90594123 32.40633912 874.2822968 631.4753876 123.4244882 44.37104005 432.8442303 99 97 87 94 81 96 76 96 965.5638434 7980.828046 93 99 312.3879955 19.63139425 26.21476794 423.4301212 720.4603931 53.28703339 1999.546737 630.0742274 48.39684196 462.5430604 664.3426076 407.4297621 263.262983 6992.509699 243.7591211 461.2600429 189.2031878 40.25548427 14.40354357 422.5836885 98 74 89 97 99 71 99 79 80 98 83 81 90 99 98 94 99 78 75 89 39.0262313 6144.868844 92 97 4063.20516 154.6086212 27.2330651 114.9669057 92 98 67 63 9714.785781 677.6868425 36.87768441 1007.539455 796.076112 93.83476237 394.9596666 354.2768812 121.5959221 894.9166033 2036.773953 94 98 73 99 80 68 86 88 94 99 98 2042.97202 503.8149356 956.8452303 70.51125166 270.7399126 3847.196861 109.9755682 807.8386049 45.55036602 474.7668918 550.8454838 95.83287407 2507.433928 99 92 97 99 95 69 97 98 92 95 98 92 97 1454.08433 2084.590974 328.850017 100.2731974 593.4541967 18.07399793 2581.028193 102.4953403 872.7489854 621.2700329 98 95 87.47019819 94 42 65 45 96 99 96 99 344.9656111 97 114.952551 444.7068083 256.1141736 5680.33351 9276.472585 42.74341733 69.97536535 49.32111345 264.3462976 58.89042924 54.44793633 203.8741578 995.3046223 308.5648468 607.7082196 157.5401463 93 86 98 98 96 41 96 91 99 82 84 82 92 98 98 98 704.074452 59.11807384 312.6862556 1568.963441 3597.917253 9145.828151 1431.154046 119.957342 123.162338 519.6361624 111.1695022 90 78 76 94 95 94 94 99 64 82 59 74.47018794 92.81073153 88 79 95 per capita GDP 633.569247 4564.390339 5484.066806 13432.07933 12509.53112 3873.533566 61925.49606 51190.80825 7884.190236 22217.49414 24855.21564 1086.807079 15366.29261 8040.047557 47352.94291 4831.177552 903.464924 2560.501154 3124.080762 4790.049658 7123.339241 11384.41501 40979.64194 7851.265428 713.0638897 286.0023359 3641.107656 1094.576688 1407.403413 50235.38551 358.5378359 1024.668452 14528.32581 7590.016441 Year=2014 per capita spending on healthcare not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) 7903.925773 810.0757668 442.3395394 3147.072161 10415.44438 1545.942249 13475.25896 27194.39184 19529.84356 60707.24937 1813.596566 7244.495847 6163.575857 6345.840725 3198.695058 4119.992023 18918.27683 20161.58179 573.5659603 5112.322117 49823.70137 42732.5665 10772.06175 3669.981392 47821.91746 1441.636453 21498.41801 8573.694067 3673.135843 539.615775 567.8226103 4053.901904 824.1597732 2434.827162 40169.54364 14028.7221 52004.48575 1581.510703 3491.929717 not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) 5442.874771 not yet available (as of Dec 2015) 6420.372333 not yet available (as of Dec 2015) 54374.35224 not yet available (as of Dec 2015) not yet available (as of Dec 2015) 37207.9945 not yet available (as of Dec 2015) 34908.50097 not yet available (as of Dec 2015) 5104.767757 not yet available (as of Dec 2015) 36194.41561 not yet available (as of Dec 2015) 5422.570876 not yet available (as of Dec 2015) 12601.70348 not yet available (as of Dec 2015) 1358.262219 not yet available (as of Dec 2015) 1509.521187 not yet available (as of Dec 2015) not yet available (as of Dec 2015) 27970.49515 not yet available (as of Dec 2015) 4051.648361 not yet available (as of Dec 2015) 43593.70202 not yet available (as of Dec 2015) 1269.139335 not yet available (as of Dec 2015) 1793.470494 not yet available (as of Dec 2015) 15719.24202 not yet available (as of Dec 2015) 10057.88836 not yet available (as of Dec 2015) 1034.185288 not yet available (as of Dec 2015) 457.8585865 not yet available (as of Dec 2015) 6573.386737 not yet available (as of Dec 2015) not yet available (as of Dec 2015) 16506.86425 not yet available (as of Dec 2015) 116664.2625 not yet available (as of Dec 2015) 96038.05072 not yet available (as of Dec 2015) 5455.594889 not yet available (as of Dec 2015) 449.4008297 not yet available (as of Dec 2015) 255.0445696 not yet available (as of Dec 2015) 11307.06495 not yet available (as of Dec 2015) 7635.484151 not yet available (as of Dec 2015) 704.50744 not yet available (as of Dec 2015) not yet available (as of Dec 2015) 3529.748303 not yet available (as of Dec 2015) 1274.976949 not yet available (as of Dec 2015) 10016.64864 not yet available (as of Dec 2015) 10325.64607 not yet available (as of Dec 2015) 3057.091025 not yet available (as of Dec 2015) 2238.899885 not yet available (as of Dec 2015) not yet available (as of Dec 2015) 4129.373548 not yet available (as of Dec 2015) 7378.46395 not yet available (as of Dec 2015) 3190.310444 not yet available (as of Dec 2015) 585.6226826 not yet available (as of Dec 2015) 1203.844663 not yet available (as of Dec 2015) 5408.243491 not yet available (as of Dec 2015) 701.6800634 not yet available (as of Dec 2015) 52172.17123 not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) 1963.054884 not yet available (as of Dec 2015) 427.3732403 not yet available (as of Dec 2015) 3203.296824 not yet available (as of Dec 2015) not yet available (as of Dec 2015) 97307.42159 not yet available (as of Dec 2015) 19309.61245 not yet available (as of Dec 2015) 1316.61411 not yet available (as of Dec 2015) 11879.67781 not yet available (as of Dec 2015) 11948.85114 not yet available (as of Dec 2015) 2268.158717 not yet available (as of Dec 2015) 4712.823312 not yet available (as of Dec 2015) 6541.030564 not yet available (as of Dec 2015) 2872.512165 not yet available (as of Dec 2015) 14342.91271 not yet available (as of Dec 2015) 22132.17414 not yet available (as of Dec 2015) not yet available (as of Dec 2015) 96732.40255 not yet available (as of Dec 2015) 9996.670293 not yet available (as of Dec 2015) 12735.9184 not yet available (as of Dec 2015) 695.6892586 not yet available (as of Dec 2015) 4172.2171 not yet available (as of Dec 2015) not yet available (as of Dec 2015) 1810.721567 not yet available (as of Dec 2015) 24160.95854 not yet available (as of Dec 2015) 1067.131753 not yet available (as of Dec 2015) 6152.867126 not yet available (as of Dec 2015) 15543.21478 not yet available (as of Dec 2015) 765.9591973 not yet available (as of Dec 2015) 56284.57841 not yet available (as of Dec 2015) not yet available (as of Dec 2015) 18501.15286 not yet available (as of Dec 2015) 23999.13133 not yet available (as of Dec 2015) 5965.714104 not yet available (as of Dec 2015) 2024.190415 not yet available (as of Dec 2015) 542.615884 not yet available (as of Dec 2015) 6482.821479 not yet available (as of Dec 2015) 1115.093516 not yet available (as of Dec 2015) 29767.35156 not yet available (as of Dec 2015) 3819.158392 not yet available (as of Dec 2015) 15510.39393 not yet available (as of Dec 2015) 7647.529548 not yet available (as of Dec 2015) not yet available (as of Dec 2015) 6668.886105 not yet available (as of Dec 2015) 1875.843287 9680.115914 3477.149243 58938.77275 85594.3266 1114.007483 955.1413114 5977.380587 1169.038707 635.0442677 4113.993493 21323.75471 4420.698435 10515.00782 9031.51157 3826.902901 714.5673454 3082.461447 43962.71369 46331.97741 54629.49517 16806.77327 2036.691723 3147.963779 2052.294202 2965.903675 1721.623274 931.198187 not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) not yet available (as of Dec 2015) 4 % of children immunized for DPT 75 98 95 97 80 99 94 93 92 83 94 96 99 95 94 97 99 95 70 99 94 86 95 93 99 88 91 95 95 97 87 96 47 46 92 99 90 80 80 90 91 67 95 96 99 99 94 78 97 91 83 94 93 24 94 93 77 99 98 99 70 96 91 96 98 99 97 73 51 80 98 48 85 99 90 83 78 99 64 96 94 94 92 98 98 95 81 75 93 99 95 96 88 92 81 96 50 94 93 99 95 73 91 97 99 77 99 78 84 97 87 81 90 99 99 91 99 78 75 88 92 96 93 98 68 66 93 99 73 95 80 62 87 88 79 99 98 99 94 97 99 91 80 95 98 89 93 99 83 97 97 95 86.56269809 88 42 70 39 97 99 97 99 98 94 85 98 98 96 43 97 97 99 77 87 82 92 98 96 98 90 78 76 94 95 94 95 99 64 78 95 88 86 91 QUESTION 3 QUESTION 7 Sort the data by 2013 per capita GDP. Be careful and make sure that all of the data are kept together. How many countries have a non-missing entry for per capita GDP for 2013? Warning: seriously, you have to be careful and sort this correctly. If you don't know how to sort data in excel then you should take a few minutes to figure that out. In the per capita GDP versus per capita health care expenditure regression that you just ran you fail to reject the hypothesis that the slope is 0 (i.e. that the per capita GDP has no impact on the amount spent on health care). True O False QUESTION 4 For the countries that have a non-missing per capita GDP what is the average per capita GDP? Again you are using year=2013 values. Answer to the nearest dollar (whole number) and do not include a dollar sign. QUESTION 8 In the regression that you just ran you reject the hypothesis that the intercept is 0 (as usual assume alpha=.05). True False QUESTION 5 You will run a regression with 2013 per capita GDP and 2013 per capita health care spending. It seems plausible that in countries where people have greater income the also spend more on health care. You will use per capita GDP as the independent or explanatory variable in your regression and health care spending will be the dependent variable. However, excel will error out if there are missing values so use only observations that have both a 2013 per capita GDP and a 2013 per capita spending on health care. This may mean you either create a new table on a separate tab or delete some of the observations after sorting. How many observations will you use in your regression? Hint: it should be 183 and if it isn't then you are going to get wrong numbers later. QUESTION 9 Use the results from the regression you just ran with per capita GDP and health care. You already found R square for this regression. What is the estimated variance of the error term? Answer to the nearest integer. Hint this number should be less than 1,000,000. QUESTION 6 Warning: I have seen students in the past mix up the dependent and independent variables and this leads to a bunch of wrong answers. Please be careful and remember that the "Y" variable is the dependent variable and that the "x" variable is the independent variable. Use the World Bank data provided to run a regression where 2013 per capita health care expenditure is the dependent variable and 2013 per capita GDP is the independent variable. What is R square? Answer to three decimal places. QUESTION 10 Use the results from the regression you just ran with per capita GDP and health care. You already found R square for this regression. What is the estimated standard deviation of the error term? Answer to the nearest integer. QUESTION 11 Use the regression results you have found. What is the test statistic for a test that the slope of the regression line is 0? Answer to two decimal places. 28.36 QUESTION 18 Which of the following is an assumption we typically make when performing OLS regression? That the variance of the error term is constant across values of the independent variable. QUESTION 12 Use the same regression results where you already found R square and other results for this regression. What is the standard error for the estimated slope of the regression line? Answer to four decimal places. That the independent variable has mean 0. 0.3491 That the sum of the squared error terms is equal to 0. The derivative of the MSE with respect to the error term is positive. QUESTION 13 Using the same regression results what is the estimated coefficient on per capita GDP? Answer to three decimal places. QUESTION 19 9.901 If the estimated intercept is larger than the estimated slope and the estimated slope is statistically significant then the estimated intercept is also statistically significant. True O False QUESTION 14 Based on your regression results and your answer in the previous question using the World Bank data, what happens to per capita expenditure on health care as per capita GDP increases? O None of the other answers are correct. QUESTION 20 If the estimated slope of the simple linear regression is negative then this means that for all pairs of observations is x;> X; then y;
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Related Tags