1.Calculate the sample covariance and correlation for the two relationships in question 2 above using Data Analysis Tool Pack or Excel statistical functions. In addition, you are required to calculate the sample covariance and correlation using a second method (using basic Excel formulae without Data Analysis Tool Pack). The calculations by the second method should be carefully laid out in Excel and should NOT use any hard-wired Excel statistical functions e.g. COVARIANCE.S, CORREL, et al. You can use the Excel sort command, the sum command, and any other non-statistical excel commands. Carefully interpret your results.
1 country per_cap_GDP2000 growth1990_2000 tem1950_1960 pre1950_1960 tem1990_2000 pre1990_2000 2 Nigeria 6.341999468 0.017646708 26.52577 13.88756 26.85172 13.39307 W Panama 8.309018174 3.343584973 24.68316 28.04099 25.11478 27.48667 4 United Arab Emirates 10.41305497 0.351553339 26.84328 1.631635 26.91433 1.263214 5 Spain 9.596491202 2.487687259 13.48391 6.651904 14.41149 6.297207 6 Austria 10.10905589 2.300388065 7.549002 9.950752 7.952092 9.221741 Canada 10.09370492 0.582056958 4.841475 9.364386 5.296148 9.385453 8 Vanuatu 7.2934069 1.483790792 24.15511 27.481 24.62386 25.28607 9 Australia 9.984110761 2.135885605 15.86288 9.355159 15.80989 7.964385 10 Sierra Leone 4.932303899 2.469349752 25.70401 28.29842 26.19973 25.13283 11 Brunei 9.798824364 -0.428450843 27.20606 30.216 27.06742 26.36298 12 Ghana 5.554783345 1.456127111 26.31561 14.2106 26.67841 12.75037 13 Fiji 7.638472188 1.673783596 23.89741 31.08469 24.03207 25.13651 14 Egypt 7.279647225 2.512322923 21.03608 0.3591493 21.2031 0.6710021 15 Turkey 8.375048385 2.602163169 12.03383 5.847577 12.12031 6.115713 16 Belgium 10.04505372 2.029001451 9.626793 7.704759 10.52248 7.875272 17 Cote d'Ivoire 6.478979435 -1.23001107 26.24332 15.25539 26.26308 12.65963 18 Iran 7.420584576 2.423024302 13.79623 3.894315 14.32119 3.533688 19 India 6.094278759 3.585117687 25.23642 12.74809 25.26296 11.98164 20 Suriname 7.607024507 -1.087064319 26.61093 22.14153 26.69649 21.5842 21 Senegal 6.404656503 0.055498592 26.9184 9.227755 27.44442 6.163564 22 Togo 5.711110209 -0.37610378 26.07221 12.79692 26.32782 11.59565 23 Rwanda 5.563669533 1.252000313 19.12939 10.76035 20.2585 10.81682 24 Peru 7.578446198 1.279218094 13.26135 8.056942 14.05118 8.142179 25 Mauritius 8.276159434 4.281374685 24.04545 16.54273 23.99242 14.99573 26 Philippines 6.978035781 0.530769128 25.38977 24.72692 25.64058 23.83464 27 Mali 5.597944577 0.967916696 27.92813 8.587226 28.47546 6.926775 28 Germany 10.07052326 1.841511218 8.429167 7.853553 9.261319 7.223675 29 Chile 8.532062419 4.485345735 11.73466 6.047864 11.39667 5.756211 30 Oman 9.05966537 1.877228526 25.61425 1.243683 25.76736 1.718448 31 Honduras 6.985144126 0.306134294 23.70358 15.80122 24.79869 12.35854 32 Argentina 8.950027132 2.272210933 16.78562 8.500537 17.18774 9.177779 33 Uganda 5.56784437 3.261433402 22.20274 11.86919 22.31762 11.9865 34 France 10.01520912 1.726098494 10.32313 7.900137 11.22639 7.400362 35 Lesotho 6.07876169 2.485163739 12.33063 7.941034 12.00661 6.443765 36 Laos 5.784400396 3.828208018 23.5511 18.59604 23.60845 17.78357 37 Haiti 6.698926252 -1.597174052 23.80118 15.15912 24.65671 10.8632337 Haiti 6.698926252 -1.597174052 23.80118 15.15912 24.65671 10.86323 38 Paraguay 7.416742365 0.217254068 22.6103 13.86094 22.1425 16.53286 39 Costa Rica 8.235591267 2.253617492 21.69974 37.24714 22.8697 39.86776 40 Mauritania 6.517032455 -0.871080318 28.07941 3.883507 28.8736 2.743884 41 United States 10.50053423 2.055704447 13.06245 9.107277 13.30472 8.762918 42 Botswana 8.166871928 2.465008425 20.15629 5.036779 21.53338 4.100937 43 Brazil 8.229445317 0.469748127 21.38649 13.77444 22.30956 13.2029 44 Trinidad and Tobago 8.769532711 4.960545686 26.27126 20.02921 26.05961 19.53647 45 Korea 9.413851957 6.467544334 11.18752 11.73753 11.56427 13.40523 46 Ireland 10.17509225 6.376785862 9.004849 10.22423 9.577958 10.37711 47 Colombia 7.832205071 1.012220862 21.26738 20.56923 21.22947 19.03087 48 Indonesia 6.659537737 2.747891283 25.50005 24.98619 25.76939 18.55051 49 Belize 8.120984986 3.752138039 25.42072 23.68984 25.85874 23.32534 50 Algeria 7.475918546 -0.164740644 16.80155 5.642025 17.13557 4.614381 51 Cuba 7.91830057 -1.786452329 25.31185 13.27607 25.33854 10.69392 52 Uruguay 8.835650025 2.5076454 16.99368 11.09725 17.37455 11.01161 53 Cabo Verde 7.138330075 7.958015454 23.36591 7.898182 23.60606 8.581819 54 Norway 10.54879496 2.958794983 3.29523 9.886539 4.282211 9.770261 55 Ecuador 7.276057886 0.011939686 19.90497 13.73285 20.40689 16.58907 56 Denmark 10.33343542 2.201612231 7.6489 6.644507 8.391273 3.57791 57 Dominican Republic 7.961755713 3.15293866 24.47031 17.84686 25.66094 14.14335 58 Nicaragua 6.915228712 1.10224032 24.78792 16.98472 26.53195 14.15275 59 Sri Lanka 6.768144319 4.438963593 26.605 23.26587 26.87928 22.05306 60 China 6.866279408 8.655843283 13.42423 9.934293 13.91455 10.40647 61 Japan 10.5592454 1.356308293 12.96264 17.9546 13.55762 16.39544 62 Gambia, The 6.387134578 0.034229888 25.8047 13.73073 26.40894 9.141487 63 Guinea-Bissau 5.730567593 -0.437058263 26.46866 18.698 26.88505 14.93492 64 Hungary 8.43907632 1.899129864 10.43776 6.082292 10.61292 5.907116 65 Guatemala 7.417159268 1.460227831 19.84146 22.9342 21.82512 18.68205 66 United Kingdom 10.24529802 2.050550258 9.041043 8.130628 9.619326 7.720697 67 Nepal 5.435860707 2.508794623 20.44924 15.23243 20.37417 14.7353 68 Jordan 7.409513382 0.486085514 18.24715 2.726088 17.66171 2.621536 69 Samoa 7.340878832 1.171336005 26.06212 30.906 25.95227 15.19527 70 Venezuela 8.485090821 0.422032291 24.99508 11.94165 25.74873 11.70615 71 Bolivia 6.905334812 1.75394906 18.62292 10.56473 18.49841 9.714385 72 Iceland 10.37405551 1.648187168 2.96588 8.354614 2.467539 8.012055 73 Greece 9.396235014 1.596620334 14.95799 7.117124 14.64826 5.71076773 Greece 9.396235014 1.596620334 14.95799 7.117124 14.64826 5.710767 74 New Zealand 9.520842773 1.404064547 11.98894 12.29694 11.90126 10.24473 75 Cameroon 6.476959817 -2.15358778 24.23516 20.22872 24.34234 17.56387 76 Italy 9.907857589 1.671002216 11.81764 10.35821 12.33237 11.61727 77 Burkina Faso 5.540155202 1.986588691 27.41963 9.59704 27.9637 8.097651 78 Guinea 5.895731095 1.245459329 25.03104 22.86032 25.37372 19.88388 79 Sweden 10.29637093 1.620467187 5.282156 6.289688 6.023034 5.778014 80 Morocco 7.196643912 1.514975138 17.04815 4.353302 17.19479 4.088074 81 Madagascar 5.682242675 -1.187089028 20.67844 15.35144 21.05817 14.66957 82 Netherlands 10.17158195 2.743167206 9.666837 7.447047 10.35187 7.761985 83 Gabon 8.32499502 -0.533867964 24.77283 22.07469 24.69613 20.5727 84 Kenya 5.985151307 -0.940087436 20.31933 11.0526 20.06081 12.29716 85 Comoros 6.4705188 -0.405154735 24.80303 22.98245 26.02197 20.58245 86 Switzerland 10.54187024 0.728696009 4.975078 13.79524 5.804756 11.75557 87 Congo, Dem. Rep. 6.004420883 -8.474498001 24.07286 14.23098 24.33597 15.48968 88 Jamaica 8.127019037 1.126682665 23.81385 19.84624 24.99295 17.55477 89 Kuwait 9.822298024 -2.867917947 25.5101 0.939177 25.97743 1.293124 90 Benin 6.237152507 1.702369936 27.02115 11.75305 27.12502 10.76115 91 Mexico 8.875959976 1.928195582 18.61772 9.262138 18.99939 8.251323 92 Niger 5.284935254 -2.038653695 27.78783 5.96913 28.34429 4.570006 93 Malawi 5.052325511 1.968176058 21.42636 11.63722 23.08399 10.28716 94 Romania 7.414517241 -0.771896213 8.93429 5.974701 9.209678 3.596791 95 Central African Republic 5.526276812 -1.60894537 24.71314 14.97238 24.49559 14.09322 96 Tanzania 6.018477217 0.462086634 22.36172 9.373319 22.63398 10.18079 97 Chad 5.110558976 -1.433425935 27.7491 8.173254 28.09092 6.980453 98 Bhutan 6.576731138 4.340952013 11.55096 34.60533 11.37613 23.39394 99 Syrian Arab Republic 7.071258601 2.494926336 17.28383 3.931275 17.54745 3.316102 100 Luxembourg 10.79417316 3.626749501 9.165152 7.408273 9.602273 7.092182 101 Tunisia 7.701574067 3.286240995 18.06059 4.862517 18.98573 4.316459 102 Mozambique 5.766317693 2.790436047 23.66864 10.34521 24.48417 9.191278 103 Poland 8.41215575 3.769896707 7.640728 5.830766 8.318139 6.146651 104 El Salvador 7.601671169 2.334291939 22.56823 18.02399 24.23132 14.27574 105 Burundi 4.91606063 -3.022205969 19.28739 10.87615 20.75322 10.58038 106 Saudi Arabia 9.123837609 1.22463352 24.68902 1.22218 25.52149 0.8200489 107 Cambodia 5.712336331 -0.932081399 27.06396 16.69377 27.78295 12.87399
