Numeracy, Data, and IT Skills: Comprehensive Data Analysis Homework

This document presents a complete solution to an assignment focusing on numeracy, data analysis, and IT skills. It covers a wide range of topics, including fractions, percentages, and data interpretation, with detailed explanations and calculations. The assignment involves solving problems related to fractions, simplifying expressions, and calculating percentages. It also delves into data analysis, including statistical measures such as mean and standard deviation. Furthermore, the solution demonstrates the use of IT tools, specifically Excel, to organize, analyze, and visualize data, including creating formulas, ranking data, and generating charts. The assignment also explores real-world scenarios and applications of these concepts, such as calculating savings, analyzing survey results, and interpreting medal data from international events.

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