Numeracy, Data & IT in Everyday Life

This document discusses the importance of numeracy, data, and IT in everyday life. It covers topics such as fractions, equivalent fractions, simplifying fractions, and more. It also includes examples and explanations to help understand the concepts better.

USING NUMERACY,
DATA & IT

Table of Contents
Table of Contents.............................................................................................................................2
INTRODUCTION...........................................................................................................................1
MAIN BODY..................................................................................................................................1
QUESTION 1..................................................................................................................................1
QUESTION 2..................................................................................................................................2
Question 3........................................................................................................................................3
(A)Expressing the fractions 2 / 3, 3 / 4 and 5 / 6 equivalent with a denominator of 12..............3
(b) Explain of the 2/3 of remaining.............................................................................................3
QUESTION 4..................................................................................................................................3
QUESTION 5..................................................................................................................................4
What is the value of 240.50*19.54 in two significant figures.....................................................4
Number of 52100 in the power of 10...........................................................................................4
Question 6........................................................................................................................................4
a. Total saving made by Patty and her siblings...........................................................................4
b. Average saving per person.......................................................................................................4
Question 7........................................................................................................................................5
3 / 4 – 7 / 9 + 2 / 3........................................................................................................................5
b. Largest number from all the values.........................................................................................5
QUESTION 8..................................................................................................................................5
The percentage of men that said no.............................................................................................5
QUESTION 9..................................................................................................................................6
The latest time that Annabelle can leave home , if she wants to make it on time for the meeting
in Birmingham.............................................................................................................................6
QUESTION 10................................................................................................................................6
Evaluation of the box which is heavier and which is not............................................................6
QUESTION 11................................................................................................................................6
A determine of the country which have lowest number of overall medals.................................6

b. Determine the countries which has completed least number of games...................................6
c. Determine The mode in the number of games countries participated in this event................6
d. Determine the Range between the gold medals awarded to the 10 countries..........................7
e. Name the countries that got more silver medals than bronze medals.....................................7
f. Name the countries which got more gold, silver and bronze medals than Great Britain.........7
g. Determine the country which performed best.........................................................................7
h. Explain the reasons due to which country like Jamaica does not feature in the top 10
medals..........................................................................................................................................7
i. Determination of the medal category in which the US far outperformed its closest
competitor....................................................................................................................................7
j. The three countries that has most evenly distributed number of gold, silver and bronze medal
.....................................................................................................................................................7
QUESTION 12................................................................................................................................8
Creating the excel including all rows and columns, identifiers, test formatting and column
highlighting..................................................................................................................................8
a. Actions or steps in excel which could be taken to rank the figures from 1 to 10th..................8
b. Specific actions or measures that will produce a list of countries with 800 or more medals in
total..............................................................................................................................................9
c. Graphs will be ready to represent the details of the gold medals only....................................9
d. Column in which multiplication may be applied...................................................................12
e. An excel formula that can be used to calculate total medals.................................................12
QUESTION 14..............................................................................................................................13
a. Excel formula for calculating full medals for Germany and Great Britain...........................13
b. The formula for calculating the average value of silver medals in a European country.......13
c. Excel formula for aggregating the total medals of those regions with less than 20 sports
involvement...............................................................................................................................13
d. Excel formula for searching the database for germany and the total number of medals.......13
QUESTION 15..............................................................................................................................13
a. The calculation of the average number of medals for each type of medal, refers to the
formula used to determine the medal of medals........................................................................13

b. Calculation of mean for the medals along with the formula which is used for the same
calculation..................................................................................................................................14
c. calculation of standard deviation of total medals awarded to each country..........................15
d. Usefulness of a standard deviation in the data set.................................................................17
QUESTION 16..............................................................................................................................17
a. Chart to compare fully labelled chart to compare gold, silver and bronze medal.................17
b. Chart to reflect the contribution of each country to the overall medals total........................18
CONCLUSION..............................................................................................................................18
REFERENCES..............................................................................................................................19

INTRODUCTION
Numeracy mean knowledge to use the mathematics in everyday life, it states the ability to
solve the problems using the number in the reality. It is use in everyday life means having
confidence and skill to using the numbers and approaches in all aspects of life. In this, data is the
collection of facts such as numbers, observations and measurements for the description of things.
In means characteristics, using numerical, it is a set of values of qualitative and quantative
variables for one or more person (Angermeier. and Ansen, 2019). In IT, it refers to the
information related to the computing technology in the organization such as networking,
software and hardware. All of these have great role in the mathematics to find mean, medium
and standard and deviation in the regular life because numeracy help in maintain the numerical
value in the organization, data is also help in store the digits and information use in the
mathematics. In, Information technology means use of the software and hardware in the
computer to solve the problems of the mathematical problem.
MAIN BODY
QUESTION 1
Numerator- It means number is written in the form of a fraction, it is showing in the form
of a/b where A is the numerator a and b is the denominator. It represents the number of parts out
of the whole, is the denominator. It indicates the number of equal parts, it is the number which
show the parts of the item in the fraction. For example- 4/5 is a fraction and line separating the
number is 4 and 5 is the fraction is written like in the pizza having 6 slices. Shivam get 1 slice
the fraction is 1/6 in which 1 is the numerator in words, he gets 1/6 of the pizza. It is smaller than
denominator but all the time numerator is not less than denominator (Gatobu, Arocha and
Hoffman-Goetz, 2016). This type of fractions called improper fraction which is always large
than 1. There are many conditions are occurred-
 If numerator is 0 then the full fraction is zero, no issue of the denominator. For
example is 0.
 If the numerator is same with the denominator then the fraction of numerator and
denominator is 1. For example if the fraction is 22/22 then the value is 1.
Denominator- it is the bottom number in a fraction that shows the number of equal parts for
divide the item into fraction. Here is the divisor of the fraction, it is the multiple of all
1

denominators by set of fraction, trait and characteristic, belief common by all members of group.
It is the fraction 2/3 the numerator is 2 and denominator is 3. Like the example is the pizza slice
which has 6 slices the fraction is get ¾ in which 3 is the numerator and 4 is the denominator. The
line is horizontal or slanted means serve to separate the numerator and denominator (Karimi,
Mulwa and Kyalo,, 2020).
QUESTION 2
Covert the number into simplest forms
24/40 in simplest form
First of all simplifying the fractions find the HCF Of both number 24 and 40 is 8.
Divide both the numerator and denominator by 8
24/8/40/8
Reduced fraction to3/5.
Therefore, 24/40 simplified into lowest terms to 3/5.
18/42 into the lowest term
It means simplify the fraction to its simplest form. The below is the two methods used to convert
fraction into lowest terms, by using HCF method.
Prime factorization method
First address the formula and input parameters & values.
Given fraction- 18/42
Then find the HCF of 18 &42 is 6
Divide the numerator and denominator by 6 and then write the fraction
(18/6)/(42/6)
=3/7
2

Therefore 3/7, is the simplified factor of 18/42 by using HCF method
Equivalent fractions- It means simplify the fraction with different numerator sand denominator
but show the same proportion of whole. They have similar value and equal value but they are
looking different.
Question 3
(A)Expressing the fractions 2 / 3, 3 / 4 and 5 / 6 equivalent with a denominator of 12
Let there be two factor 3/4 ,2/3 and 5/6 with the same denominator 12.
=3*12/4*12 and 2*12/3*12 5*12/6*12
=9/12 =8/12 = 10/12
So, there is equivalent fraction is 9/12, 8/12,10/12
(b) Explain of the 2/3 of remaining
Total books in the library= 60,000
Books in business= 14000
Health cares books= 22000
Psychology and law= 12000
Books remain= 60000-(14000+22000+12000)
=12000
Computer books is 2/3 of the remaining= 2/3*12000=8000
Percentage of books on computing is 8000/60000*100= 13.3333%
QUESTION 4
Purchase of two pairs of running shoes
Three crisp 50 notes= 50*3= 150
3

Liz received 10.50 change
Amount of each pair, let suppose x
2x+10.50=150
2x+10.50=150
From these equation, calculate the value of x
X=69.75
QUESTION 5
What is the value of 240.50*19.54 in two significant figures
The value will be after 4700 in the significant figure.
Number of 52100 in the power of 10
52100 In the number
5.21*10^4
There is the power of the 10 is 4 times which provide the answers of the 52100 in the power.
Question 6
a. Total saving made by Patty and her siblings
Total payment done by Patty and her siblings = 210
As the payment is made the new gym make 30% discount so the actual payment which
was required to be made by them will be = 210 / 70 * 100
= 300
So the total savings made by all of them will be = 300 – 210
= 90
b. Average saving per person
Total payment which was made by three of them after discount = 210
Payment made by each and every person = 210 / 3
= 70
Total payment before giving the discount = 300
Payment for each person = 300 / 3
= 100
Therefore, Saving allotted per person = 100 – 70
4

= 30
Question 7
3 / 4 – 7 / 9 + 2 / 3
¾-7/9+2/3 (LCM (4,9,3= 36)
=(3*9,7*4,2*12)
=(27,28,24)/36
=27/36, 28/36, 24/36
=0.75,0.77,0.666
b. Largest number from all the values
The largest number from all the values is 0.10
QUESTION 8
The percentage of men that said no
Total number of men = 90
Total number of women = 60
Total people who watched movie = 150
People who said yes = 150 * 3 / 5
= 90
Women who said yes = 60 * 3 / 10
= 18
Total men who said yes = Total people who said yes – women who said yes
= 90 – 18
= 72
Total men who said no = 90 – 72
= 18
Percentage of men who said no = 18 / 90 * 100
= 20%
5

QUESTION 9
The latest time that Annabelle can leave home , if she wants to make it on time for the meeting in
Birmingham.
In this question , Annabelle leave the home at 8:05 am because if she leave at this time
she reach the railway station at 9:05 in only 60 minutes and she will also grab the train which is 5
minute late the hour. Apart from these train reached to Birmingham at 10:20. She wants 10
minutes to for the preparation of the meeting. When she leave the home after 8:05 then she will
easily catch the train that is 25 minutes late than the past hour (Kellems, Cacciatore, . and
Osborne, 2019).
QUESTION 10
Evaluation of the box which is heavier and which is not
In this question, the box which is heavier is of Wheetabix which have weight of 0.36kg
and the another box with the shredded have only weight of 0.35kg which is less heavier than the
another box.
QUESTION 11
A determine of the country which have lowest number of overall medals
The country name is Sweden which has lowest number of medals overall.
b. Determine the countries which has completed least number of games
China and Soviet Union are the two countries which completed the least number of
games.
c. Determine The mode in the number of games countries participated in this event
Mode in the number or the number which is happening again and again in the games in
which countries participated in is 23.3. it means repetition of the numbers The formula which is
used to calculate it is ΣX / N. X is the games and N is number of countries.
6

d. Determine the Range between the gold medals awarded to the 10 countries
The rage between the gold medals awarded in 10 countries is 875 because the maximum
gold medals that are earned is 1022 and minimum gold medals are 147 and the range is define as
the difference between both of them.
e. Name the countries that got more silver medals than bronze medals
Great Britain, Soviet Union and United Stats are those countries that have won more
silver medals than the bronze medals in the games.
f. Name the countries which got more gold, silver and bronze medals than Great Britain
The countries which have won more gold, silver and bronze medals than Great Britain
are Germany and Soviet Union in the world (Malloy‐Weir and Cooper, 2017).
g. Determine the country which performed best
By comparing all the top 10 countries for the Olympics it has been analysed that Soviet
Union is performed best because it has taken part in 10 games only and the total medals which
are received by it are 1122 which is very high. It shows that it is the best performing country
across the world in the study.
h. Explain the reasons due to which country like Jamaica does not feature in the top 10 medals
The reasons due to which Jamaica does not feature in the top 10 medals are as follows:
 This country takes less part in the sports.
 By analysing the countries that are featured in top 10 it is determined that these countries
are whether very large in size or larger part of EU. Jamaica is not featured in it because it
is neither large in size nor a part of European Union (Livock, 2016).
i. Determination of the medal category in which the US far outperformed its closest competitor
By analysing the list of top 10 countries in Olympics, it has been determined that in
Silver and Bronze medals United States performed very excellent in regard to its closest
competitor that is Soviet Union.
j. The three countries that has most evenly distributed number of gold, silver and bronze medal
By determine the top 10 list of the countries it has been analyzed that the countries that
has most evenly distributed in the number of gold, silver and bronze medals are Hungry,
Australia and Sweden.
7

QUESTION 12
Creating the excel including all rows and columns, identifiers, test formatting and column
highlighting
Olympic Games Medals Table (Top 10)
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
Hungry 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
a. Actions or steps in excel which could be taken to rank the figures from 1 to 10th
For giving ranks to the countries following steps are taken that are mentioned below:
Step 1: Apply the standard function to the data set in this form (RANK)
Step 2: Now the width that needs to be measured will now be selected. Example: [=
RANK (C2, C2: C11).
Step 3: Eventually all categories will be given all the figures for easy calculation in excel.
8

b. Specific actions or measures that will produce a list of countries with 800 or more medals in
total
To produce a list of 800 or more medal states some of the necessary steps are as follows:
Step 1: First, Select lines that need to be collected for less than 800 medals or more (Mamedova
and Pawlowski, 2020).
Step 2: After that the user will need to go to the data ribbon.
Step 3: After the group it is necessary to select a count.
Step 4: Eventually the top team will be re-elected from the full count.
c. Graphs will be ready to represent the details of the gold medals only
There are various types of graphs in the calculations that can be used to represent only the details
and knowledge of gold, silver and bronze medals. These are bars, columns and pies. All can
represent the details of the gold medals in an orderly fashion with countries .Examples of all of
them are as follows:
Bar graph:
Australia
China
France
Germany
Great Britain
Hungry
Italy
Soviet Union
Sweden
United States
0 200 400 600 800 1000 1200
147
227
212
275
263
175
206
440
147
1022
163
165
241
313
295
147
178
357
170
794
187
151
260
349
289
169
193
325
179
704
Bronze
Silver
Gold
Medals
Countries
9

1
2
3
4
5
6
7
8
9
10
0 100 200 300 400 500 600 700 800 900
Series1
SILVER
Column Graph:
Austral
ia China France Germa
ny Great
Britain Hungr
y Italy Soviet
Union Swede
n United
States
0
200
400
600
800
1000
1200
147
227 212 275 263
175 206
440
147
1022
Gold
10

1 2 3 4 5 6 7 8 9 10
0
100
200
300
400
500
600
700
800
900
Series1
SILVER
Pie graph:
11

147
227 212
275
263
175
206
440147
1022
Australia
China
France
Germany
Great
Britain
Hungry
Italy
Soviet
Union
Sweden
United
States
d. Column in which multiplication may be applied
By analyzing the international data set in relation to medals it was found that duplication was
used in the gold, Silver and Bronze medal column because in all the data purposes used by the
team or country were the same.
e. An excel formula that can be used to calculate total medals
The formula that can be used in excels to calculate the total number of medals is SUM or
Average. To use it is necessary for people to use the SUM or Measurement formula and select
the columns and rows where the number of medals in the countries is displayed. In the data set is
applied to the column with the full name. Here are some examples:
[= SUM (C3: X3)]
Using it, the total medals awarded to each country are calculated by selecting the lines on which
the data is written, The example above is from Australia (Spithourakis and Riedel, 2018).
12

QUESTION 14
a. Excel formula for calculating full medals for Germany and Great Britain
Germany's complete medal formula = [= SUM (C6: E6)]
Great Britain Medal Complete Formula = [= SUM (C7: E7)]
b. The formula for calculating the average value of silver medals in a European country
The formula for calculating the average silver medal in a European country
[= Rate (C5: E5, C6: E6, C9: E9)]
c. Excel formula for aggregating the total medals of those regions with less than 20 sports
involvement
The formula that can be used in the excel file is to calculate the total amount of gold countries
have won by playing games in the Olympics.
[= SUM (C4 + C10)]
d. Excel formula for searching the database for germany and the total number of medals
For a brilliant German find a formula that can be used. Like:
= GET (Get Text; text: position) (Strobl, 2019.)
QUESTION 15
a. The calculation of the average number of medals for each type of medal, refers to the formula
used to determine the medal of medals.
Medium calculation formula = n / 2
Median accounting details are required in the numerical increase so that the data available for all
types of medals are as follows:
S. No Countries Gold Countries Silver Countries Bronze
1 Australia 147 Hungry 147 China 151
2 Sweden 147 Australia 163 Hungry 169
3 Hungry 175 China 165 Sweden 179
4 Italy 206 Sweden 170 Australia 187
5 France 212 Italy 178 Italy 193
13

6 China 227 France 241 France 260
7 Great Britain 263 Great Britain 295 Great Britain 289
8 Germany 275 Germany 313 Soviet Union 325
9 Soviet Union 440 Soviet Union 357 Germany 349
10 United States 1022 United States 794 United States 704
Median = 10 / 2
= 5th value
Median for Gold will be 212 which is France. For Silver the median will be 178 which is
for Italy. The value of median for Bronze will be 193 which are for Italy (Yamashita, Bardo,
Millar and Liu, 2020).
b. Calculation of mean for the medals along with the formula which is used for the same
calculation
Formula = ΣX / N
The table with total of all the medals is as follows:
Team Gold Silver Bronze
Australia 147 163 187
China 227 165 151
France 212 241 260
Germany 275 313 349
Great Britain 263 295 289
Hungry 175 147 169
Italy 206 178 193
Soviet Union 440 357 325
Sweden 147 170 179
14

United States 1022 794 704
Total medals 3114 2823 2806
Mode for Gold medals = 3114 / 10
= 311.4
Mode for Silver medals = 2823 / 10
= 282.3
Mode for Bronze medal = 2806 / 10
= 280.6
c. calculation of standard deviation of total medals awarded to each country
Formula = √Σ (X - μ)2 / N
In order to calculate μ following table is generated:
Standard deviation for Gold medals:
Team Medal (x) X / μ (X / μ)2
Australia 147 -164.4 27027.36
China 227 -84.4 7123.36
France 212 -99.4 9880.36
Germany 275 -36.4 1324.96
Great Britain 263 -48.4 2342.56
Hungry 175 -136.4 18604.96
Italy 206 -105.4 11109.16
Soviet Union 440 128.6 16537.96
Sweden 147 -164.4 27027.36
United States 1022 710.6 504952.36
Total 0 625930.4
= √625930.4 / 10
= 791.185 / 10
= 79.1158
15

Standard deviation for Silver medal
Team Silver X – μ (X - μ)2
Australia 163 -119.3 14232.49
China 165 -117.3 13759.29
France 241 -41.3 1705.69
Germany 313 30.7 942.49
Great Britain 295 12.7 161.29
Hungry 147 -135.3 18306.09
Italy 178 -104.3 10878.49
Soviet Union 357 74.7 5580.09
Sweden 170 -112.3 12611.29
United States 794 511.7 261836.89
Total 0 340014.1
= √340014.1 / 10
= 583.107 / 10
= 58.3107
Standard deviation for Bronze medal:
Team Bronze X – μ (X - μ)2
Australia 187 -93.6 8760.96
China 151 -129.6 16796.16
France 260 -20.6 424.36
Germany 349 68.4 4678.56
Great Britain 289 8.4 70.56
Hungry 169 -111.6 12454.56
Italy 193 -87.6 7673.76
16

Soviet Union 325 44.4 1971.36
Sweden 179 -101.6 10322.56
United States 704 423.4 179267.56
Total 0 242420.4
= √242420.4 / 10
= 492.362 / 10
= 49.23
d. Usefulness of a standard deviation in the data set
According to ............., standard deviation is the measure of amount of and dispersion of
set of values. A low standard deviation leads to close to the mean of the sets.
QUESTION 16
a. Chart to compare fully labelled chart to compare gold, silver and bronze medal
17

b. Chart to reflect the contribution of each country to the overall medals total
497
543
713
937
847
491
577
1122
496
2520
Contribution of countries in total
medals Australia
China
France
Germany
Great Britain
Hungry
Italy
Soviet Union
Sweden
United States
CONCLUSION
From above report it has been concluded that numeracy, data and information technology
is that it is used in the regular activities in the mathematics tools and in statistics tools. While
planning to calculate ratio, pie chart and bar graph it is very important to use this for simple data.
18

REFERENCES
Books and journals
Angermeier, K. and Ansen, H., 2019. Value and understanding of numeracy practices in German
debt counselling from the perspective of professionals. ZDM, pp.1-12.
Gatobu, S.K., Arocha, J.F. and Hoffman-Goetz, L., 2016. Numeracy, health numeracy, and older
immigrants’ primary language: an observation-oriented exploration. Basic and Applied
Social Psychology, 38(4), pp.185-199.
Karimi, S.S., Mulwa, A.S. and Kyalo, D.N., 2020. Stakeholder engagement in monitoring and
evaluation and performance of literacy and numeracy educational programme in public
primary schools in nairobi county, kenya. Journal of Educational and Developmental
Psychology, 10(2), pp.1-10.
Kellems, R.O., Cacciatore, G. and Osborne, K., 2019. Using an augmented reality–based
teaching strategy to teach mathematics to secondary students with disabilities. Career
Development and Transition for Exceptional Individuals, 42(4), pp.253-258.
Livock, C., 2016. Walking the tightrope: Market drivers versus social responsibility with
implications for language, literacy and numeracy, and inclusive teaching. International
Journal of Training Research, 14(1), pp.35-48.
Malloy‐Weir, L. and Cooper, M., 2017. Health literacy, literacy, numeracy and nutrition label
understanding and use: a scoping review of the literature. Journal of Human Nutrition
and Dietetics, 30(3), pp.309-325.
Mamedova, S. and Pawlowski, E., 2020. Adult Numeracy in the United States. Data Point.
NCES 2020-025. National Center for Education Statistics.
Spithourakis, G.P. and Riedel, S., 2018. Numeracy for language models: Evaluating and
improving their ability to predict numbers. arXiv preprint arXiv:1805.08154.
Strobl, E.V., 2019. Improved causal discovery from longitudinal data using a mixture of
DAGs. arXiv preprint arXiv:1901.09475.
Yamashita, T., Bardo, A.R., Millar, R.J. and Liu, D., 2020. Numeracy and preventive health care
service utilization among middle-aged and older adults in the US. Clinical
gerontologist, 43(2), pp.221-232.
19