Numeracy, Data & IT Homework: Fraction, Percentage, IT & Data Analysis

This assignment focuses on numeracy, data analysis, and IT skills, covering topics from basic fraction and percentage calculations to more complex data interpretation and ranking. The solution includes detailed steps for solving problems related to fractions, percentages, and their applications in real-world scenarios. It also involves analyzing Olympic data to determine medal counts, country rankings, and performance metrics using spreadsheet software. The assignment further requires creating stacked bar charts to visualize the data effectively. The solution demonstrates the application of mathematical principles and IT tools for data-driven decision-making.

Numeracy, Data & IT

Contents
INTRODUCTION...........................................................................................................................................4
MAIN BODY.................................................................................................................................................4
Question 1...............................................................................................................................................4
Question 2...............................................................................................................................................4
Question 3...............................................................................................................................................5
Question 4...............................................................................................................................................5
Question 5...............................................................................................................................................5
Question 6...............................................................................................................................................6
Question 7...............................................................................................................................................6
Question 8...............................................................................................................................................7
Question 9...............................................................................................................................................7
As a result, Annabelle can walk out of the house no later than 8:15 a.m................................................8
Question 10.............................................................................................................................................8
PART 2.........................................................................................................................................................8
Question 11.............................................................................................................................................8
PART 3.......................................................................................................................................................11
Question 12...........................................................................................................................................11
Question 13...........................................................................................................................................11
PART 3.......................................................................................................................................................13
Question 12...........................................................................................................................................13
Question 13...........................................................................................................................................14
Question 14...........................................................................................................................................15
Question 15...........................................................................................................................................17
Question 16...........................................................................................................................................19
REFERENCES..............................................................................................................................................21

INTRODUCTION
Numeracy is defined as the ability to reason and apply accurate mathematical principles.
Knowing fundamental mathematics such as arithmetic, reduction, division, and differentiating
are examples of simple numeracy abilities. Numeracy abilities have been extensively studied in
terms of their development and degenerative reversal, but it is unclear if they affect health
outcomes. Furthermore, it is yet unknown whether either mathematical aptitude may be
improved with age (Kass-Hanna, Lyons and Liu, 2021). Data analysis is the method for
inspecting, analyzing, transforming, and modeling data with the goal of uncovering useful
information, communicating results, and assisting judgment. Research process has many features
and methodologies, is known by a variety of names, and involves a variety of tactics. It is
utilized in a variety of commercial, academic, and social studies disciplines. In today’s rapidly
changing business climate, analysis of data entails gaining more information and assisting
organizations in performing more successfully.
MAIN BODY
Question 1
Numerator: The numerator is the quantity that happens in the top section of the fraction. A
fractional was nothing but a piece of all that has been mentioned thus far. As a result, the
numerator indicates the total number of equal pieces that would be multiplied.
Denominator: The denominator is the fraction's second component. They make it up often from
the bottom third of the percentage. It also corresponds to the quantity of two pieces that the total
can be divided into. Let's look at that other 12 fraction instance. 12 denote that two similar
sections of a given picture are considered in this case (Thomas and Jones, 2021).
In a fraction, the denominator represents the number of equal pieces, while the numerator
represents the number of sections. As p / q is the numerator of a complete entity that is divided
into q segments with same dimensions, the denominator is p pieces in a fraction.
Question 2
24/40 = 0.6

18/42 = 0.43 (approx.)
Question 3
(a) Express the fractions 2/3, 3//4 and 5/6 as equivalent fractions with a denominator of 12
2/3 = 2*4/3*4 = 8/12
3/4 = 3*3/4*3 = 9/12
5/6 = 5*2/ 6*2 = 10/12
(b) Percentage of library books on computing
Remainder book = 60,000 – 14,000 – 22,000 – 12,000
= 12,000
Computing books = 12,000 × 2
3
= 8,000
Percentage of books on computing = 8,000
60,000 ×100
= 13.33%
Question 4
Total money given by Liz = £50 × 3 = £150
Total price of 2 pairs of shoes = £150 - £10.50
= £139.50
Price of each pair of shoes = £139.50/2
= £69.75 per pair
Question 5
(a). 240.50 x 19.54 (2 significant)

From the above expression, there is a total of four decimal places from the two numbers 24050
x 1954 = 46993700
240.50 x 19.54 = 4699. 3700
= 4699.37 (2 decimal places)
(b) Rewriting 52100 to the power of 10
5.21 x 104
Question 6
Discount rate = 30%
No of people = 3
Total amount paid = £210
Amount paid for one person = £210/3 = 70
Percentage of amount paid = 70%
Total amount paid for sign up = £210
Total discount received = £210 × 30
100
= £63
Hence, the total savings made = £63
(b) Average savings per person = £63 / 3 (Patty and her 2 siblings)
= £21 per person
Question 7
a) 3/4 - 7/9 + 2/3
Applying BODMAS = 17/12 – 7/9
= 237/108

b) The largest number from the series 0.1 because 0.1 has significant decimal digit, one digit to
the right of the decimal point. 0.1 has two particular decimal digits thus 0.1 is presented with the
number of zero and become 0.10 that provides it two decimal digits same as other following
numbers of 0.02, 0.003 and others (Agasisti, Johnes and Paccagnella, 2021).
0.1
Question 8
Total number of people said yes = (90 + 60) × 3
5
= 90
Total number of women said yes = 60 × 3
10
= 18
Total number of man said yes = 90 – 18
= 72
Number of man said no = 90 -72 = 18
Percentage of the men said no = 18
90 × 100
= 20%
Question 9
Here, reverse calculation method will be adopted:
-Annabelle is a Londoner who resides in Bermondsey.
-She is scheduled to speak at 10:30 a.m. in Birmingham.
-Getting from her residence to Euston Station, where she takes the train to Birmingham, will
takes her an hour (1 hour).
-The train ride from Euston Station to Birmingham takes one hour and ten minutes (7/6 hours).

- The meeting location station in Birmingham is a 5-minute (1/6-hour) walk away.
As a result, Annabelle's total travel time from her home to the meeting location is = 1 hr + 7/6 hr
+ 1/12 hr = 27/12 hr = 2 hours 15 minutes.
To determine the time, divide the entire time required to arrive to the meeting site by the planned
time: (10 hours 30 minutes) – (2 hours 15 minutes) = 8 hours 15 minutes.
Despite the fact that the train from Euston to Birmingham arrives at 5 minutes after the hour, 25
minutes after the hour, and 45 minutes after the hour.
As a result, Annabelle can walk out of the house no later than 8:15 a.m.
Question 10
Converting both values in simple form = 9/25
= 0.36Kg
Therefore, 0.36 Kg or 9/25 Kg is heavier than 0.35Kg of Shredded Wheat.
PART 2
Question 11
a) Hungary
b) China and Soviet Union
c) 27 is the mode in the number of games countries participated in
d) Minimum = 147; Maximum = 1,022
Range = Maximum – Minimum
= 1,022 – 147
= 875
e) 4 countries
f) Germany, United States and Soviet Union

g)
Country
Total
Games
Total
medals
Medals per
game
Australia 26 497 19.11538462
China 10 543 54.3
France 28 713 25.46428571
Germany 24 937 39.04166667
Great Britain 28 847 30.25
Hungary 26 491 18.88461538
Italy 27 577 21.37037037
Soviet Union 10 1122 112.2
Sweden 27 494 18.2962963
United States 27 2520 93.33333333
Thus, 93.33 medals per game were won by the United States, which is the highest of all nations.
Firstly, the largest number of trophies won per game is in the United States.
h) Causes include the following:
1. In total Olympic games, Jamaica has struggled to score little if any gold medal; because of that
which was not included in the top 10 rankings.
2. Athletes from Jamaica have indeed actively participated in one sprinting event (Buhl-Wiggers,
Jones and Thornton, 2021).
(i)
Country Gold
United States 1,022
Soviet Union 440
582
Country Silver

United States 794
Soviet Union 357
437
Country
Bronz
e
United States 704
Soviet Union 325
379
Gold (582) is the overall disparity between award classes with its nearest rival; thus, Gold is the
division whereby the nearest rival has far outpaced the United States.
(j) Sweden and Australia have less gold medals = 147
Hungry and Australia have less silver medals = 147 & 163
China and Hungry have less Bronze medals = 151 & 179
Team Gold Silver Bronze Range
Hungary 175 147 169 28
Italy 206 178 193 28
Great Britain 263 295 289 32
Sweden 147 170 179 32
Australia 147 163 187 40
France 212 241 260 48
Germany 275 313 349 74
China 227 165 151 76
Soviet Union 440 357 325 115
United States 1022 794 704 228

From the above table present the total medals of each country with the range of smallest
numbers.
PART 3
Question 12
Team Total games Gold Silver Bronze Total
Australia 26 147 163 187 497
China 10 227 165 151 543
France 28 212 241 260 713
Germany 24 275 313 349 937
Great Britain 28 263 295 289 847
Hungary 26 175 147 169 491
Italy 27 206 178 193 577
Soviet Union 10 440 357 325 1122
Sweden 27 147 170 179 494
United states 27 1022 794 704 2520
Question 13
(a) Based on the information supplied, Hungary has the fewest total medals as among ten
countries, with 491 medals.
(b) China and the Soviet Union, with ten games each, are the nations that participated in the
fewest tournaments.
(c) The average number of games in which countries played is 28. (France and Great Britain)
(d) The difference in gold medals between the ten countries is = 1022 – 147 = 875.
(e) China, the United Kingdom, the Soviet Union, and the United States are the four nations with
far more silver medals than bronze medals.
(f) Germany and the Soviet Union, aside from the United States, have more gold medals, silver
medals, and bronze medals than just the United Kingdom (Pensiero, Kelly and Bokhove, 2021).
(g) The largest amount of trophies gained in each match must be established in order to evaluate
which country did best. However, given the data presented in table below, this may be calculated
by dividing the total amount of wins won by the amount of games every country has participated.

Country
Total
Games
Total
medals
Medals per
game
Australia 26 497 19.11538462
China 10 543 54.3
France 28 713 25.46428571
Germany 24 937 39.04166667
Great Britain 28 847 30.25
Hungary 26 491 18.88461538
Italy 27 577 21.37037037
Soviet Union 10 1122 112.2
Sweden 27 494 18.2962963
United States 27 2520 93.33333333
As a result, the United States won 93.33 medals per match, the most of any country. To begin
with, the United States has the most major trophies per game.
h) The below are some of the reasons:
1. In total Olympic Games, Jamaica has managed to score few, if any, gold medals; as a result, it
is not ranked among the top ten countries.
2. Jamaican athletes have competed in at least one running competition.
(i)
Country Gold
United States 1,022
Soviet Union 440
582
Country Silver
United States 794
Soviet Union 357