Numeracy, Data and IT Application

Numeracy, Data and IT Application 1
Numeracy, Data and IT Application
Presented by;
Student:
Professor:
Institution:
Course:
Date:

Numeracy, Data and IT Application 2
Numeracy, Data and IT Application
Part 1 Assessment
Section1
1.
= ||||
2.
If 70 equals to 100 %, what about 49?
To solve this problem, we proceed as follows;
70 = 100 %
49 = Y
To solve for Y, Y = 100/70 * 49 = 70 %
Y = 70 %, which represents 49
3.
a.)
Fraction Calculation of the
percentage
Percentage (%)
9/20 9/20 * 100 % 45
2/3 2/3 * 100 % 66.7
9/40 9/40 * 100 % 22.5
7/5 7/5 * 100 % 140
Table 1: A Schedule Showing Fraction and Percentage
b.)
To solve this problem, we proceed as follows;

Numeracy, Data and IT Application 3
150/20 which is equals to = 15/2 = 7.5
4.
The technique that is used to compute for the price of each ticket is shown below;
Notes:
The number of notes = 3
The tickets available = 3
X = £ 4.20
Thus; £ 50*3*3 = £ 450 - £ 4.20 = £ 445.8
The price of three tickets = £ 445.8
The next step is to find the price of each ticket. This is done as follows;
If 1 ticket Y = £ 445.8, what about 1 ticket?
1/3 * £ 445.8 = £148.6
5.
a)
Calculation of binary numbers 2’s complement (Chattopadhyay and Gayen 2016, p.6)
The answer is given by: 10011
+ 10101
01000
b.)
0.0101 = 101 * (10 – 4)
6.
a.)
If 100%= 100

Numeracy, Data and IT Application 4
Y = 80 %
Then, Y = £80 describes the discount which Janice and her friends paid.
In one day, the amount earned by the salon = £80
Therefore, in two weeks which is equals to 14 days, the total amount earned by the salon is
calculated as follows;
Amount earned in 14 days = £80 * 14 = £1120
b.)
For 4 hairdo is calculated as;
1120 *4= £ 4480
7.
a.)
Mean is described as the average figure for a particular set of data. It is computed by adding all
the figures then dividing the sum by the number of observations.
In this data set, the mean can be computed as follows;
Sum of the observations = 5+12 +12+8+ 4+ 10+ 5=56
Number of observations = 7
Mean = 56/7 = 8
Mean = 8
b.)
Mode of a set of data refers to the figure which is repeated the most (Brar, Malik and Kaur 2017,
pp.525-533 ).
In this data set, the mode is 12 since this figure appears two times. There is no other figure which
is repeated.

Numeracy, Data and IT Application 5
8.
The sum of individuals = 120 + 80 = 200
Number of individuals who said yes = 3/5 * 200 = 120
Sum of men who said yes = Men (yes) = 9/10 * 80 = 72
As a result, the number of women who said yes = Women (yes) = 120 – 72 = 48
In fraction form = Women (yes) = 48/120 = 2/5
9.
Mark Frequency
14 2
15 5
16 4
17 4
18 5
Total 20
Table 2: Table showing marks and frequencies
Mean is computed as follows;
Mean = Sum of observations / Number of observations
Sum of observations = (14*2) + (15*5) + (16*4) + (17*4) + (18*5) =325
Number of observations = 2+5+4+4+5 = 20
Mean = 325/20 = 16.25
As a result, students who scored 14 and 15 marks will have to retake the assessment.
10.
The larger fraction is 5/9.

Numeracy, Data and IT Application 6
Section 2.
11.
a.)
The measures to be undertaken so as to organize the identified spreadsheet is the ascending
arrangement of the first names ( Olkin and Workday 2019, p.141). This is done by clicking on
column A3, and then clicking on sort at the toolbar where A to Z is selected.
b.)
The formula used to display individuals who operated less than 35 hours in the course of the
week is given as FILTER (F4: F18, F4>=35,' ‘).
c.)
The sum of persons who earn more than the mean income equals to 9
d.)
The figure that is appropriate to display the net income is a bar chart because it is clear and easy
to draw.
e.)
Replication is used in column H
f.)
SUM (H4: H18) is the formula used in cell H20
12.
The required functions are given as follows;
a.
Women sum =COUNT IF (C4: C18, "=F")
b.