Numeracy Data, IT: Applying Mathematical Skills to Real-World Data

This assignment solution focuses on applying numeracy skills and IT fundamentals to solve mathematical problems and analyze data. It covers basic mathematical concepts such as fractions, percentages, and significant figures, demonstrating their application in real-world scenarios like calculating discounts and analyzing Olympic Games medal data. The solution also illustrates how to use Microsoft Excel to create comparison charts and highlight specific data regions. The assignment includes step-by-step explanations for performing various operations in Excel and interpreting statistical measures. It addresses questions related to data analysis, such as identifying countries with the lowest medal counts, determining the range of gold medals awarded, and comparing medal distributions among different countries. The document provides a comprehensive overview of how numeracy and IT skills can be integrated to effectively analyze and present data.

Using numeracy data
and IT FP

Contents
Contents...........................................................................................................................................2
INTRODUCTION...........................................................................................................................3
Part 1................................................................................................................................................3
Question 1....................................................................................................................................3
Question 2....................................................................................................................................4
Question 3....................................................................................................................................4
Question 4....................................................................................................................................4
Question 5....................................................................................................................................5
Question 6....................................................................................................................................5
Question 7....................................................................................................................................6
Question 8....................................................................................................................................6
Question 9....................................................................................................................................6
Question 10..................................................................................................................................7
Part 2................................................................................................................................................7
Part 3..............................................................................................................................................10
Question 13................................................................................................................................12
Question 14................................................................................................................................13
Question 15................................................................................................................................14
Question 16..................................................................................................................................1
Olympic Games Medal Table..........................................................................................................2
Olympic Games Medal Tables........................................................................................................3
Conclusion.......................................................................................................................................4
References........................................................................................................................................5

INTRODUCTION
IT proficiency is defined as the capacity to calculate and assess the relevant mathematical
and IT information, whereas mathematical knowledge is understood as the propensity to think
about and implement correct conceptual notions (Aoun and Alaaraj, 2019). Understanding
simple numerical like splits, multiplies, adding, and subtracting is crucial to gaining core
understanding of mathematics. In ordinary living, arithmetic is necessary for normal linguistic
and cognitive functioning. Consumption, obeying commands, judging invoices, and gaming are
all acts that require arithmetic. It also renders mathematics, patterning, schedule, and shape ideas
accessible. It was discovered that the principles of writing and mathematics can help people
develop the core abilities they need to succeed in life. There is a thorough strategy in place to
help kids improve their reading and numeracy skills while also assisting them in leading a happy
and satisfying life and serving to their society as an engaged and well-informed citizen. This
arithmetic program is divided into three primary activities, each of which should be completed in
a standard manner.
Part 1
Question 1
Mathematical proficiency is characterized as the capacity to understand and apply
elementary mathematical principles, as previously stated. Simple mathematics calculations such
as splitting, multiplying, adding, and deleting are required for basic logic skills. The numerator
and denominator concepts would be covered further down.
Numerator: The partial integers formula is a/b, in which a represents the numerator and b
represents the denominator. For example, 4/5 is a proportion, and the line between the numbers 4
and 5 is a proportion bar pair (Appel and Pipa, 2017). As an outcome, the denominator is the
amount below the % line, while the exponent is the value above it. The exponent is depicted in
the diagram beneath-

Denominator: The denominator is the lowest amount in a proportion which describes the
amount of similar elements divided into a thing (Atrill and Lindley, 2019).
Question 2
Expressing 24/40 and 18/42 in their simplest forms
3 ∧18
24 = 5 = 3
40 42 7
Question 3
(a) , Expressing the fraction 2/3, ¾ and 5/6 as equivalent fractions with a denominator of 12.
2 = 8 , 3 = 9 5 = 10
3 12 4 12 6 12
(b) A library contains 60,000 books. 14,000 are about business, 22,000 are on healthcare and
12,000 on psychology and law. What percentage of the library’s books is on computing, if
computing books make up two-thirds of the remainder?
The total books in the library = 60,000 Business books = 14000
Healthcare books = 22000 Psychology and law = 12000
Remaining book = 60000 – (14000 + 22000 + 12000) = 12000
The computer books is 2/3 of the remainder = 2/3 x 12000 = 8000 Therefore, the percentage of
the library books on computing will be; 8000/60000 x 100 = 13.33%
Question 4
-Liz purchases two pairs of running shoes
- Liz gives three Crisp £50 notes = £50 x 3 = £150
-Liz received £10.50 change
What is the amount for each pair? (let this be referred to as x) Therefore, 2x + 10.50 = 150
2x + 10.50 = 150
From the equation above, the value of x can be calculated as shown below. 2x = 150-10.50
2x = 139.50 X = 139.50/2 X = 69.75
Therefore, each pair of the running shoes cost £69.75

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
(a). A new gym offers 30% discount to individuals who sign up in the first month
-Patty and 2 siblings (which is 3 individuals in total)
-The 3 people paid a total amount of £210
-Let the total amount without the 30% discount be p
-Let the total discount be y Therefore
30/100 x P = y---------Eqn 1
P – y = 210...........Eqn 2
To solve for P, we substitute the value of y in equation 2
P – (30/100 x P) = 210 P – (30P/100) = 210
100P – 30P = 21000
70P = 21000 P = 21000/70 P = 300
We can now substitute the value of P in equation 2 to find y 300 – y = 210
y = 300- 210 = 90
Therefore, the total savings made was £90
(b) The total savings made was £90 There are 3 individuals involved
Therefore, the average savings per person can be calculated as
£90/3 = £30

Question 7
(a). ¾ - 7/9 + 2/3
(27-28+24)/36 = 23/36
(b) Which is the largest of the following numbers? 0.1, 0.02, 0.003, 0.0004, 0.00005
Since the considerable integer one is at the tenth spot, which would be the greatest stance after
the decimal point, the greatest number is 0.1.
Question 8
-90 men and 60 women were asked whether they had watched the latest ‘Expendables’ movie.
- The fraction of people that said yes = 3/5
-Fraction of women that said yes = 3/10
-Fraction of men that said yes = 3/5 – 3/10 = 3/10
-Fraction of men that said no = 1 – 3/10 = 7/10
-Number of men that said no = 7/10 x 90 = 63
-Percentage of men that said no = 63/90 x 100 = 70%
Question 9
-Annabelle lives at Bermondsey in London.
-She is required to speak in Birmingham at 10:30 am
-It will take her an hour (1 hr) to get to from her house to Euston Station, where she gets the
train to Birmingham
-The train journey from Euston Station to Birmingham is an hour and 10 minutes (7/6 hrs)
- The meeting venue In Birmingham is a 5-minute (1/6hr) walk from the station.
Therefore, total time it will take Annabelle to journey from her house to the meeting venue is =
1 hrs + 7/6 hrs + 1/12 hr = 27/12 hrs = 2 hours 15 minutes
In order to calculate the time, the total time needed to get the meeting venue from the
scheduled time
=(10hrs 30minutes) – (2hrs 15 minutes) = 8hr 15minutes
Even though the train that runs from Euston to Birmingham comes at 5 minutes past the hour,
25 minutes past the hour and 45 minutes past the hour.

Therefore, the latest time that Annabelle can leave the house is at 8 : 15am
Question 10
The weight of Shredded Wheat = 0.35 = 35/100 The weight of Weetabix box = 9/25
Now we need to convert them into numbers (35,36)/100
From the above, the value of the Shredded Wheat is 35, while that of the Weetabix is 36
Therefore, the Weetabix is heavier
Part 2
The Medals Table for Summer Olympic Games has been provided in the table shown below.
(a) From the provided data, the country that has the lowest number of overall medals among the
10 countries is Hungary with 491 medals.
(b) The country/countries that competed in the least number of games are China and Soviet
Union with 10 games
(c) The mode in the number of games countries participated in is 28 (France and Great Britain)
(d) The range between the gold medals awarded to the 10 countries is = 1022 – 147 = 875
(e) There are 4 countries that got more silver medals than bronze medal and they are China,
Great Britain, Soviet Union, and United States.
(f) Apart from the United States, Germany and Soviet Union has more gold metals, ,more silver
medals and more bronze than Great Britain
(g) The maximum amount of prizes won in each match should always be tabulated in order to
determine which nation performs better. Using the information in the table above, this may be
computed by splitting the overall numbers of medals won by the variety of sports in which each
nation has competed (Costa, Coelho and Medina, 2018).
Australia :
497/26 = 19.12

China : 543/10
= 54.3
France : 713/28 = 25.46
Germany: 937/24
=39.04 Great
Britain : 847/28
=30.25 Hungary :
491/26 = 18.88
Italy : 577/27 =
21.37
Soviet Union:
1122/10 = 112.2
Sweden : 494/27=
18.30 United States:
2520/27 = 93.33
Depending on the statistics provided, it is clear that the Soviet Union is the country that
executes the best, as seen by the fact that they receive the most honours each encounter (112.2
medals per match).
(h) There could be a multitude of factors why a nation like Jamaica that is famed for its
athletes, does not rank in the top 10. The fact that they have a low demographic density in
comparison to other nations may be the main explanation for their lack of participation in
numerous events. The larger a nation's population, the more likely it is to participate in more
events and, as a result, to rank from among top 10 winning nations. Furthermore, when
compared to other sports, such as group sports, where individuals are seldom involved, the
physical duties done in Olympic games are little (Dai and Jiang, 2016).
(i) According to the chart, the Soviet Union is the United States' nearest rival, thus every award
class in the United States will be contrasted to the Soviet Union's.
Gold medal US = 1022
Soviet Union = 440
The difference = 1022 – 440 = 582
Silver medal US = 794
Soviet Union = 357
The difference = 794 – 357 = 437
Bronze medal

US = 704
Soviet Union = 325
The difference = 704 – 325 = 379
From the above calculation, the medal category in which the United States far outperformed
its closest competitor Soviet Union is the Gold medal category
(j) In order to determine 3 countries with the most evenly distributed number of golds, solve
and bronze metals, countries with the least small range will be identified
Australia
Gold Silver Bronze
147 163 187 Range = 187 – 147 = 40
Chin
a
Gold
Silver Bronze
227 165 151 Range = 227– 151 = 74
France
Gold Silver Bronze
212 241 260 Range = 260 – 212 = 48
Germany
Gold Silver Bronze
275 313 349 Range = 349 – 275 = 74
Great Britain
Gold Silver Bronze
263 295 289 Range = 295 – 263 = 32
Hungary
Gold Silver Bronze
175
Italy
147 169 Range = 175 –
147 = 28

Gold Silve
r
Bronze
206 178 193 Range = 206 –
178
= 28
Soviet Union
Gold Silver Bronze
440 357 325 Range = 440 –
325
= 115
Sweden
Gold Silver Bronze
147 170 179 Range = 179 – 147 = 23
United States
Gold Silve
r
Bronze
1022 794 704 Range = 1022 – 704 =
318
From the above analysis, the 3 countries with evenly distributed medals are Sweden, Hungary,
and Italy
Part 3
Further directions on how to execute other Microsoft Office operations would be provided
based on the statistics in the datasets (Emilien, Weitkunat and Lüdicke, 2017).
From the foregoing statistical measures, a well-designed comparison chart would've been
constructed utilizing Excel Soft, as illustrated. The graph shown above was created in Excel and
can be seen in the image beneath-

The accentuating option and the relevant component would've been chosen to highlight the
region given in the given data, as shown in the accompanying figure.
The entire chart is then illustrated and explained in the picture beneath, including with all of its
key features (Faraji-Rad, Melumad and Johar, 2017).

Question 13
(a) The processes or operations to be conducted in order to appraise the country's total medals
from 1st to 10th place are explained following, based on the preceding facts.
(b) The approach was to type "=rank(G3,G3:G12)," and the outcome is shown in the diagram
below-

(c) The stacked bar chart is a visual depiction of information which would be sufficient or
appropriate for showing just gold medals.
(d) The sections "Team" and "Total" should indeed be duplicated in their entirety.
(e) The "SUM(G3:G12)" feature in Excel could be used to compute the total quantity of prizes
received, as seen in the image beneath-
Question 14
(a) The overall number of medals for Germany and the United Kingdom could be computed
utilizing Excel's "Sum (G6 and G7)" calculation, as illustrated in the graphic beneath-
(b) The approach depicted in the diagram beneath might also be used to get the overall mean
quantity of silver medals earned by all European nations (Katikireddi and Reilly, 2017).

(c) The method represented in the graph beneath has also been used to determine aggregate
gold medals for nations who have already competed in less than 20 tournaments.
(d) The studying and researching processes would have been used in the newly designed Excel
Spread Sheet to locate Italy and its associated medals count (Kerzner, 2019)(Lock, 2020).
Therefore, "=Find(A9:G9)" is the method to use. The expansion is depicted in the diagram
below:
Question 15
(a) > The methodology can then be used to calculate the median quantity of medals for every
medal category, as shown in the figure beneath-
The median for a gold medal is calculated using the formula "=median (D3:D12)," as shown in
the picture below.

The median for the Silver medal is calculated using the formula "=median (E3:E12)," as shown in the
graphic beneath-
As shown in the graphic beneath, the technique “=median (F3:F12)” is being used to calculate the median
for a Bronze medal.
(b) The method might have been used to obtain the mean regularity of medals received in each medal
category, as shown in the graph beneath-
The equation "=Average (D3:D12)" is used to determine the mean for the Gold medal, as shown in the
diagram beneath-

The mean for the Silver medal is calculated utilizing the formula "=Average (E3:E12)," as shown in the
diagram.
The mean of the Bronze medal is computed utilizing the formula "=Average (F3:F12)," as shown in the
diagram beneath-
(c) Considering references, the mean of the gathered information, and also the standard deviation of the
dataset supplied, would have been determined initially.
Mean = Total outcome/ number of outcome (N) Total outcome = 8741
Number of outcome (N) = 10
Mean = 8741/10 = 874.1 (the let mean be presented as u and the total medal for each country will be
represented x and we can determine (x-u) and (x-u)^2 as shown in the table below
From the provided data table, the following parameters can be deduced (x-u)^2 = 3432426.9

√
N = 10
Now, we can apply the provided standard deviation formula as illustrated below.
x−u ¿ 2
¿
¿
∑ ¿
¿
σ =√¿
σ = 3432426.9 =585 .8710
σ =585.87

Depending on the information supplied, the "STDEVP" technique in Excel was used to validate
and cross-check the estimated standard deviation of total medals for each nation, with the
findings achieved in the image below-
The computed standard deviation is 585.8691748, whereas the expected standard deviation is
585.87, indicating that the increase to observed data is correct.
(d) The spreadsheet could be used to calculate the anticipated standard deviation, which is
important for comprehending the prediction technique. The standard deviation is a statistic of
how far a given outcome deviates on average from the mean. As an outcome, a low standard
deviation means that the data are close to average, whereas a high standard deviation indicates
that the data is more scattered out. The standard deviation of 585.87 in the dataset obtained
implies that nations with greater tallies are on average 585.87 away from the distribution's
mean. The standard deviation in this data can be used to assess how far different nations'
overall wins vary from the mean cumulative medals, such as the United States, the Soviet
Union, and Australia (Rowe, 2020).
Question 16
(a) > A visualization that contrasts the aggregate gold, silver, and bronze medals of the ten
countries.

Olympic Games Medal Table
1200
1000
800
600
400
200
0
Australia China France Germany Great Britain Hungary Italy Soviet Union Sweden United
States
Counrties participated in the Olympics
Total Games Gold Silver Bronze
(b) The graphic or chart beneath illustrates a properly annotated and labelled chart to show
each country's contribution to the accomplishment award (Watson and Nehls, 2016).
Number of
medal

Olympic Games Medal Tables
10000
9000
8000
7000
6000
5000
4000
3000
2000
1000
0
1
Contribution of each country to the total medals
Australia China France Germany Great Britain
Hungary Italy Soviet Union Sweden United States
Number of
Medals

Conclusion
This study calculated and evaluated the arithmetic and IT expertise that was delivered.
Mathematical aptitude is defined as the capacity to understand and implement precise forecasting
notions. Division, multiplying, adding, and subtracting are all basic arithmetic techniques that
should be comprehended. People must learn arithmetic in order to build logic and reasoning and
cognitive talents in their daily lives. Mathematics is essential for activities such as eating, issuing
directions, calculating payments, and playing in ability to continue providing solutions to issues
and improve rapport of mathematics, rhythms, ratios, and forms. Education and numeracy are
two important concepts which can actually assist individuals acquire the necessary skills to
succeed in life. There is a thorough method for improving mathematics and linguistic
capabilities, and also assisting pupils in lead a good and rewarding life and participating to their
society as an engaged and well-informed member. This arithmetic program is broken down into
three sections, each of which should be completed independently.

References
Books and journals
Aoun, M. and Alaaraj, H., 2019. Balancing Hospital's Financials through Implementing Cost of
Quality Models. Journal of Accounting and Finance in Emerging Economies, 5(2),
pp.197-202.
Appel, K. and Pipa, G., 2017. Auditory evoked potentials in lucid dreams: A dissertation
summary. International Journal of Dream Research. pp.98-100.
Atrill, P. and Lindley, L. eds., 2019. Issues in Accounting and Finance. Routledge.
Costa, M. M., Coelho, P. F. and Medina, I. G., 2018. The written production of argumentative
and dissertation text: a didactic project based on Bakhtin's philosophy. ETD: Educação
Temática Digital. 20(2). pp.518-538.
Dai, Y. and Jiang, Y., 2016, May. The Research of Online Reviews' Influence towards
management response on Consumer Purchasing Decisions. In WHICEB (p. 43).
Emilien, G., Weitkunat, R. and Lüdicke, F. eds., 2017. Consumer perception of product risks and
benefits (pp. 23-38). New York, NY: Springer International Publishing.
Faraji-Rad, A., Melumad, S. and Johar, G.V., 2017. Consumer desire for control as a barrier to
new product adoption. Journal of Consumer Psychology, 27(3), pp.347-354.
Katikireddi, S. V. and Reilly, J., 2017. Characteristics of good supervision: a multi-perspective
qualitative exploration of the Masters in Public Health dissertation. Journal of Public
Health. 39(3). pp.625-632.
Kerzner, H., 2019. Using the project management maturity model: strategic planning for project
management. John Wiley & Sons.
Lock, D., 2020. Project management. Routledge.
Rowe, S.F., 2020. Project management for small projects. Berrett-Koehler Publishers.
Watson, D. L. and Nehls, K., 2016. Alternative dissertation formats: Preparing scholars for the
academy and beyond. In Contemporary approaches to dissertation development and
research methods (pp. 43-52). IGI Global.