Solved: Numeracy, Data, and IT Assignment - Detailed Answers

This assignment solution covers various aspects of numeracy, data analysis, and IT concepts. It includes detailed explanations for problems related to fractions, percentages, and data interpretation. The solution demonstrates how to simplify fractions, calculate percentages in real-world scenarios, and perform data analysis tasks such as finding modes, ranges, and comparing data sets. The assignment also addresses practical problems involving time management and basic arithmetic calculations. Furthermore, it involves interpreting data from a medal table to identify countries with the lowest number of medals, countries competing in the least number of games, and analyzing medal distributions. Desklib provides this solved assignment and many other resources to aid students in their studies.

NUMERACY, DATA AND IT

TABLE OF CONTENT
PART 1............................................................................................................................................3
Question 1....................................................................................................................................3
Question 2....................................................................................................................................4
Question 3....................................................................................................................................4
Question 4....................................................................................................................................6
Question 5....................................................................................................................................6
Question 6....................................................................................................................................6
Question 7....................................................................................................................................8
Question 8....................................................................................................................................8
Question 9....................................................................................................................................9
Question 10..................................................................................................................................9
PART 2..........................................................................................................................................10
Question 11................................................................................................................................10
PART 3..........................................................................................................................................12
Question 12................................................................................................................................12
Question 13................................................................................................................................13
Question 14................................................................................................................................14
Question 15................................................................................................................................15
Question 16................................................................................................................................17
REFERENCES..............................................................................................................................20

PART 1
Question 1
Numerator:
Numerator term define as a number which is above the fraction line and it signifies that
the number is divided by the other number which is below the line (Mendez-Carbajo, Jefferson
and Stierholz, 2019). The numerator part can be termed as the dividend.
For an example: 24/4 = 6 Answer
Here it shows that the 24 is numerator which is above the fraction line called as a dividend.
Denominator:
Denominator term define as a number which present below the fraction line and it shows
as the divisor to the numerator. Denominator number can be shown as a divisor.
For an example: 40/10 = 4 solution

This example shows that the 10 is the denominator which is below to the fraction line and can be
named as a divisor.
Question 2
The Simplest form: It defines as the numerator and denominator can be termed as in the
simplest form when the number are prime number. Prime numbers are those number which are
only divide by one or either by itself. As they do not consist of the common factor rather than
one (1) number which is allowed (Russo, 2019).
Step 1 Suggested steps to simplify the 24/40 are as follows.
Here, first to identify the HCF of the numr 24/40
The highest common factor of 24/40 is 8 which come from
2×2×2×3=24
2×2×2×5=40
so the common HCF factor will be 2×2×2=8
Now for the simplest form next step will be to divide both the numerator and denominator by the
HCF number which is 8
24÷8 / 40÷8
24 divides by 8 gives the outcome=3
40 divides by 8 gives the result=5
Therefore, the simplest form of the 24/40 is 3/5
So, the final outcome is 3/5
Step 2 The simplest form for the number 18/42 is as follows
First to find the highest common factor of the 18/42
HCF is as follow 2×3×3= 18
2×3×7=42
so the HCF factor of the 18/42 is 6
now divide both the numerator and denominator by the HCF factor which is 6
18÷ 6 / 42÷ 6
the number 18 divide by 6 gives the result= 3
number 42 divide by the 6 number gives the outcome as=7
so, the possible simplest form of the 18/42 is 3/7

Question 3
A)
Step 1To show the fraction 2/3, multiply the both numerator and denominator by 4
That is 2×4 / 3×4=8/12
To know the reason cross multiplication is the better option as 2×12=24 and 3×8= 24
Therefore, the fraction 2/3 is equivalent to 8/12
Step 2 fractions 3/4 multiply its dividend and divisor by the number 3 so the result will be
3×3 / 4×3= 9/12
by cross multiplying 3×12=36 and 4×9=36
so the fraction 3/4 is equivalent to 9/12
Step 3 fraction 5/6, multiply the denominator and numerator by 2
5×2 / 6×2= 10/12
Cross multiplication result will be 5×12=60 and 6×10=60
so the fraction 5/6 is equivalent to 10/12
hence the fractions 2/3, 3/4, 5/6 are equivalent to 10/12, 9/12, 8/12.
B)
given is that the library has the books (Russo, 2019) around 60,000
the number of books are on the subject business is 14,000
total number of books are based on the healthcare is 22,000
and the books are based on the psychology and law is 12,000
as to find the percentage of the computing books are (Woolcott and et.al 2019).
add all the books that is ( business+ healthcare +psychology and law)
(14,000+ 22,000
+12,000)= 48,000
subtract the 48000 from the total book present in the library that is 60,000
60,000- 48000= 12000
final remainder is 12000
So, the computing book is 2/3 of the remainder (Wallace and et.al 2019).
hence the computing book are=2/3 ×12000

final result is 8000
finally the percentage of the computing book are= 8000/60000 ×100= 13.33 hence solved
Question 4
As Liz gives the sales attendant a note of £50 to purchase the pair of running shoes
therefore she takes the change of £10.50
the price for each pair of the running shoes is to subtract the change money from the total money
that is 50- 10.50= 39.50
the number of shoes are=2
divide the 39.50 by 2 to get the result
39.50/2 =19.75
so the price of each pair of shoes is 19.75 answer
Question 5
A)
the multiplication of the number 240.50 x 19.54 =4699.37
b)
the number 52100 as a power of 10 is equal to
5.21×10
Question 6
A)
As the gym is offering about 30% discount it means they have paid the 70%
which is by that the total percentage is 100 so 100-30=70
it means they have already paid 705 out of 100%
to identify the total saving (Litkowski and et.al 2020). we want to find that total cost without
promo and eliminate it from the payment mode of 70%
payment mode 70%=£210
1% would be=210/70=£3
so point is if the 1% is £3 then the 100% of this will be £300
and the gym offer of 100% is equal to £300

so the final total saving which is made= total number of the cost offered by gym- 70% of the
payment mode
that is £300-£210= £90
so the final saving made is £90 answer.
b)
the average saving per person define as
the total amount is =210
and the saving is =30%
hence the total saving mode= saving * amount
30%*210
=63
average saving would be =total saving divide by the number of person involved which is 3
so 63/3=21
so the final average saving by every person is 21 answer

Question 7
a)
the solution for the
3/4 - 7/9 + 2/3
3/4=0.75
7/9=0.77
2/3=0.66
therefore 0.75-0.77+0.66= 0.64 final answer
b)
the largest of the following numbers
0.1, 0.02, 0.003, 0.0004, 0.00005
0.1 is the largest in all the number second largest is 0.02 so the following order will be
0.1>0.02>0.003> 0.0004> 0.00005
Question 8
Total number of the men are=90
Total number of the women are=60
so the total number of the people would be =addition of women or men
that is 90+60
=150
the data of the people who have said yes that have watched the ‘Expendables’ movie =3/5
so 3/5 of total is 3/5*150= 90
total number of women who said yes=3/10 that is the total women
3/10*60=18
and the total number of men who said yes= the total number of people who said yes that they
have watched the movie-total number of women who said yes
=90-18

=72
the percentage of the men who said no = total number of the men who said yes is subtracted by
the total number of men
=90-72
=18
so the final percentage which the men said no is 18/90*100
=20%
Question 9
As the Birmingham conference start from 10.30am time. So Annabelle have to leave her house
at the 8:00 AM as because to reach at the Euston rail station it required an 1 hour so that she will
reach at the station at the time of 9:00 AM. The Birmingham train depart at 5 minute after an
hour, it takes 25 minute in the hour and 45 minutes in the hour (Patterson and Xu, 2020). Which
analyse that she will board at the train around 9:05 AM. And she will reach to the Birmingham
station at 10:15AM after 1:10 minutes on the train from the Euston station. She will reach to the
Birmingham meeting conference at time 10:20 AM because the Birmingham station is only 5
minute walk away from meeting place. She will reach the conference before the scheduled time
of the meeting, to give the time for preparation of the meeting. To chase the mark of 10 minutes
and that she lives at 8:30 Am she will reach to the station at time of 9:10 AM based on the
schedule of the train then she board at the train on 9:25 AM time which suggests that she will
late for the meeting by the 10 minutes of time (Grebitus and Davis, 2019).
Question 10
The box of the shredded wheat weigh=0.35 kg
and the box of the Weetabix weighs =9/25 kg
therefore the weetabix box is heavier by the 0.001 kg
weetabix box 9/25=0.36 kg
so that the weetabix box is 0.36 kg and the shredded wheat weigh is 0.35 kg
therefore the weetabix box is heavy by 0.001 kg than the shredded wheat box.

PART 2
Question 11
A)
the country which have the lowest number of the medals among all the countries is Hungary they
have only 491 medals which is they have played total 26 games in which they get the 175 gold
medals, 147 silver medals, 169 bronze medals (Mutaf-Yıldız and et.al 2020).
so the total number of medals are=175+147+169
=491 medals
B)
the country which have competed in the least number of games are two country which is China
and the Soviet union (Piper and et.al 2018). Both countries have played only 10 games each.
C)
Mode define as the number which occur more often therefore in the game. Therefore the number
of games in which the countries have been participated is 27
D)
the range of the gold medals awarded to the 10 countries is 147- 1022
China, Great Britain, Soviet Union and United State. China gold medal=227
Great Britain gold medal=263
Soviet Union gold medal=440
United State gold medal=1022
E)
the countries which have got the more silver medals than the bronze medals are-
china, Great Britain, Soviet union and United state
China country won 165 silver and 151 bronze medal which is 14 more silver medal
Great Britain country won 295 silver and 289 bronze medal which is 6 silver medal
Soviet union country won 357 silver and 325 bronze medal which is 32 silver medal
United state country won 794 silver and 704 bronze medal which is 90 silver medal
F)
the countries who have got more gold, silver and bronze medal than the Great Britain are
Germany and the Soviet union

Germany gold medal=275, silver medal=313, bronze medal=349
Soviet union gold medal=440, silver medal=357, bronze medal=325 and the medals of the Great
Britain are gold medal=263, silver medal=295, bronze medal=289 which is lower than the both
Soviet Union and the Germany country.
G)
United states play a good game they have won maximum medals in their game as the country
played the total number of game which is 27 as compared to the Sweden and Italy both country
also played 27 games but US won the maximum gold, silver and the Bronze medal
the total number of medal country won in every game is 2,520
total number of gold medal are= 1,022
total number of gold medal are= 794
total number of gold medal are= 704
this ratio is maximum hence US country won the medals which is comparatively more than
every country's medal.
H)
After performing well in their games still Jamaica country does not register their position in the
top 10 because of lack of training among the players. Players of the team does nit get the proper
training and coaching it reflects in their game (Kalogeropoulos and et.al 2019). Also, because of
this they do not able to maintain their coordination. So lack of the coordination also affects the
game of their player so the player loose their concentration in the game and not able to win the
maximum medals for the country. Another reason would be the physical fitness issue among the
players as some players are fit and some were injured it affects their game. Therefore, these are
the two reason which stops the Jamaica country to make position in the top 10.
I)
United state score the maximum in their game therefore they have won more medals than the
other countries but the Soviet union country also did better in their game they also got good
range of gold, silver and bronze medal.
US medal range is 1022 gold medal, 794 silver medal, 704 bronze medal total medals are 2,520
and the total medal won by the Soviet union country is 1122 in which the gold medal=440
silver medal=357
Bronze medal=325

J)
the three countries which have the most evenly distributed number of golds, silver and the
Bronze medals are Australia, Hungary, Sweden country
Australia gold medal=147 , silver medal=163 bronze medal=187 total medal=497
Hungary gold medal=175 , silver medal=147 bronze medal=169 total medal=491
Sweden gold medal=147 , silver medal=170 bronze medal=179 total medal=496
PART 3
Question 12

Question 13
A)
the actions or steps are to be taken to rank the function are-
Number- it is the necessary element which is required for the Rank
Ref- it can be a list of array or reference
order- this define as in which order does the Ranking system is arranged whether ascending or
descending order
therefore for arranging the Countries according to their medal this excel formula has been used
to sort the Ranking data formula is RANK(C2,$C$2:$C$7).
B)
first to highlight the row by clicking the F key, then go to the toolbar which is at the top under
the DATA click option, it will direct the user which is able to see the arrow which is near to the
F now click on the drop-down option on the arrow and applying sorting (Hwang, 2020).
Illustration 2: spreadsheet which contains the countries performance

List will be updated. Therefore the four countries arrange in the order who have medals more
than 800 the countries are Germany have 937, Great Britain have 847, Soviet Union have 1122
and the United state have 2520 total medals.
C)
Histogram Graph this graph is used to summarize the continuous data therefore the Histogram is
beneficial to show the Gold medal information.
D)
Ctrl+ T key can be use for the replication process
user use this key at the total number of medal row so the whole formula is applied on rest of the
total number of medal for each country.
E)
excel summation formula can be used to calculate the total number of medals.
Question 14
A)
The total number of the medal for the Germany and the Great Britain country are as follows-
the total number of the medal won by Germany country is 937
in which they have won total gold medal 275, total silver medal won by the country is 313 and
the bronze medal is 349.
Great Britain won the total medal 847 in which they have won the gold medal which is 263 the
silver medal they have won is 295 and the bronze medal is 289. Hence Germany country has
won more medals than the Great Britain country.
B)
The average number of the silver medals won by the European country
the European country are France, Italy, Germany, Great Britain, Sweden and Hungary
the silver medal won by the country France is 241, Italy is 178, Germany is 313, Great Britain is
295, Sweden is 170 and Hungary is 147
total number of silver medal are=241+178+313+295+ 170+147
= 1344
the average silver medal won by the European country is =total number of silver medal won by
countries divided by the total silver medal
=1344/10 (as the total range of the silver medal is 10)

=134.4
so the average silver medals won by the European country is 134.4
C)
The gold medal won by the country who have played less than 10 games the country name is
China and the Soviet Union who have only played the 10 games the total gold medal won by
both the country is- China gold medal=227
soviet Union gold medal=440
the total gold medals would be 227+440=667
667 medal won by the both countries and they have only played leas games than other countries.
D)
The position of the Italy country in the spreadsheet is at the number 9 country has played the
total number of 27 games. Country have won total 577 medals in their games.
The total number of the gold medal won by the Italy is=206
The total number of the silver medal won by the Italy is=178
The total number of the Bronze medal won by the Italy is=193
so, the total number of medals are= 206+178+193
=577 medals
Question 15
A)
Team Total Game Gold medal Silver medal Bronze medal Total medal
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
the median for the gold medal is 219.5
the formula is used to find the median is used by the spreadshit which is selecting the blank
space the formula is=MEDIAN(A1:C10)
B)
therefore the mean for the gold medal and the silver medals are as follows the formula used for
the mean is =AVERAGE(E2:E11)
the mean for the gold medal is 311.4

the mean for the silver medal is 282.3
the mean for the bronze medal is calculated as by clicking on the blank space below to the
bronze medal than applying the formula =AVERAGE(E2:E11) and the outcome will be come
which is 280.6
C)
the standard deviation formula is used for result the formula is σ=√1N∑Ni=1(Xi−μ)2 σ = 1 N ∑ i
= 1 N ( X i − μ ) 2 the following answer for the spreadsheet is 585.739712
D)
spreadsheet is a simple excel sheet which is mainly used to manipulate the data. it is used for the
sorting and so on. the standard deviation formula is used is =SQRT(H29)
Question 16

the graph will show the total medal won by each country. it is helpful to analyse as each country
medal. graphical representation is beneficial which describe as which country have won the
maximum gold, silver and the bronze medal.
B)
Team Total Game Gold medal Silver medal Bronze
medal
Total medal Contribution
of each
country
Australia 26 147 163 187 497 0.05
China 10 227 165 151 543 0.06
France 28 212 241 260 713 0.08
Illustration 1: graph shows the medal

Germany 24 275 313 349 937 0.1
Great
Britain
28 263 295 289 847 0.09
Hungary 26 175 147 169 491 0.05
Italy 27 206 178 193 577 0.06
Soviet
Union
10 440 357 325 1122 0.12
Sweden 27 147 170 179 496 0.05
United
states
27 1022 794 704 2520 0.28
Total medal is 8743 so the total contribution made by the country is listed above
in the table therefore the total number of the contribution made by all the ten country is 0.94
(Peters. and et.al 2019).

REFERENCES
Books and Journals
Grebitus, C. and Davis, G.C., 2019. Does the new nutrition facts panel help compensate for low
numeracy skills? An eye‐tracking analysis. Agricultural economics 50(3). pp.249-258.
Hwang, S., 2020. Examining the effect of students’ early numeracy activities at home on later
mathematics achievement via early numeracy competencies and self-efficacy
beliefs. International Electronic Journal of Elementary Education, 13(1), pp.47-56.
Kalogeropoulos, P. and et.al 2019. Re-enfranchising mathematically-alienated students: Teacher
and tutor perceptions of the Getting Ready in Numeracy (GRIN) program. International
Electronic Journal of Mathematics Education. 15(1). p.em0545.
Litkowski, E.C. and et.al 2020. When do preschoolers learn specific mathematics skills?
Mapping the development of early numeracy knowledge. Journal of experimental child
psychology. 195. p.104846.
Mendez-Carbajo, D., Jefferson, C.O. and Stierholz, K.L., 2019. Keeping It Real: Information
Literacy, Numeracy, and Economic Data. Numeracy: Advancing Education in Quantitative
Literacy. 12(2).
Mutaf-Yıldız, B. and et.al 2020. Probing the Relationship Between Home Numeracy and
Children's Mathematical Skills: A Systematic Review. Frontiers in Psychology. 11.
Patterson, L. and Xu, Y., 2020, April. Enhancing Teachers' Competence in Building Students'
Numeracy in Grades K-3. In Frontiers in Education (Vol. 5, p. 31). Frontiers.
Peters, E. and et.al 2019. Despite high objective numeracy, lower numeric confidence relates to
worse financial and medical outcomes. Proceedings of the National Academy of
Sciences, 116(39), pp.19386-19391.
Piper, B. and et.al 2018. Identifying the essential ingredients to literacy and numeracy
improvement: Teacher professional development and coaching, student textbooks, and
structured teachers’ guides. World Development. 106. pp.324-336.
Russo, J.A., 2019. The Impact of a Short Test-Wiseness Intervention on Standardised Numeracy
Assessment Scores: A Cautionary Tale about Using NAPLAN Growth Data to Evaluate
Primary Schools. Networks: An Online Journal for Teacher Research. 21(2). p.5.
Russo, J.A., 2019. The Impact of a Short Test-Wiseness Intervention on Standardised Numeracy
Assessment Scores: A Cautionary Tale about Using NAPLAN Growth Data to Evaluate
Primary Schools. Networks: An Online Journal for Teacher Research. 21(2). p.5.
Wallace, E. and et.al 2019. Do nlp models know numbers? probing numeracy in
embeddings. arXiv preprint arXiv:1909.07940.
Woolcott, G. and et.al 2019. Academic Numeracy and First Year Undergraduate Studies across
Six Regional Universities. Mathematics Education Research Group of Australasia.