Using Numeracy Data & IT - Desklib

This article covers topics related to numeracy data and IT, including numerator, denominator, HCF, equivalent fractions, calculating discounts, and more. It also includes a data analysis of medals won by different countries in various games.

USING NUMERACY DATA
AND IT

Table of Contents
PART-1............................................................................................................................................3
Q1................................................................................................................................................3
Q2................................................................................................................................................3
Q3................................................................................................................................................3
Q4................................................................................................................................................4
Q5................................................................................................................................................5
Q6................................................................................................................................................5
Q7................................................................................................................................................5
Q8................................................................................................................................................6
Q9................................................................................................................................................6
Q10..............................................................................................................................................7
PART-2 USING DATA..................................................................................................................7
Q11..............................................................................................................................................7
PART-3..........................................................................................................................................10
Q12............................................................................................................................................10
Q13............................................................................................................................................11
Q14............................................................................................................................................13
Q15............................................................................................................................................16
Q16............................................................................................................................................19
REFERENCES................................................................................................................................1

PART-1
Q1
Numerator:
It is the number which is above the line of vulgar fraction which the number of parts that
is indicated by the denominator (Bottge, Cohen and Choi, 2018). In other words, it can also be
defined as number which is divided by the denominator. It can also be called as dividend.
Denominator:
This is the number which is below the line of vulgar fraction. This is also called divisor. It
is the main part that is depict the result (Pontius and et.al., 2017). It also shows the total
population in term of statistical value.
Q2
In order to find the simplest form of the expression i.e. 24/40 and 18/42 the process will
begin with the taking of HCF (Highest common factor) of the fraction with the dividing of
numerator and denominator with HCF with the emergence of fraction with lowest term.
Numerator 24 18
Denominator 40 42
The Simplest form 24/40 = 3/5 18/42 = 3/7
Q3
a.)
Numerator 2 3 5
Denominator 3 4 6
Equivalent fractions
with denominator 12
4 3 2
New fraction 2/3 * 4/4 = 8/12 3/4 * 3/3 = 9/12 5/6 * 2/2 = 10/12

Two or more fraction would be equivalent to same fraction only when simplification
would be equivalent. Thus, the value of numerator and denominator would be simplified with the
same value.
b.)
Total books in library 60,000
Psychology and law books 12,000
Healthcare books 22,000
Business books 14,000
Remaining books 12,000
Computing books i.e. 2/3 of remaining books 12,000 * 2/3 = 8,000
Computing books % 8,000/60,000 * 100 = 13.33%
In order to make calculation of computing books, the process will begin with the
computation of remaining books. As computing books are 2/3rd of the remaining books, so with
the calculation of remaining books it will be 2/3rd so that computing books would be determine.
Q4
Pairs of shoes bought by Liz 2
Amount given by Liz £50 notes
Total money Liz gave £150 (50*3)
Money that is returned back £10.50
Thus, total price of 2 pairs of shoes £139.50
Therefore, Price of 1 pair of shoes £69.75
In order to calculate one pair of shoe, firstly the total amount is being calculated i.e. 50*3=
£150. Later the amount that is returned back is subtracted to determine the exact amount. This is
the total sum which is related with the 2 pair of shoes and when it is divided by 2 then the price
of one pair of shoes is determine.

Q5
a.) 240.50×19.54 = 4699.37
b.) 52100 = 5.21×1000
= 5.21×10^4
This 52100 represent the number as a power of 10
Q6
a)
Discount offer 30%
Patty and her 2 siblings make 70% payment of
the total amount
£210
1% = (£210 / £70) £3
100% £300
Total savings £300 - £210 = £90
Patty and 2 siblings which means total 30% discount. This also means that they had made
a payment of 70% in total. In order to calculate total saving firstly the 100% is calculated. As 1%
is equal to 210/70 i.e. £3 which means 100% will be £300. This means total saving will be 300-
210 = 90.
b)
In order to calculate average saving per person the total saving i.e. £90 will be divided by 3
(3 person). Thus, the average per person saving will be £30.
Q7
a)
= 3/4-7/9+2/3
= 0.63
b)

Among all, the largest number is 0.1.
Q8
Total number of Men 90
Total number of Women 60
Total number of people 150
Total people said yes 90
From total people number of women said yes 3/10 * 90 = 27
Total Men said yes 90 – 27 = 63
Total Men said no 90 – 63 = 27
In order to calculate total number of men who said no, firstly the total number of people
were calculated. After that number of people who said yes is determined i.e. 90. From that the
number of women said yes i.e. 3/10 is calculated which is 27. This will lead to determine the
number of men said yes i.e. 90-27 = 63. While making a subtraction from total people i.e. 90-63
(men said yes), Number of men said No is calculated.
Q9.
Conference time in Birmingham is 10:30 am.
For that, she has to leave her home at 08:00 am.
The steps will be described as below:
As the time to approach the Euston Rail station from her home is 1 hour so she will reach at 9am.
Running time of Birmingham trains:
5 minutes past the hour, 25 minutes past the hour and 45 minutes past the hour i.e. she will grab
the train at 9.05 am.
Time taken by train from Euston to Birmingham is 1 hour & 10 min. This mean she will reach to
Birmingham at 10:15 am.
Since the meeting venue in Birmingham is 5-minute walking distance from the station. This
means she will reach the venue around 10:20 am.

Q10.
Weight of Shredded wheat box 0.35 kg
Weight of Weetabix box 0.36 kg
Weetabix box is heavier by 0.01 kg
PART-2 USING DATA
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 496
United States 27 1,022 794 704 2,520
Q11
a) Among the ten countries the Hungary has lowest number of medals i.e. 491. This is being
calculated with the formula of minimum function in excel i.e. =MINIMUM (1,2,3,).
b) China and Soviet Union competed least or participated least i.e. 10 among the games from
all the countries. This is also calculated with MINIMUM formula of excel (Fairhurst, 2017).

c) Mode is that number which rapidly occurs in the given set of data. In the current question the
mode is 27 because it occurs 3 times.
d) Range is the category i.e. lowest to highest. In case of goal medal awarded the range is 147-
440.
e) In order to determine the countries that got more silver medal than bronze medal, a
comparison is made i.e.
Countries Silver Medal Bronze Medal
Great Britain 295 > 289
United States 794 > 704
China 165 > 151
Soviet Union 357 > 325
As per the above comparison there are 4 countries which got high silver meal than bronze medal.
f) As per the above analysis of table it can be analysed that country Germany and Soviet Union
has got 275, 440 gold medals, 313, 357 silver medals and 349, 325 Bronze model which is
higher than Great Britain.
g)
Team Comparing between the number of total games
with overall number of medals received
France 713/28 = 25.46
Germany 937/24 = 39.04
Australia 497/26 = 19.11
Sweden 496/27 = 18.37
China 543/10 = 54.3
Soviet Union 1122/10 = 112.2

Great Britain 847/28 = 30.25
Hungary 491/26 = 18.88
Italy 577/27 = 21.37
United States 2,520/27 = 93.33
As per the above analysis and calculation it can be states that US has got highest number of
medals per game.
h) The Jamaica country although is quite good in athletics but it is far behind the grabbing of top
ten medals because:
It has lack of resources in terms of presence of adequate trainer, equipment, and other related
and necessary resources that could assist the country in the grabbing of medals.
The another reason includes the low population intensity. This means the population of the
country is low and the people are not quite interested in participation.
i)
Team Total Games Gold Silver Bronze Total
Soviet Union 10 440 357 325 1122
United States 27 1,022 794 704 2,520
As per this table it can be analysed that Soviet Union is far outer-performed in case of Bronze
medals i.e. 325 Bronze for Soviet Union and 704 for US.
j)
Team Gold Silver Bronze Range (highest-
lowest)
Australia 147 163 187 187-147 = 40
Germany 275 313 349 349-275 = 74

Great Britain 263 295 289 295-263 = 32
Hungary 175 147 169 175-147 = 28
France 212 241 260 260-212 = 48
United States 1,022 794 704 1,022-704 = 318
China 227 165 151 227-151 = 76
Italy 206 178 193 206-178 = 28
Soviet Union 440 357 325 440-325 = 115
Sweden 147 170 179 179-147 = 32
From the above table is clear that Italy, Sweden, Hungary and Great Britain has most evenly
distributed no. of gold, silver and bronze medals.
PART-3
Q12
The spread sheet is as follows that is also attached with the file.
Q13
a) Steps and action in association with ranking:
The first step will begin with the insertion of formula of RANK i.e. =RANK (number, ref,
[order]).

This will be followed with the selection of row or column that is needed to be ranked. After that
press the enter key (Jelen and Alexander, 2018).
The later step will involve the dragging of mouse in either rows and columns.
The last step is the order arrangement that would arrange the data in ascending or descending
order. In this question the rank is done in ascending order:
From the above calculation, it can be analysed that US with 2520 ranked 1st and
Hungary with 491 medals ranked 10th.
b) In order to produce a list and of countries with 800 or more medals then IF excel formula will
be used. This formula is as follows =IF (logical test, [value if true], [value if false] (Divisi and
et.al., 2017).

From this calculation it can be analysed that there are majorly 4 countries whose number of
medals are 800 or more. These are United States, Great Britain, Soviet Union and Germany.
c) In order to represent only Gold medals the column chart would be considered as most suitable
and appropriate. This is because it shows the information of single aspect in the specific point of
time (Hossain, 2021). This is shown below:

d) Replication refers to the method under which the same data will be copied and written down
in column and rows. This can be understood with the aspect under which one formula will be
inserted in one row and column will be replicated with the help of dragging option.
e) Sum excel formula will be used in order to make calculation of total medal awarded. This
formula is as follows: =Sum (number1, number2, number3 …......).
From the above calculation and formula, it can be understood as the total medals which is
awarded to all 10 countries are 8743
Q14
a)
In order to calculate the total number of medals that can be given to Germany and Great Britain
would be calculated with the help of sum formula i.e. =Sum(number1, number2 …....)
With this formula the sum and total of rows and column would be able to get calculated (Jelen,
2018).

As per the above table the number of medals to Germany is 937 and that of Great Britain is
847.
b)
In order to determine the average number of silver medals for European countries, the specific
countries that belong to European countries would be identified which are as follows: Italy,
Sweden, Hungary, Germany and France. After that the Average formula will be used in the
excel which is as follows:

c)
With the help of IF formula i.e. =IF (logical test, [value if true], [value if false] the
identification of countries that hold the sum of gold with less than 20 games involvement would
be determined. This will be followed with the implementation of sum formula that shows the
total number of medals.
1st step:
d)
In order to search the database with the finding of Italy and corresponding medal total the
VLOOKUP formula i.e. =VLOOKUP (“Italy”; A109:A119; 6; False) will be used. Here in
false place 0 will be used so that the sum of total will be calculated (Mayes, 2020). With this
analysis it can be analyzed that Italy has 577 medals.

Q15
a)
The median is the middle number that lie within the whole database. Its formula is {(n + 1)/ 2}th.
The median of Gold medal with the help of this formula is 219.5. The median of Gold, Silver
and Bronze medals with the use of excel formula is 219.5, 282.3 and 280.6.

b)
Mean is average which is generally the central value of the group of values and data set (Dean
and Illowsky, 2018). Its formula is Mean = X1 + X2 + X3 …..../ n, where n is total counts.
Mean for Bronze Medals: 2806/10 = 280.6.
With respect to the use of excel calculations, the mean of gold, silver and bronze is 311.4,
282.3 and 280.6

c)
Standard deviation formula √ ∑ (x – u)2 / N that defines the distance of each value with its
mean.
Team Gold Silver Bronze Total x-mean (x-mean)^2
Australia 147 163 187 497 -377.3 142355.29
China 227 165 151 543 -331.3 109759.69
France 212 241 260 713 -161.3 26017.69
Germany 275 313 349 937 62.7 3931.29
Great
Britain 263 295 289 847 -27.3 745.29
Hungary 175 147 169 491 -383.3 146918.89
Italy 206 178 193 577 -297.3 88387.29
Soviet
Union 440 357 325 1122 247.7 61355.29
Sweden 147 170 179 496 -378.3 143110.89
United
States 1022 794 704 2520 1645.7 2708328.49
Average 874.3 Total 3430910.10
(x-mean)^2/n 343091.01
Standard Deviation 585.7397118

With the application of this formula the SD is 585.869.
d)
Although Jamaica is one of the best country in respect to athletics, but the country is not
big in comparison with top 10 countries. Likewise, Jamaica is not large enough that it can
compete with these countries. Also the population of Jamaica is low.
Q16
a)
Chart that compare Gold, Silver and Bronze medals of total 10 countries:
b)
In order to prepare the chart that reflect contribution of each country to overall medals
total weight is needed to be calculated. The formula for the calculation of weight is as follows:
total medals/ overall total medals of all ten countries.
Chart:

REFERENCES
Books and journals
Bottge, B.A., Cohen, A.S. and Choi, H.J., 2018. Comparisons of mathematics intervention
effects in resource and inclusive classrooms. Exceptional Children. 84(2). pp.197-212.
Dean, S. and Illowsky, B., 2018. Descriptive statistics: skewness and the mean, median, and
mode. Connexions website.
Divisi, and et.al., 2017. Basic statistics with Microsoft Excel: a review. Journal of thoracic
disease. 9(6). p.1734.
Fairhurst, D.S., 2017. Financial Modelling in Excel.
Hossain, E., 2021. Graphing and Charting. In Excel Crash Course for Engineers (pp. 19-115).
Springer, Cham.
Jelen, B. and Alexander, M., 2018. Microsoft Excel 2019 Pivot Table Data Crunching. Microsoft
Press.
Jelen, B., 2018. Excel. Strategic Finance. 99(9). pp.66-67.
Mayes, T.R., 2020. Financial analysis with microsoft excel. Cengage Learning.
Pontius, and et.al., 2017. Rules to write mathematics to clarify metrics such as the land use
dynamic degrees. Landscape Ecology. 32(12). pp.2249-2260.
1