Numeracy, Data & IT: Solved Assignments and Essays - Desklib

This article discusses the importance of numeracy and data analysis skills in today's business climate. It includes solved assignments and essays on topics such as fractions, percentages, calculations, and Olympic games statistics. The content is relevant to subjects such as mathematics, statistics, and data analysis, and is suitable for college and university students.

Numeracy, Data & IT

Contents
INTRODUCTION...........................................................................................................................................4
MAIN BODY.................................................................................................................................................4
Question 1...............................................................................................................................................4
Question 2...............................................................................................................................................4
Question 3...............................................................................................................................................5
Question 4...............................................................................................................................................5
Question 5...............................................................................................................................................5
Question 6...............................................................................................................................................6
Question 7...............................................................................................................................................6
Question 8...............................................................................................................................................7
Question 9...............................................................................................................................................7
As a result, Annabelle can walk out of the house no later than 8:15 a.m................................................8
Question 10.............................................................................................................................................8
PART 2.........................................................................................................................................................8
Question 11.............................................................................................................................................8
PART 3.......................................................................................................................................................11
Question 12...........................................................................................................................................11
Question 13...........................................................................................................................................11
PART 3.......................................................................................................................................................13
Question 12...........................................................................................................................................13
Question 13...........................................................................................................................................14
Question 14...........................................................................................................................................15
Question 15...........................................................................................................................................17
Question 16...........................................................................................................................................19
REFERENCES..............................................................................................................................................21

INTRODUCTION
Numeracy is defined as the ability to reason and apply accurate mathematical principles.
Knowing fundamental mathematics such as arithmetic, reduction, division, and differentiating
are examples of simple numeracy abilities. Numeracy abilities have been extensively studied in
terms of their development and degenerative reversal, but it is unclear if they affect health
outcomes. Furthermore, it is yet unknown whether either mathematical aptitude may be
improved with age (Kass-Hanna, Lyons and Liu, 2021). Data analysis is the method for
inspecting, analyzing, transforming, and modeling data with the goal of uncovering useful
information, communicating results, and assisting judgment. Research process has many features
and methodologies, is known by a variety of names, and involves a variety of tactics. It is
utilized in a variety of commercial, academic, and social studies disciplines. In today’s rapidly
changing business climate, analysis of data entails gaining more information and assisting
organizations in performing more successfully.
MAIN BODY
Question 1
Numerator: The numerator is the quantity that happens in the top section of the fraction. A
fractional was nothing but a piece of all that has been mentioned thus far. As a result, the
numerator indicates the total number of equal pieces that would be multiplied.
Denominator: The denominator is the fraction's second component. They make it up often from
the bottom third of the percentage. It also corresponds to the quantity of two pieces that the total
can be divided into. Let's look at that other 12 fraction instance. 12 denote that two similar
sections of a given picture are considered in this case (Thomas and Jones, 2021).
In a fraction, the denominator represents the number of equal pieces, while the numerator
represents the number of sections. As p / q is the numerator of a complete entity that is divided
into q segments with same dimensions, the denominator is p pieces in a fraction.
Question 2
24/40 = 0.6

18/42 = 0.43 (approx.)
Question 3
(a) Express the fractions 2/3, 3//4 and 5/6 as equivalent fractions with a denominator of 12
2/3 = 2*4/3*4 = 8/12
3/4 = 3*3/4*3 = 9/12
5/6 = 5*2/ 6*2 = 10/12
(b) Percentage of library books on computing
Remainder book = 60,000 – 14,000 – 22,000 – 12,000
= 12,000
Computing books = 12,000 × 2
3
= 8,000
Percentage of books on computing = 8,000
60,000 ×100
= 13.33%
Question 4
Total money given by Liz = £50 × 3 = £150
Total price of 2 pairs of shoes = £150 - £10.50
= £139.50
Price of each pair of shoes = £139.50/2
= £69.75 per pair
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
Discount rate = 30%
No of people = 3
Total amount paid = £210
Amount paid for one person = £210/3 = 70
Percentage of amount paid = 70%
Total amount paid for sign up = £210
Total discount received = £210 × 30
100
= £63
Hence, the total savings made = £63
(b) Average savings per person = £63 / 3 (Patty and her 2 siblings)
= £21 per person
Question 7
a) 3/4 - 7/9 + 2/3
Applying BODMAS = 17/12 – 7/9
= 237/108

b) The largest number from the series 0.1 because 0.1 has significant decimal digit, one digit to
the right of the decimal point. 0.1 has two particular decimal digits thus 0.1 is presented with the
number of zero and become 0.10 that provides it two decimal digits same as other following
numbers of 0.02, 0.003 and others (Agasisti, Johnes and Paccagnella, 2021).
0.1
Question 8
Total number of people said yes = (90 + 60) × 3
5
= 90
Total number of women said yes = 60 × 3
10
= 18
Total number of man said yes = 90 – 18
= 72
Number of man said no = 90 -72 = 18
Percentage of the men said no = 18
90 × 100
= 20%
Question 9
Here, reverse calculation method will be adopted:
-Annabelle is a Londoner who resides in Bermondsey.
-She is scheduled to speak at 10:30 a.m. in Birmingham.
-Getting from her residence to Euston Station, where she takes the train to Birmingham, will
takes her an hour (1 hour).
-The train ride from Euston Station to Birmingham takes one hour and ten minutes (7/6 hours).

- The meeting location station in Birmingham is a 5-minute (1/6-hour) walk away.
As a result, Annabelle's total travel time from her home to the meeting location is = 1 hr + 7/6 hr
+ 1/12 hr = 27/12 hr = 2 hours 15 minutes.
To determine the time, divide the entire time required to arrive to the meeting site by the planned
time: (10 hours 30 minutes) – (2 hours 15 minutes) = 8 hours 15 minutes.
Despite the fact that the train from Euston to Birmingham arrives at 5 minutes after the hour, 25
minutes after the hour, and 45 minutes after the hour.
As a result, Annabelle can walk out of the house no later than 8:15 a.m.
Question 10
Converting both values in simple form = 9/25
= 0.36Kg
Therefore, 0.36 Kg or 9/25 Kg is heavier than 0.35Kg of Shredded Wheat.
PART 2
Question 11
a) Hungary
b) China and Soviet Union
c) 27 is the mode in the number of games countries participated in
d) Minimum = 147; Maximum = 1,022
Range = Maximum – Minimum
= 1,022 – 147
= 875
e) 4 countries
f) Germany, United States and Soviet Union

g)
Country
Total
Games
Total
medals
Medals per
game
Australia 26 497 19.11538462
China 10 543 54.3
France 28 713 25.46428571
Germany 24 937 39.04166667
Great Britain 28 847 30.25
Hungary 26 491 18.88461538
Italy 27 577 21.37037037
Soviet Union 10 1122 112.2
Sweden 27 494 18.2962963
United States 27 2520 93.33333333
Thus, 93.33 medals per game were won by the United States, which is the highest of all nations.
Firstly, the largest number of trophies won per game is in the United States.
h) Causes include the following:
1. In total Olympic games, Jamaica has struggled to score little if any gold medal; because of that
which was not included in the top 10 rankings.
2. Athletes from Jamaica have indeed actively participated in one sprinting event (Buhl-Wiggers,
Jones and Thornton, 2021).
(i)
Country Gold
United States 1,022
Soviet Union 440
582
Country Silver

United States 794
Soviet Union 357
437
Country
Bronz
e
United States 704
Soviet Union 325
379
Gold (582) is the overall disparity between award classes with its nearest rival; thus, Gold is the
division whereby the nearest rival has far outpaced the United States.
(j) Sweden and Australia have less gold medals = 147
Hungry and Australia have less silver medals = 147 & 163
China and Hungry have less Bronze medals = 151 & 179
Team Gold Silver Bronze Range
Hungary 175 147 169 28
Italy 206 178 193 28
Great Britain 263 295 289 32
Sweden 147 170 179 32
Australia 147 163 187 40
France 212 241 260 48
Germany 275 313 349 74
China 227 165 151 76
Soviet Union 440 357 325 115
United States 1022 794 704 228

From the above table present the total medals of each country with the range of smallest
numbers.
PART 3
Question 12
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 494
United states 27 1022 794 704 2520
Question 13
(a) Based on the information supplied, Hungary has the fewest total medals as among ten
countries, with 491 medals.
(b) China and the Soviet Union, with ten games each, are the nations that participated in the
fewest tournaments.
(c) The average number of games in which countries played is 28. (France and Great Britain)
(d) The difference in gold medals between the ten countries is = 1022 – 147 = 875.
(e) China, the United Kingdom, the Soviet Union, and the United States are the four nations with
far more silver medals than bronze medals.
(f) Germany and the Soviet Union, aside from the United States, have more gold medals, silver
medals, and bronze medals than just the United Kingdom (Pensiero, Kelly and Bokhove, 2021).
(g) The largest amount of trophies gained in each match must be established in order to evaluate
which country did best. However, given the data presented in table below, this may be calculated
by dividing the total amount of wins won by the amount of games every country has participated.

Country
Total
Games
Total
medals
Medals per
game
Australia 26 497 19.11538462
China 10 543 54.3
France 28 713 25.46428571
Germany 24 937 39.04166667
Great Britain 28 847 30.25
Hungary 26 491 18.88461538
Italy 27 577 21.37037037
Soviet Union 10 1122 112.2
Sweden 27 494 18.2962963
United States 27 2520 93.33333333
As a result, the United States won 93.33 medals per match, the most of any country. To begin
with, the United States has the most major trophies per game.
h) The below are some of the reasons:
1. In total Olympic Games, Jamaica has managed to score few, if any, gold medals; as a result, it
is not ranked among the top ten countries.
2. Jamaican athletes have competed in at least one running competition.
(i)
Country Gold
United States 1,022
Soviet Union 440
582
Country Silver
United States 794
Soviet Union 357

437
Country
Bronz
e
United States 704
Soviet Union 325
379
Gold (582) is the overall disparity between award classes with its nearest rival; thus, Gold is the
division whereby the nearest rival has far outpaced the United States.
(j) Sweden and Australia have less gold medals = 147
Hungry and Australia have less silver medals = 147 & 163
China and Hungry have less Bronze medals = 151 & 179
Team Gold Silver Bronze Range
Hungary 175 147 169 28
Italy 206 178 193 28
Great Britain 263 295 289 32
Sweden 147 170 179 32
Australia 147 163 187 40
France 212 241 260 48
Germany 275 313 349 74
China 227 165 151 76
Soviet Union 440 357 325 115
United States 1022 794 704 228
From the above table present the total medals of each country with the range of smallest
numbers.
PART 3
Question 12
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 494
United states 27 1022 794 704 2520
Question 13
(a). The processes or tasks to conduct in addition to determining the nation’s overall medals from
1st to 10th are described following, based on the preceding tables.
(b) The operation was to enter the expression “=rank(G3,G3:G12), and the outcome is shown in
the diagram beneath-

(c) Stacked bar chart is the style of graph which will be adequate or acceptable in portraying just
gold medals.
(d) The "Team" and "Total" sections are the ones which should be reproduced.
(e) The total number of medals received could be determined utilizing the calculation
“SUM(G3:G12)” in Excel, as shown in the image beneath-
Question 14
a. The total number of medals for Germany and Great Britain is being clacualted with help
of function sum. For sum of Germany =Sum (C66:E66) and for Great Britain (C67:E67)
Team
Total
Games Gold Silver Bronze Total
German
y 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
is the function of average.
Teams
Silver
medal
s
France 241
German
y 313
Hungar
y 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
calculated with help of function of sum.
Team
Total
Games Gold
China 10 227
Soviet
Union 10 440
667
d. For searching the database in order to find “Italy” and the corresponding medals total the
function of VLOOKUP will be used (Grebitus and Davis, 2019). The VLOOKUP is used
in order to find a certain value within the column.
Team
Total
Game
s Gold Silver
Bronz
e 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
263 295 289 847

Britain
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
correspondi
ng medal
total 577
Question 15
a. The formula for calculating median for every type of medal is =MEDIAN (range). Hence
with help of the median the division of the value is being highlighted.
gold 219.5
silver 209.5
bronze 226.5
b. For three types of medals, the method of calculating the mean is =MEAN (data range). With
the assistance of the mean value, it was observed that the average medals achieved by nations are
as follows in various categories.
gold 311.4

silver 282.3
bronze 280.6
c.
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.74
b. The standard deviation is a highly important tool for calculating and evaluating data dispersal.
When the standard deviation is low, it shows that the model is extremely near to the mean.
Whereas if deviation is considerable, however, it means that the dispersion inside the outcome is
quite wide.
Question 16
(a) There are using column chart to present the total gold, silver and Bronze medal that earned by
the 10 countries in Olympic Game.
Australia
China
France
Germany
Great Britain
Hungrary
Italy
Soviet Union
Swedon
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
Total games
Gold
Silver
Bronze
(b) Colum chart: A graph that shows comparable variability intervals or the comparative size,
length, quality, or strength of a number of individuals by means of contrasted relative column

Australia
China
France
Germany
Great Britain
Hungrary
Italy
Soviet Union
Swedon
United states
0
500
1000
1500
2000
2500
3000
497 543 713 937 847
491 577
1122
494
2520
Total
Total
In this chart represents of the total medals of 10 countries that earned by players in Olympic
Games after participation.

REFERENCES
Books and Journal
Kass-Hanna, J., Lyons, A. C. and Liu, F., 2021. Building financial resilience through financial
and digital literacy in South Asia and Sub-Saharan Africa. Emerging Markets Review,
p.100846.
Thomas, A. and Jones, C., 2021. Exploring young children’s levels of involvement with
numeracy and literacy–do schemas make a difference?. Education 3-13, 49(2), pp.217-
226.
Buhl-Wiggers, J., Jones, S. and Thornton, R., 2021. Boys lagging behind: Unpacking gender
differences in academic achievement across East Africa. International Journal of
Educational Development, 83, p.102382.
Agasisti, T., Johnes, G. and Paccagnella, M., 2021. Tasks, occupations and wages in OECD
countries. International Labour Review, 160(1), pp.85-112.
Edwards-Kerr, D. and Spencer-Ernandez, J., 2021. Using Social and Emotional Instructional
Activities to Indigenise Early Childhood Education in a Post-colonial Society.
In Reconceptualizing Quality in Early Childhood Education, Care and Development (pp.
181-201). Palgrave Macmillan, Cham.
Yisma, E., Mol, B.W., Lynch, J.W., Mittinty, M.N. and Smithers, L.G., 2021. Associations
between Apgar scores and children’s educational outcomes at eight years of
age. Australian and New Zealand Journal of Obstetrics and Gynaecology, 61(1), pp.35-
41.
Beatty, A., Berkhout, E., Bima, L., Pradhan, M. and Suryadarma, D., 2021. Schooling progress,
learning reversal: Indonesia’s learning profiles between 2000 and 2014. International
Journal of Educational Development, 85, p.102436.
Pensiero, N., Kelly, A. and Bokhove, C., 2021. Learning inequalities during the Covid-19
pandemic. A longitudinal analysis using the UK Understanding Society 2020 and 2021
data.
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.
Roberts, P., Thier, M. and Beach, P., 2021. Erasing rurality: On the need to disaggregate
statistical data. In Ruraling Education Research (pp. 107-127). Springer, Singapore.
Lin, S., Williamson, F., Beetson, J., Bartlett, B., Boughton, B. and Taylor, R., 2021. Quantifying
low English literacy in Australian Aboriginal communities: a correlational study. The
Australian Educational Researcher, 48(2), pp.267-280.

Wintle, B., Mody, F., Smith, E., Hanea, A., Wilkinson, D.P., Hemming, V., Bush, M., Fraser, H.,
Thorn, F.S., McBride, M. and Gould, E., 2021. Predicting and reasoning about
replicability using structured groups.
Umbaram, U., Wahyudin, W. and Prabawanto, S., 2021. How to Predict Good Days in Farming:
Ethnomathematics Study with an Ethnomodelling Approach. Journal of Research and
Advances in Mathematics Education, 6(1), pp.71-85.