Using Numeracy Data

This study material covers topics such as numerator, denominator, simplifying fractions, equivalent fractions, computation, and more. It also includes using data and IT for analysis. The subject, course code, and college/university are not mentioned.

USING NUMERACY DATA

PART 1 - USING NUMERACY.....................................................................................................1
Question 1................................................................................................................................1
Question 2.................................................................................................................................1
Question 3.................................................................................................................................1
Question 4.................................................................................................................................2
Question 5.................................................................................................................................2
Question 6.................................................................................................................................3
Question 7.................................................................................................................................3
Question 8.................................................................................................................................3
Question 9.................................................................................................................................4
Question 10...............................................................................................................................5
PART 2- USING DATA..................................................................................................................5
Question 11...............................................................................................................................5
PART 3- USING IT.........................................................................................................................7
Question 12...............................................................................................................................7
Question 13...............................................................................................................................7
Question 14...............................................................................................................................9
Question 15.............................................................................................................................11
REFERENCES..............................................................................................................................14

PART 1 - USING NUMERACY
a) Numerator
It is concerned with the number which is in a vulgar fraction reflecting that how many
parts are taken by the denominator. It is the top one of shown fraction which helps in
understanding that how many parts highlighted out of total number (Häcker and Ernst, 2017).
For example- 2/5 people are suing financial techniques to achieve their organizational
objectives. In this case 2 is numerator which is indicating that 2 out of 5 are using financial
techniques.
b) Denominator
The number of equal parts that are needed to make up whole, which is shown in below
the fraction is called denominator. The bottom number of fraction which actually indicates total
of shown phenomenon. For instance- In 3/8, denominator is 8.
Question 2
 The first step followed for simplifying fraction includes that highest common factor of
number and denominator is found. The second step is to pay attention on dividing the
fractions with its HCF
 In the given question, the HCF of 24 & 40 is 8 and 18 & 42 is 6. Next step is to divide
fractions like 24/40 by 8 and 18/42 by 6. By following this two step, obtained outcome is
3/5 and 3/7
 24/40= 3/5 and 18/42= 3/7
Question 3
A)
Equivalent fraction is defined as having different numerator and denominator but defining the
same value (halley and Stewart, 2017). In addition to this it is associated with paying attention
on equalizing the values of fraction. In the given case, it is asked to make denominator same
by value 12which is as follows:
2/3 = 2/3*4/4 = 8/12
3/4 = 3/4*3/3 = 9/12
1

5/6 = 5/6*2/2 = 10/12
c) Computation of computing books (In %)
Number of computing books ( Remaining books*2/3)
= Total books (business+ healthcare+ h psychology& law)
= 60000 – 48000 (14000+ 22000+ 12000)
=12000
Computing books = 12000*2/3
= 8000
Percentage of computing books = 8000/60000*100
= 13.33%
Question 4
Total number of pair of shoes purchased by Liz = 2
Total money given by Liz to attendant = 3 crisps $50 = 3*50 = $150
Amount returned by attendant = $ 10.50
Determination of price of two pair of shoes bought by Liz= Total money paid by Liz -
attendant returned money to Liz
= £150 - £10.50
= £139.50
Price of each pair of shoes = 139.50/2
= 69.75
On the basis of this it can be interpreted that each pair has bought by paying price of $69.75
Question 5
a)
= 240.50 * 19.54
= 4699.37
b) Determining 52100 as a power of 10
= 5.21*10^4
Question 6
Offered discount =30%
2

Paid amount = 70%
Total amount paid = 210 (70% of total amount)
Total amount = 100%
= 1% = 210/70 = 3
= £300
Total amount saved= total amount - amount paid
= 300-270
= 90
b)
Average of one person is = 90/3 = £30
Question 7
a)
3/4 = 0.75
7/9 = 0.78
2/3 = 0.66
3/4 - 7/9 + 2/3 0.75 – 0.78 + (0.66)
Ans 0.63
b)
From the assessment, it can be interpreted that largest number among all of shown figure =
0.1
Question 8
Particulars Working
Total number of men in the given case 90
Total number of women 60
3

Total number of people watched the latest Expendables movie 150
Number of people who answered yes 3/5 *150 = 90
Number of women answered yes 3/10*60 = 18
Total men who said yes (=number of people answered yes- total
number of women answered yes) 90-18 = 72
Total number of men who said no 90-72 = 18
Percentage of men who said no 18/90*100
= 20%
Question 9
Particulars Working
Time of conference 10.30
am
leaving time from home 8.00 am
Time to get Euston Rail station 1 hr
she will be reach at Euston Rail station 9.00am
5 minutes past the hour, 25 minutes past the hour and 45 minutes past the hr, in turn
she will get her train
= 9.05
am.
Journey from Euston to Birmingham is 1 hour & 10 minutes so she will arrive at 10.15
am
The meeting venue in Birmingham is a 5-minute walk from Euston Rail station, in
turn she will arrive there
10.20
am
On the basis of this, it can be interpreted that she will reach 10 minutes prior to the meeting.
Question 10
Shredded wheat weight 0.35
4

box of Weetabix weight (9/25 kg) 0.36
difference between both the box 0.01
On the basis of this, it can be identified that a box of is heavier as it has more weight of 0.01kg
as compared to Shredded wheat weight
Question 11
a) Hungary is the country which has lowest number of medals as compared to presented ten
countries
b) China and Soviet Union are the countries who have completed least number of games.
c) 27 is the mode number of games which the countries have participated.
d) range = largest value- lowest value = 1022- 147 = 875.
The range of gold medal awarded to 10 countries has been computed by subtracting lowest from
the highest which is 875
e) Countries that got more silver medals than bronze medals are Soviet Union, United State,
China and Great Britain,
f)Apart from US the country who got more gold, silver and bronze medal more than Great
Britain is two that is Soviet Union and Germany.
g)
Team
Total
games
total
medal
Medal per game (total medal /
Total game)
Australia 26 497 19.12
China 10 543 54.30
France 28 713 25.46
Germany 24 937 39.04
Great Britain 28 847 30.25
Hungary 26 491 18.88
Italy 27 577 21.37
Soviet Union 10 1122 112.20
Sweden 27 496 18.37
United States 27 2520 93.33
5

h)
The main two reasons for which Jamaica is not included in top 10 list as it does very
well in athletics includes
It does not much population as compared to the mentioned countries which is considered
to be one of the biggest reason. Another reason underlying the fact fro which it has not be
included in presented list is that it is very small nation as compared to shown nations.
i)
Team Gold Silver Bronze
Soviet Union 440 357 325
United States 1022 794 704
Percentage change Soviet Union/ US *100) 43% 45% 46%
j)
Team max min range
Australia 187 147 40
China 227 151 76
France 260 212 48
Germany 349 275 74
Great Britain 295 263 32
Hungary 175 147 28
Italy 206 178 28
Soviet Union 440 325 115
Sweden 179 147 32
United States 1022 704 318
It can be interpreted from the above table presenting range, the top 3 countries on the
basis of least smallest range include
 Hungary and Italy with range of 28
6

 Great Britain and Sweden with range of 32
 Australia with a range of 40
PART 3- USING IT
Question 12
Formulation of excel sheet (Attached in excel)
Question 13
a)
In the excel, ranking the list can be done by following steps:
Firstly identify the list which is need to be ranked, then using =rank (number, ref, [order])
formula which already inbuilt in excel (Charitaki, Soulis and Alevriadou, 2021). In addition to
this, enter key is pressed after entering number, ref and order.
Team
Total
Games Gold Silver Bronze Total Rank
Australia 26 147 163 187 497 8
China 10 227 165 151 543 7
France 28 212 241 260 713 5
Germany 24 275 313 349 937 3
Great Britain 28 263 295 289 847 4
Hungary 26 175 147 169 491 10
Italy 27 206 178 193 577 6
Soviet Union 10 440 357 325 1122 2
Sweden 27 147 170 179 496 9
United States 27 1022 794 704 2520 1
b.
The action that is undertaken for finding solution, If function has been utilize so that true or
false condition can be applied.
Team Total
Games
Gold Silver Bronze Total List of
countries
with 800 or
7

more medals
in total
Australia 26 147 163 187 497 0
China 10 227 165 151 543 0
France 28 212 241 260 713 0
Germany 24 275 313 349 937 Germany
Great Britain 28 263 295 289 847 Great Britain
Hungary 26 175 147 169 491 0
Italy 27 206 178 193 577 0
Soviet
Union 10 440 357 325 1122
Soviet
Union
Sweden 27 147 170 179 496 0
United
States 27 1022 794 704 2520
United
States
C. Scatter line with marker can be sued to present data
d) From the evaluation while working in excel it can be articulated that while working in excel,
number of formulas has been used & also copied similar formula for accomplish objective
report. In the given case regarding Olympic data, rank related formula can be implemented all
of the data.
8

e) There is availability of sum function in excel that can be utilized in overall medals s that are
awarded to different nation (Rohaeti, Bernard and Primandhika,2019.).
Question 14
a
For the purpose of calculating total of the function of sum can be used in excl in order to getting
total number of medals for Germany and Great Britain
Teams
Total
Games Gold Silver Bronze Total
Germany 24 275 313 349 937
Great Britain 28 263 295 289 847
B.
The function for calculating the average number of silver medals for European countries,
function of average can be used
Teams Silver
medals
France 241
Germany 313
Hungary 147
Italy 178
Sweden 170
average 209.8
.
c. The sum of the countries who are having less than 20 game involvement is 667 which is
determined by applying function of sum.
Team Total Games
China 10 227
Soviet Union 10 440
667
9

d. In order to search the whole data base presented in workbook for searching Italy and the
corresponding medals total the function of VLOOKUP can be taken into consideration.The
VLOOKUP is used in order to find a certain value within the column.
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 1022 794 704 2520
data of italy and its corresponding
medal total 577
Question 15
a) Formula =MEDIAN (range) is used.
Calculation of median for each type of
medals
Gold 219.5
Silver 209.5
Bronze 226.5
b.
mean for three types of medal is =MEAN (data range) is used
Calculation of mean for each three types of
medals
Gold 311.4
10

Silver 282.3
Bronze 280.6
c.
11

Team Total X-μ (X-μ)2
Australia 497 -377.3 142355
China 543 -331.3 109760
France 713 -161.3 26017.7
Germany 937 62.7 3931.29
Great Britain 847 -27.3 745.29
Hungary 491 -383.3 146919
Italy 577 -297.3 88387.3
Soviet Union 1122 247.7 61355.3
Sweden 496 -378.3 143111
United States 2520 1645.7 2708328
874.3 3430910
SD 343091
585.74
STDEV.P 585.7397118
d.
Standard deviation i widely taken into consideration for computing the dispersion of data
(Jelen, 2019). It aids in reflecting the data near to mean and in against to this, in case of large
deviation there is possibilities that spread within result is higher.
a)
12

b)
13

REFERENCES
Books and Journals
Charitaki, G., Soulis, S.G. and Alevriadou, A., 2021. Factor structure of early numeracy:
evaluation of a measurement model in greek-speaking children with intellectual
disabilities. International Journal of Developmental Disabilities, pp.1-10.
Häcker, J. and Ernst, D., 2017. Workshop Excel Part II. In Financial Modeling (pp. 143-201).
Palgrave Macmillan, London.
Jelen, B., 2019. Excel: THE NEW XLOOKUP FUNCTION. Strategic Finance, 101(4), pp.56-
57.
Rohaeti, E.E., Bernard, M. and Primandhika, R.B., 2019. Developing Interactive Learning
Media for School Level Mathematics through Open-Ended Approach Aided by Visual
Basic Application for Excel. Journal on Mathematics Education, 10(1), pp.59-68.
Shalley, F. and Stewart, A., 2017. Aboriginal adult English language literacy and numeracy in
the Northern Territory: A statistical overview. Charles Darwin University.
.
14