a) Hungary had the lowest total medal count at 491
------------------------------------------------------------------------------
b) It's a tie between China and the Soviet Union with 10 games per country.
------------------------------------------------------------------------------
c) The mode is 27 since it is the most frequent value in the "total games" column. The mode is not necessarily the largest or smallest value. It's simply the value that shows up the most. It is possible to have more than one mode, but in this case 27 shows up the most times and no other value ties it. The value 27 shows up three times with the countries Italy, Sweden, and the United States
------------------------------------------------------------------------------
d) The range is 875. To find the range, subtract the largest value (max) and the smallest value (min). So we have range = max - min = 1022 - 147 = 875.
------------------------------------------------------------------------------
e) Answer: 4
List of countries that got more silver than bronze = {China, Great Britain, Soviet Union, United States}
------------------------------------------------------------------------------
f)
List of countries that got more gold, silver, and bronze compared to Great Britain
{Germany, Soviet Union}
So only two other countries fit the criteria
------------------------------------------------------------------------------
g)
Answer: The Soviet Union had the most medals per game (around 112 medals per game)
Work Shown:
For each row, divide the total medal count (in column F) by the number of games (in column B)
- Australia = 497/26 = 19.1154
- China = 543/10 = 54.3
- France = 713/28 = 25.4643
- Germany = 937/24 = 39.0417
- Great Britain = 847/28 = 30.25
- Hungary = 491/26 = 18.8846
- Italy = 577/27 = 21.3704
- Soviet Union = 1122/10 = 112.2
- Sweden = 494/27 = 18.2963
- United States = 2520/27 = 93.3333
------------------------------------------------------------------------------
h)
The country is likely not large enough to participate in enough games, especially when compared to larger countries. They may be specialized in just one or two events, or one or two categories of events.
------------------------------------------------------------------------------
i)
Answer: Gold Medal (vs Soviet Union)
The United States has a total medal count of 2520. The closest competitor is the Soviet Union at 1122
To compare which category (gold, silver, bronze) the US did better at, we'll divide each corresponding medal count for the two countries. We'll have the Soviet Union's count as the numerator and the US as the denominator.
Gold = 440/1022 = 0.4305
Silver = 357/794 = 0.4496
Bronze = 325/704 = 0.4616
The lowest result is one where the US performed best at. The gold percentage is 43.05% meaning the Soviet Union's gold count is roughly 43.05% of the US gold count
------------------------------------------------------------------------------
j)
Answer: Hungary, Italy, Sweden
Explanation:
You'll subtract the min and max for each row to get the range for each country. Sort the ranges from smallest to largest to see the top three countries that have the smallest range.
For example, Australia's highest medal count is at 187 (bronze) and lowest medal count at 147 (gold) so the range here is 187-147 = 40.
