Numeracy, Data & IT: Mathematical Applications and Data Interpretation

This assignment solution focuses on Numeracy, Data & IT, addressing various mathematical concepts and their practical applications. It begins by defining numerators and denominators, followed by simplifying fractions and determining equivalent fractions. The solution also tackles percentage-based problems, such as calculating discounts and analyzing data related to books in a library. Furthermore, it involves solving arithmetic problems, including multiplication with significant figures and power of 10 representations. The assignment explores real-world scenarios like calculating the price of running shoes, determining savings, and comparing weights. It also covers operations with fractions and identifying the largest number in a set. Additionally, the solution analyzes data related to Olympic medals, determining modes, ranges, and comparing the performance of different countries. Finally, it addresses time management problems and provides detailed explanations for each step, ensuring a comprehensive understanding of the concepts involved. Desklib offers a wide range of similar solved assignments and past papers to aid students in their studies.

Numeracy, Data &IT

Contents
INTRODUCTION...........................................................................................................................3
PART-1.............................................................................................................................................3
PART-2.............................................................................................................................................8
PART-3...........................................................................................................................................10
REFERENCES..............................................................................................................................17

INTRODUCTION
Numeracy is the methodology for simplifying the concepts, factors and other given
information in numbering world. It included the fundamental & comprehensive operations of
arithmetic criteria such as addition, subtraction, multiplication and division. It consists of
knowledge, skills & other conduct of nature that to be needed in wide range of mathematical
operations and tactics (Coetzee and Matthee, 2021). In this particular reporting, gathering of all
the fractions value with different activities occurrence and data & excel based questions is to be
solved. By covering all the numeracy aspect, we can create value with the usage of different
functionality.
PART-1
Question 1: Define the terms (a) numerator, (b) denominator.
Solution:
A. Numerator: When the numbers are given in the form of (a/b) then the 'a' value is
known as numerator. The number which placed at above the fraction bar is represented as
numerators of the fraction value which shown the partial parts of the whole amount.
For example: There are 5 chocolates in a box. 1 chocolate is given to one boy. That
means the fraction of boy is (1 / 5) where 1 is the numerator. In other words, he will get one-fifth
of the chocolates.
B. Denominator: When the numbers are given in the form of (a/b) then the 'b' value is
known as denominator. The number which placed at below the fraction bar is represented as
denominators of the fraction value which shows the whole amount (Del Río, and et.al., 2017).
For example: There are 5 chocolates in a box. So 5 is the whole part of the 1/5 fraction
value.
Question 2: Identify simplest forms of 24/40 and 18/42.
Solution: Steps of calculating simple factors:
1. Find out the HCF factor of the numerator and denominator.
2. Divide both the segments by common value.
3. It reduces the value from highest to lowest.

Calculation:
I. 24 / 40:
a. Highest Common factor of 24 / 40 is 8.
b. 24 / 8 = 3 & 40 / 8 = 5.
c. Reduced Fraction = 3 / 5.
Therefore, 24 / 40 simplified form is 3 / 5.
II. 18 / 42:
a. Highest Common factor of 18 / 42 is 6.
b. 18 / 6 = 3 & 42 / 6 = 7.
c. Reduced Fraction = 3 / 7.
Therefore, 18 / 42 simplified form is 3 / 7.
Question 3:
A. Determine the fractions of 2/3, 3/4 and 5/6 as equal value with a denominator of 12.
Solution: Multiply both numerator & denominator by the same number which will turn the value
of denominator into 12 like below:
1. 2 / 3: 2*4 / 3*4 = 8 / 12.
2. 3 / 4: 3*3 / 4*3 = 9 / 12.
3. 5 / 6: 5*2 / 6*2 = 10 / 12.
Therefore, the equivalent fraction of the 2/3, 3/4 and 5/6 is 8/12, 9/12 and 10/12.
B. A library contains 60,000 books. 14,000 are of business subject, 22,000 are of healthcare and
12,000 on psychology & law. What percentage of the library’s books is on computing, if
computing books is two-thirds of the remainder?
Solution:
Total Number of books in library = 60000
1. Business subject books = 14000
2. Healthcare subject = 22000
3. Psychology & Law = 12000

Total of these three subjects are 48000 (14000+22000+12000)
→ Remaining books = 60000 – 48000 = 12000
→ Computing books = 2 /3 of remaining
= 2/3 * 12000 = 8000
→ % of Computing Books = [8000 / 60000 *100] = 13.33 %.
Therefore, % of Computing Books in the library = 13.33 %.
Question 4: A sports shop in Manchester is doing a sale on some merchandise. Liz hears about it
and goes to make a purchase of two pairs of running shoes. She gives the sales attendant in the
store three crisp £50 notes and is given change of £10.50. What is the price of each pair of
running shoes? Calculate the following.
Solution: Let's assume pair of shoes = x
Liz gives the amount = 3 * £50 = £150
Change return = £10.50
→ Price of 2 pair of shoes: 2x + 10.50 = 150
→ 2x = 150 – 10.50
→ 2x = 139.50
→ x = 139.50 / 2 = £69.75
Therefore, price of each pair of running shoes = £69.75
Question 5:
A. What is 240.50 * 19.54? Answer in 2 significant figures.
Solution: From the above scenario, the numbering consists of 4 decimal values which can be
written as 240.50 * 19.54 = 4699.3700 But,
240.50 * 19.54 = 4699.37 ( Consider only 2 significant values)
B. Write the number 52100 as a power of 10.
Solution: It is known as scientific quotations which is comprehensive in nature at the smallest
decimal number value.
The number 52100 as power 10 is = 5.21 * 10^4

Question 6:
A. New gym is offering a promotional offer of 30% discount to those who sign up in the first
month. Patty and her 2 siblings take advantage of the offer and sign up for total amount of £210.
What were the total savings made?
Solution: Total discounting offer = 30 %
Patty & her 2 siblings take advantage of offer = 100 – 30 % = 70%
→ Sign up amount of joining = £210
If the £210 value is equal to 70% then total saving amount is:
→ £210 / 70 * 30 = £90.
Total Savings made by them = £90.
B. Explain the average savings per person.
Solution:
Total number of people = 3
Saving done by per person = £90 / 3 = £30.
The Average savings per person = £30.
Question 7: Determine the following:
A. 3/4 - 7/9 + 2/3
Solution:
→ 3 /4 – 7 /9 + 2 / 3
→ Taken LCM of 4, 9 and 3 which is 36.
→ Value converting = [(27 – 28 + 24) / 36]
→ [( -1 + 24) / 36] = 23 / 36
3 /4 – 7 /9 + 2 / 3 = 23 / 36.
B. Which is the largest of the following numbers: (0.1, 0.02, 0.003, 0.0004, 0.00005)
Solution:
In this, we need to use the place value for measure the bigger value among these numbers.
Largest Number = 0.1

Question 8: 90 men and 60 women were asked if they had watched the latest ‘Expendables’ B-
movie. Altogether 3/5 of the people said Yes. 3/10 of the women said Yes. What percentage of
the men said No? Explain.
Solution:
Total number of Men = 90
Total number of Women = 60
Total Person = 90+60=150
→ Total People Said 'Yes': 150 * 3 / 5 = 90
→ Total Women Said 'Yes': 60 * 3 / 10 = 18
→ Total Men Said 'Yes': people said 'Yes' – Women said 'Yes'
: 90 – 18 = 72
→ Total Number of Men Said 'No': 90 – 72 = 18
→ % of Men said 'No' = 18 / 90 *100 = 20%.
Men said 'No' percentage = 20 %.
Question 9: Annabelle lives at Bermondsey in London. She has to speak at a conference in
Birmingham at 10.30am. It will take her an hour from her home to get to Euston Rail Station,
from where she will get a train to Birmingham. The train journey from Euston to Birmingham is
an hour and 10 minutes. Trains to Birmingham run at the following times: 5 minutes past the
hour, 25 minutes past the hour and 45 minutes past the hour. The meeting venue in Birmingham
is a 5-minute walk from the station. What is the latest time that Annabelle can leave home, if she
is to make it on time for the meeting in Birmingham? Explain.
Solution:
The conference meeting timing at Birmingham is at 10.30 AM.
She has to leave her house at 8.00 AM. Because →
1. She will reach at Euston Rail Station at 9.00 AM.
2. After 5 minutes at 9.05 AM, she will get the train as per the railway timings. (as per 5
minutes past the hour)
3. After getting train from Euston rail station, the journey will be of 1 hour 10 minutes,
basically she will reach at Birmingham station at 10.15 AM.

4. She will reach at the conference venue in Birmingham at 10.20 AM because of 5 minutes
walking distance from the main station.
5. She will reach at the meeting venue 10 minutes earlier which will be allowing her to get
ready for the speak session.
Note: If she leaves from her place after 5 or 10 minutes, she will definitely late for the
conference meeting because the train timings are scheduled already which is after 20 minutes at
9.25 AM. By this decision, she will be late for the session.
Conclusion : She must be leave her house at 8.00 AM.
Question 10: A box of Shredded Wheat weighs 0.35 kg and a box of Weetabix weighs 9/25 kg?
Which box is heavier? Explain.
Solution:
A box of Shredded Wheat weighs = 0.35 Kg.
A box of Weetabix weighs = 9 /25 = 0.36 Kg.
Heavier Box is = 0.36 Kg of Weetabix weighs.
PART-2
Question 11:
A. Which country had the lowest number of overall medals among the ten countries?
Solution: Hungary had the least number of total medals.
B. Which country/countries competed in the least number of games?
Solution: China & Soviet Union competed in less number of games.
C. What is the mode in the number of games countries participated in?
Solution: Mode = 27.
D. What is the range between the gold medals awarded to the 10 countries?
Solution: Range = Maximum – Minimum = 1022 – 147 = 875.

E. How many countries got more silver medals than bronze medals?
Solution: 4 countries such as China, Great Britain, Soviet Union & United States got more
silver medals than bronze medals.
F. Apart from the United States, which country/countries got more gold medals, more silver
medals and more bronze medals than Great Britain?
Solution: Germany & Soviet Union Countries got more gold, silver and bronze medals than
Great Britain.
G. In comparing the number of games a country participated in and the overall number medals
received, which country did the best (i.e. highest number of medals received per game)? Show
your working to justify your answer.
Solution:
1. France & Great Britain had played 28 total games and received 713 & 847 medals.
2. Italy, Sweden & United States had played 27 total games and received 577, 496 & 2520
medals in total.
→ Therefore, it can be concluded that United States country did the best in Olympics by
receiving 2520 Medals in percentage of 93.3333 per game.
H. Using the given data, give TWO likely reasons why a country like Jamaica does not feature in
the top 10 medals even though it does very well in athletics.
Solution:
→ Reasons for not featuring Jamaica in top 10 medal list:
1. In Olympics Games, there were so many games to be played such as 28 or more. And
Jamaica does extreme well in athletics only. In top 10 listing, there are sum up of overall
medal gaining ratio, not according to one game.
2. Jamaica is a small country which has a population of 2.85 Million people only, which
also generates least chances of winning because from Jamaica country less number of
people can be participated in the Olympics with few entrants in particular games.

I. Using the given information, determine the medal category in which the United States far
outperformed its closest competitor. Show the working to justify answer.
Solution: With the given information, we can clearly see that United states biggest competitors
in Olympics is Soviet Union in gold & silver medals but for bronze medal, the Germany has
closest to America.
Gold Silver Bronze
United States 1022 794 704
Soviet Union 440 357 325
Germany 275 313 349
The Highlighted points shown the nearest competitors of the United States in medal category
wise.
J. Which 3 countries had the most evenly distributed number of gold, silver and bronze medals
(i.e. least small range)? Show your working.
Solution: Least amount of range specific below:
Gold Silver Bronze
Country Medals Country Medals Country Medals
Australia 147 Australia 163 China 151
Sweden 147 China 165 Hungary 169
Hungary 175 Hungary 147 Sweden 179
→ Therefore, the most evenly distributed medals number of least range of Gold are in between
Australia & Sweden, Silver are in between Australia & Hungary and Bronze being in between
China & Hungary.
PART-3
Question 12: Make the spreadsheet using Excel. Include the rows and columns identifiers, text
formatting and column highlighting as shown.

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
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
Total Number of Medals
Awarded 8743
Average Number of Medals 874.3
Question 13:
A. Actions or steps taken in excel to rank them from 1st to 10th
Solution: To calculate the following ranking order from 1-10, we need to follow some steps: -
1. Use the formula: [=Rank (F3, $F$3: $F$12)]
2. Drag the drop down list.
3. It created rank values according to order of descending to ascending.
B. State the specific action(s) or step(s) in Excel that will produce a list/display of those
countries with 800 or more medals in total?
Solution: Some of the following steps are as follows:
1. Select the total medal column ‘F’.
2. Click on the Data tool at toolbar window and use ‘filter’ option.
3. Click on drop down arrow and filtering the data by selecting only more than 800
data and OK.
4. The data is being filtered as four countries Germany, Great Britain, Soviet Union
and United States had received medals over 800.
Olympic Games Medals Table (Top 10)
Germany 24 275 313 349 937
Great Britain 28 263 295 289 847
Soviet Union 10 440 357 325 1122

United States 27 1022 794 704 2520
C. Which type of graph will be suitable for representing only gold medals information?
Solution: As Gold medal column show the vertical order of the data, so the ‘Column Graph’ is
suitable for the given information.
Gold
0
200
400
600
800
1000
1200
147 227 212 275 263
175 206
440
147
1022
D. In which column might replication have been used?
Solution: The replicate function has used for the purpose of creating duplicate data in the similar
file. A 'Team' and 'Total' column is being used by replication.
E. What Excel formula can be used to calculate the overall total medals awarded?
Solution: For calculating the overall total medals awarded, the formula is being used are as
follows:
Formula: [=SUM (F3:F12)]
Question 14:
Using Excel Functions:
A. Give the total number of medals for Germany and Great Britain.
Solution:
1. By using SUM formula, make the total of both the countries.
2. Formula: [=SUM (F6:F7)] which is equal to (937+847 = 1784)
3. Total Number of medals for Germany & Great Britain is 1784.