from this table calculate a,b, and write out the regression equation (i.e., prediction equation)

Problem set 4: use the following information to answer questions 11-15 (15 points total): Let's examine the relationship between GNP per capita and the percentage of respondents willing to pay more in taxes. 11. In this chapter, we used Table 12.4 to illustrate how to calculate the slope and intercept in the regression table. Using table 13.4 as a model, create a similar table using the data below for GNP per capita and the percentage willing to pay higher taxes (5 pts). GNP pet X Wiling Capita (1) to Pay (x- X 10 - 7) Hither 21.27 25.6 21 22-20 67- 55 650 56- 3025 -12"-1 2-1 44 26.58 17 26 59-20 67-5 91 91.5 91-34 9281 17.268-98 5919.98--57 919 14.56 13.8 14 56-20 67--5 11 26 11-37 1371 13 8-26 8--12 -12013-169 6 119-13-79 43 37.55 35.43 27.55-20 67-16 88 16 88 16 88-294 9344 35 43-26 8-8 63 8 6308 63-74 16 88'8 63-145 6744 1.8.8 18.7 1 88-20.67=-18.79 -18.79"-18.79-353.0641 187-26 8-8.1 -18 79-8.1=152.199 4.67 33 52 4 62-20 67--16 05 -16 050-16 05-257 6025 33 52-268-672 672 6 72-45 16 0546 72.107 856 28 8 45.8 28 8-20 67-8 13 8 1328 13-66 0959 45 8-26 8-19 19 19-361 8 13-19-154 47 15.7 3.3.5 15 7-20 67-4 97 975-4 97-24.7009 135-269-67 67-6 7-41 80 1 97 6 7--23.299 30.12 24.6 30 12-20.67=9.45 9.45.9.45 89.3025 24.6-26 8--2 2 -2.2"-2.2=4.84 9.451-2.2=-20.79 11.52 18.9 1 52-20 67-9 15 9 150 18 9-258--79 9 154-79-72 285 3.27 25.3 3 77-20 67-169 -16 90-16 9-285 61 25 3-268--15 -1 56-1 5-2 25 16 91 15-252 24.8 16 5-20 67--417 1 172 4 17-17 3889 24 8-25 8--7 29.82 17 14 29 82-20 67-9 15 9 15'9 15-83 7225 17 14-26 8--9 66 36.83 31 32 16.83-20.67=16 16 16 16- 16 16 261.1456 31.32-26 8-4.52 4.52 4 52 20 6.16 4 52 73 0432 30.53 36 59 30 53-20 67-9 86 7 2196 36 54-26 8-9 79 9 79 9 79-95 9 86 9 74-96 5294 EX-3100 EY: 402.0 EX=0.05 E=1977.07 EO E=1140.71 E: 498.41 Mean X = EX/N -310.00/15=20.67 : Please make sure you get the correct N and N is 15 in this data. Mean Y = IV/ N - 420.00/15-26.8 Variance (X) = S'x = = [x- X Y/ N-1- 1979.07/15.1-1977.03/14-141 22 Standard deviation (X) = Sx = square root (141 22) =11.88 Variance (Y) = S'. =x (-F)/N: 1 - 1190.71/15-1=1140.71/14-81/48 Standard deviation (Y] = Sy = square root (81.48) =9.03 Covariance (X, Y) = Sxy = 1 (X- X )IY-7 1 /N )=498.41/15-2-498.41/14-35.60 Anewers may differ due to rounding mal pairits), however, the exact value of these column totals, properly calculated will always be equal to zero. Sources: The World Bank Group, Development Education Program Learning Model. Economies, GNP per Capita, 2004. International Social Survey Programmer, 2000