Data Analysis and Interpretation: A Statistical Approach

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

Table of Contents
Assessment 1.........................................................................................................................................2
Section 1............................................................................................................................................2
Question 1.........................................................................................................................................2
Question 2.........................................................................................................................................3
Question 3.........................................................................................................................................3
Question 4.........................................................................................................................................5
Question 5.........................................................................................................................................5
Question 6.........................................................................................................................................6
Question 7.........................................................................................................................................7
Question 8.........................................................................................................................................8
Question 9.........................................................................................................................................8
Question 10.......................................................................................................................................9
Section 2..............................................................................................................................................11
a) Sorting Spread-sheet in alphabetical order.................................................................................11
b) Command to display particular number......................................................................................12
c) Average Amount..........................................................................................................................13
d) Suitable graph for Net Amount...................................................................................................13
e) Replication in column..................................................................................................................14
f) Formula in H20.............................................................................................................................14
12) Function and commands...........................................................................................................15
a) Number of Females.....................................................................................................................15
b) Records on rate < £25..................................................................................................................15
c) Number of Surname with letter ‘P’ in them.................................................................................16
d) Sum of females earned more than £495.....................................................................................17
e) Search for ‘Messi’........................................................................................................................17
Assessment 2.......................................................................................................................................19
c) Scatter diagrams..........................................................................................................................19
d) Probability...................................................................................................................................21
References:..........................................................................................................................................22
1

Tables & Figures
Table 1: Fraction & Percentage.............................................................................................................4
Table 2: Fraction & Percentage.............................................................................................................5
Table 3: LCM........................................................................................................................................10
Figure 1: Sorting..................................................................................................................................13
Figure 2: Filtering.................................................................................................................................14
Figure 3: Average Net amount.............................................................................................................14
Figure 4: Pie chart for Net Amount......................................................................................................15
Figure 5: Replicaitons..........................................................................................................................16
Figure 6: Female Number....................................................................................................................17
Figure 7: less than 25 rate...................................................................................................................18
Figure 8: Surnames with 'P'.................................................................................................................19
Figure 9: Word 'Messi' and its Deduction............................................................................................20
Figure 10: Food Graph.........................................................................................................................22
Figure 11: Clothing Graph....................................................................................................................23
Figure 12: Entertainment Graph..........................................................................................................23
Figure 13: Charitable Giving Graph......................................................................................................24
Figure 14: Food Scatter Diagram.........................................................................................................24
Figure 15: Clothing Scatter Diagram....................................................................................................25
Figure 16: Entertainment Scatter Diagram..........................................................................................25
Figure 17: : Charitable Giving Scatter Diagram....................................................................................26
2

Assessment 1
Section 1
Question 1
What is the result of the following calculation? Leave your answer in a tally format.
I I I I I I I – I I I I
Answer 1: As these numbers are in the roman form
So, in numeral form they can be written as:
5 + 3 – 4 = 8 – 4
4
The result for this format is 4
Or
In roman form, it can be written as IV.
3

Question 2
What percentage of 70 does 49 equate to?
Answer 2:
Step 1: divide the number 49 by 70. So, we get
49/70 = 0.7
Step 2: take a percentage of 0.7. it can be written as
0.7*100/100
Or
0.7*100%
So, it can be written as
(0.7*100%) = 70%
The resultant percentage is 70%.
Question 3
a). Complete the table to show equivalent fractions and percentages.
Table 1: Fraction & Percentage
Answer a).
Step 1: fraction of 45% is
4
Fraction Percentage
45%
2/3
22.5%
7/5

Multiply 45 with 1/100
The resultant fraction is 9/20.
Step 2: Percentage of 2/3 is
Division of 2/3 is 0.666666……
For convert into percentage, multiple it with 100%
The resultant percentage is 66.66%.
Step 3: Fraction of 22.5% is
Multiply 22.5 with 1/100
The resultant fraction is 9/40.
Step 4: percentage of 7/5 is
Division of 7/5 is 1.4
For convert it into percentage, multiply it with 100%
The resultant percentage is 14%.
Table 2: Fraction & Percentage
Fraction Percentage
9/20 45%
2/3 66.66%
9/40 22.5%
7/5 14%
1).
5

A carton contains 150 cereal bars. What fraction of this number will each person get
when distributed to a class of 20 students?
Answer 1). Number of cereal bars = 150
No. of students = 20
Number of bars each person gets = 150/20
= 7 ½.
The numbers of bars distributed in students in fraction form = 7 ½.
Question 4
Samuel paid cash for 3 discount-priced football tickets. He was given £4.20 change from
the three £50 notes he tendered. What was the price of each ticket? Show your working.
Answer: Number of tickets purchased = 3
Amount paid = £50
Received change = £4.20
Total purchasing cost = £50 - £4.20
= £45.8
Cost of each tickets = £45.8/3
= £15.26
Question 5
a)
Solve this binary arithmetic: 10011 +10101
Answer 5 (a):
Step 1: convert both the binary numbers in the decimal form
6

Step 2: 10011 can be written in decimal from as:
100112 = 1910
Step 3: 10101 can be written in decimal from as:
101012 = 2110
Step 4: Add both the decimal numbers:
21 + 19 = 40
Step 5: Convert the resultant value in binary form
4010 = 1010002
b)
Write the number 0.0101 as a power of 10.
Answer 2: 0 is represent as the 0 only and
The value of 1 is depend on the location and it can be written as:
10-2 + 10-4
The resultant value is 10-6.
Question 6
As a promotional offer, a new hair salon offered its services at 20% discount for the
first 2 weeks. Janice and her friends took advantage of the bargain and had their hair
done for a total amount of £100. Show your working.
a) What were the total savings made?
Answer:
Answer: Rate of discount = 20%
Total amount of hair done = 100
7

Assume the value will be x
So,
Total savings = x*20% = 100
X = 125
b) Work out the average savings amount if 4 hairdos were done?
Answer:
Answer: Average saving =
25+25+25+25
4
¿ 100
4
Average Saving=25
Question 7
Here are seven numbers.
5 12 12 8 4 10 5
a) Work out the mean of the seven numbers.
Answer: Mean can be calculated by formula as:
Mean = submission of all the numbers / total number
= (5 + 12 + 12 + 8 +4 +10 +5) / 7
= 56/7
= 8
b) What is the mode of the seven numbers?
Answer: Mode is the number of elements occurring more times.
8

Mode = 12
Question 8
80 men and 120 women were asked if they enjoyed watching football.
Altogether 3 / 5 of the people said yes.
9 / 10 of the men said yes.
What fraction of the women said yes?
Answer: Total number pf persons = 200
Number of people said yes = 3/5
Number of men said yes = 9/10
Step 1: Divide 200 by 5. So, 200/5 = 40.
So, overall 40 persons enjoyed watching football.
Step 2: Total 80 men are present in which 9/10 said yes for watching football.
So, divide 80 by 10 80/10 = 8
Step 3: We find out that total 40 people enjoying football in which 8 are men.
So, number of women’s = 40-8 32.
Question 9
The table shows information about the marks of 20 students in a test.
Mark Frequency
14 2
15 5
16 4
17 4
18 5
Total = 20
9

Students who scored less than the mean mark have to retake the test. How many
students have to retake the test? You must show your working.
Answer: Mean = submission of the total quantities/total number of quantities
= (14+15+16+17+18)/5
= 80/5
=16
As the mean is 16. The number of students who got less than 16 marks are only 2.
So, the number of students is two who retake the exams.
Question 10
Which fraction is bigger - 3/5 or 5/9?
Answer 10: steps included are
Step 1: Initiate with finding the LCM (least common multiple) of both the denominators
Table 3: LCM
So, the LCM is 3*3*5 = 45
Step 2: find the ratio for the first fraction
As 5*9 = 45
So, 3/5 = 3*9/5*9 = 27/45
Step 3: find the ratio for the second fraction
As 9*5 = 45
So, 5/9 = 5*5/9*5 = 25/45
10
5 5 9
3 1 9
3 1 3
1 1

Step 4: the denominators of both the fraction become same. So, the numerator having the
greater value is considered as the big fraction. It means: 27/45 > 25/45.
So, it can be said that
3/5 > 5/9.
11

Section 2
a) Sorting Spread-sheet in alphabetical order.
Step 1: Select the Column of First Name in the given spread-sheet which has to be sorted in
alphabetical and ascending or A to Z order.
Step 2: Go to the menu bar and select the Data Tab.
Step 3: In the Sort & Filter column, there’s an option of Sort. Select that option for the next
step.
Step 4: A dialogue box will open titled, Sort Warning. This box will provide two option,
 Expand the Selection
 Continue with the current Selection.
Opt for Expand the Selection option and click on ‘Sort…’ button
Step 5: Another dialogue box will appear titled ‘Sort’.
Step 5 (1): Here, in the column section, select Sort by First Name.
Step 5 (2): In the Sort on Section select ‘Values’.
Step 5 (3): In the Order Section, select A to Z.
Step 6: Click on OK to confirm the selections.
Sorting is done.
12