Data Analysis and Interpretation: DAT0001B Assignment

Desklib provides solved assignments and past papers to help students succeed.

DAT0001B
Using Numeracy, Data and IT

Contents
Assessment 1st Part.....................................................................................................................2
Section 1.................................................................................................................................2
1st Answer...............................................................................................................................2
2nd Answer..............................................................................................................................2
3rd Answer..............................................................................................................................3
4th Answer...............................................................................................................................4
5th (a) Answer.........................................................................................................................5
5th (b) Answer.........................................................................................................................5
6th (a) Answer.........................................................................................................................6
6th (b) Answer.........................................................................................................................6
7th (a) Answer.........................................................................................................................6
7th (b) Answer.........................................................................................................................6
8th Answer...............................................................................................................................7
9th Answer...............................................................................................................................7
10th Answer.............................................................................................................................7
Section 2.....................................................................................................................................9
11)..............................................................................................................................................9
a).............................................................................................................................................9
b)..........................................................................................................................................11
c)...........................................................................................................................................14
d)..........................................................................................................................................15
e)...........................................................................................................................................15
f)...........................................................................................................................................16
12)............................................................................................................................................17
a)...........................................................................................................................................17

b)..........................................................................................................................................17
c)...........................................................................................................................................18
d)..........................................................................................................................................19
e)...........................................................................................................................................20
Assessment Part 2....................................................................................................................22
a)...........................................................................................................................................22
b)..........................................................................................................................................23
c)...........................................................................................................................................24
d)..........................................................................................................................................27
List of Figures
Figure 1: Sort (a)......................................................................................................................11
Figure 2: Sort (b)......................................................................................................................12
Figure 3: Sort (c)......................................................................................................................12
Figure 4: Sort (d)......................................................................................................................12
Figure 5: Sort (e)......................................................................................................................13
Figure 6: Filter (a)....................................................................................................................14
Figure 7: Filter (b)....................................................................................................................15
Figure 8: Filter (c)....................................................................................................................15
Figure 9: Filter (d)....................................................................................................................16
Figure 10: Above Average.......................................................................................................16
Figure 11: Suitable Bar Graph.................................................................................................17
Figure 12: Replications............................................................................................................18
Figure 13: Number of Females................................................................................................19
Figure 14: Lower rate than £25................................................................................................20
Figure 15: Surname with letter ‘P’...........................................................................................21
Figure 16: Sum of Female Net Amount (a).............................................................................21
Figure 17: Sum of Female Net Amount (b).............................................................................22
Figure 18: Sum of Female Net Amount (c).............................................................................23
Figure 19: Graphical summary.................................................................................................25
Figure 20: Relationship between Food and Marital Status......................................................26

Figure 21: Relationship between Clothing and Marital Status................................................27
Figure 22: Relationship between Entertainment and Marital Status........................................28
Figure 23: Relationship between Charitable Giving and Marital Status..................................29
List of Tables
Table 1: Fractions.......................................................................................................................6
Table 2: LCM calculation........................................................................................................10

Assessment 1st Part
Section 1
1st Answer
In numerical form, the tally values written by:
5 + 3 – 4 or
= 8 – 4 or
= 4
Resultant value written as IIII.
2nd Answer
It may be done by making assumptions:
Step 1: assume the value 70 as 100% of the output value.
Step 2: Let the value will be x.
Step 3: By taking 1st step, 100% = 70
Step 4: Similarly, it written as x% = 49.
Step 5: Both equations written as:
70 = 100%
49 = x%
Step 6: Simplify both the equations by equating LHS or RHS.
(100/x) percent = 70/49
Step 7: Take reciprocal of LHS and RHS
(x/100) = 49/70.
By solving this: the value of x will be 7.

Therefore, it was written as the resultant is 70%.
3rd Answer
Step 1: 45% can be written in the form of 45/100.
Step 2: solve this form by dividing both the numbers from 5.
Step 3: Simplifications:
45
100 = 9
20
Step 4: The resultant make 9/20.
For fraction 2/3:
Step 1: For converting 2/3 in percentage. Multiply this number by 100.
Step 2: (2/3) *100 = 200/3
Step 3: Divide 200 by 3
200
3 =66.66
Step 5: Percentage form is 66%
For percentage 22.5% (Xiong, 2016)
Step 1: 22.5% written as 22.5/100.
Step 2: Solve this form by dividing both the numbers
Step 3: Simplifications:
22.5
100 = 9
40
And,
Step 4: The required value is 9/40.
For fraction 7/5:
Step 1: For converting 7/5 in percentage. Multiple this number by 100.

Step 2: (7/5) *100 = 700/5
Step 3: Divide 700 by 5
700
5 =140
Step 4: Percentage form is 14% carried out.
Table 1: Fractions
Fractions 9/20 2/3 9/40 7/5
Percentage 45% 66% 22.5% 14%
1: Total for cereal bars in carton = 150
Total number of students in class = 20
For finding the number of fractions, divide for cereal bars by number of students
150/20 or
= 7.5
The resultant for cereal bars = 7.5
4th Answer
Total number of purchased tickets = £3
Paid amount = £50
Change amount rupees = £4.20
Amount for purchasing = paid amount – change amount
= 50 – 4.20 or
= £45.8
Amount of each purchased tickets are = 45.8
3 or
= £15.26

5th (a) Answer
Step 1: The number 10011 also can be in base-10 form by
=19
Step 2: So,
100112 equal to 1910 with decimal base
Step 3: The number 10101be written for decimal form by
=21
Step 4: So,
101012 equals to 2110
Step 5: Now, submission of numbers is:
19 + 21 = 40
Step 6: This result can be written for binary form as
1010002 = 4010
5th (b) Answer
The value of o in power of 10 written as 0 only
The value 1 written as per by the location
So, the given number was written by:
10-2 + 10-4 = 10-6
The subsequent value as a power of 10 written by 10-6

6th (a) Answer
Discount rate is = 20%
Hair was done amount = 100
Let the value be x
Amount of total saving = 20%*x = 100
So, the value of x will be 125
6th (b) Answer
Average value for the saving is = submission of 4 hair done divide by 4
¿ ( 25+25+25+25 )
4 ∨¿
¿ 100
4
The average value is 25.
7th (a) Answer
Total gave numbers = 7
Formula for mean is submission of the values/total number of values
= (12+8+5+12+10+5+4)/7 or
= 56/7 or
=8
The mean for given seven numbers are 8 (Kane, 2016).
7th (b) Answer
The Mode can be defined as the frequently repeated value among given scenario or problem.
The frequently repeated number from this given scenario is 12

So, the mode is 12.
8th Answer
Number of candidates = 200
Total number of candidates with positive response = 3/5
Total number of male candidates with positive response = 9/10 or
Step 1: initiate with division of 200 by digit 5. Then, the division is
200/5 = 40 or
40 candidates enjoying the football match
Step 2: number of male candidates present in football watching is = 9/10
The value is 80/10 = 8 or
Step 3: as the football watching candidates are 40. Subtract out the number of candidates of
male from total candidates.
= 40-8 or
= 32
The number of female candidates is 32
9th Answer
Formula for mean value is = submission of all marks/total value of marks
= (14+15+16+17+18)/5 or
= 80/5
= 16
The student’s ratio who repeat test are 2 because their marks are below 16.
10th Answer
Step 1: find out the LCM for 5 or 9

Table 2: LCM calculation
5 5 9
3 1 9
3 1 3
1 1
The LCM for this calculation is 3*3*5 = 9*5 = 45 and
Step 2: Now, calculate ratio for 3/5
As already find the multiple of 5 for value 45 is 9. So, it written as = 5*9 = 45 and
So, 3/5 written as 3*9/5*9 = 27/45, now
Step 3: Now, calculate ratio for 5/9
As already find the multiple of 9 for value 45 is 5. So, it written as = 9*5 = 45 now
So, 5/9 written as
5*5/9*5 = 25/45, now
Step 4: Now, the denominator getting same. It can say that the number with big numerator
measured as the large fraction.
So, the fraction 3/5 is greater than 5/9 ans.

Section 2
11)
a)
Sorting the given sheet in the alphabetical order can be done using the Sort option. Sort
option is used to re-arrange all the available names in the ascending alphabetical order or
descending alphabetical order. For this, following process should be followed in the
spreadsheet.
First of all, for the sorting in alphabetical order, the column which should be sorted is
selected by the user. Here, the sheet should be arranged in the manner that the sorting can be
done in the First name column only. Therefore, First Name column is selected.
Figure 1: Sort (a)
After selecting the column, the user needs to access Data Tab so that they can see the Sort
option. This option is used to arrange all the First Name according to their particular
alphabetical order.