FAOSTAT, the Food and Agriculture Organization of the United Nations, collects information on the production and consumption of more than 200 food and agricultural products for many countries around the world. This Excel file shows the meat consumption (per capita in kilograms per year) and alcohol consumption (per capita in gallons per year) for several countries.

The United States leads in meat consumption with 123 kilograms while Ireland consumes the most alcohol with 70.69 gallons.

Question 3. Calculate each country's z-score for alcohol consumption as follows:

In cell G3 calculate the mean alcohol consumption by typing =AVERAGE(B3:B128), then press Enter.

In cell G4 calculate the standard deviation of alcohol consumption by typing =STDEV(B3:B128), then press Enter.

In cell D3 calculate Albania's z-score for alcohol consumption by typing =(B3-$G$3)/$G$4, then press Enter. $G$3 and $G$4 are absolute cell addresses that do not change when the formula is copied.

Click on cell D3. Point your mouse to the small black box in the lower right corner of cell D3 and double-click. The alcohol z-scores for the remaining countries will be calculated in column D.

What is the sum of the z-scores? Round your answer to the nearest integer. (Calculate the sum of the z-scores by typing =SUM(D3:D128) in an empty cell, then press Enter. The value of the answer is not a coincidence; the sum of the z-scores is this value for any data set).
sum of z-scores

Question 4. If meat consumption is expressed in pounds instead of kilograms, what is the z-score for United States meat consumption? (1 kilogram = 2.2 pounds)

THIS IS THE EXCEL FILE INFORMATION

CountryAlcoholMeat
Albania5.7038
Angola8.7120
Antigua and Barbuda9.0573
Argentina22.1182
Australia37.52118
Austria51.59112
Azerbaijan8.0417
Bahamas10.39108
Barbados15.7575
Belarus11.0658
Belgium43.8980
Belize12.7348
Bermuda24.1271
Bolivia8.3850
Bosnia and Herzegovina18.0916
Botswana12.0623
Brazil15.0881
Brunei Darussalam0.3459
Bulgaria17.7670
Burkina Faso20.1011
Cameroon13.4015
Canada30.4998
Cape Verde11.7330
Central African Republic5.7032
Chile14.7467
China9.0554
Colombia6.0333
Congo6.3719
Costa Rica6.7041
Côte d'Ivoire5.7012
Croatia42.8840
Cuba9.0531
Cyprus23.12108
Czech Republic58.9679
Denmark43.89111
Dominica7.7162
Dominican Republic15.0833
Ecuador5.0345
El Salvador6.7021
Estonia32.5062
Fiji6.3740
Finland35.1868
France31.1698
French Polynesia22.11104
Gabon26.8037
Georgia3.6926
Germany46.5784
Ghana7.0410
Greece21.4479
Grenada13.0771
Guatemala2.3523
Guinea-Bissau6.0313
Guyana7.0437
Haiti3.6916
Honduras5.7024
Hungary38.1989
Iceland21.4486
Ireland70.69102
Israel5.3697
Italy26.4791
Jamaica7.3757
Japan16.4243
Kazakhstan8.0447
Kenya3.6915
Kiribati1.6837
Korea, Democratic People's Republic of2.6810
Korea, Republic of23.1250
Kyrgyzstan3.3538
Lao People's Democratic Republic5.7016
Latvia21.7852
Lebanon3.3554
Lesotho9.7215
Lithuania31.8360
Madagascar2.6815
Maldives2.6848
Malta14.7483
Mauritius10.7232
Mexico16.4258
Moldova14.0721
Mongolia4.0294
Namibia3.6935
Netherlands34.1767
Netherlands Antilles32.1679
New Caledonia27.8165
New Zealand31.49109
Nicaragua4.6918
Nigeria24.128
Norway24.1262
Panama16.4254
Paraguay16.7545
Peru9.7222
Philippines5.0330
Poland29.4876
Portugal41.5486
Romania28.4859
Russian Federation23.1252
Saint Kitts and Nevis18.0986
Saint Lucia20.4479
Saint Vincent and Grenadines8.3874
Samoa6.3778
Sao Tome and Principe13.0712
Serbia and Montenegro25.1382
Seychelles14.0724
Slovakia34.5168
Slovenia27.4793
South Africa29.1543
Spain35.51121
Suriname15.0843
Swaziland21.4430
Sweden25.8076
Switzerland34.1774
Tanzania, United Republic of22.459
Thailand11.7325
The former Yugoslav Republic of Macedonia16.7535
Trinidad and Tobago13.0738
Turkey3.6920
Turkmenistan2.3543
Uganda44.5610
Ukraine14.7433
United Kingdom41.5483
United States of America32.83123
Uruguay16.0870
Venezuela, Bolivarian Republic of25.8047
Viet Nam3.0230
Zambia9.0511
Zimbabwe8.3815