Data, Numeracy and ICT Assignment

USING NUMERACY, DATA
AND IT

EXECUTIVE SUMMARY
This assignment is based on understanding the fundamentals in relation to the numeracy
of data. It has shed light on solving the mathematical calculations along with use of spreadsheet.
Moreover, this comprises of several varieties of questions in context to topics such as percentage,
discounts, mean, mode and more. Lastly, it contains solutions to have a comprehension to know
the significance of statistical data in practical manner.

CONTENTS
EXECUTIVE SUMMARY.............................................................................................................2
PART 1-SECTION-1.......................................................................................................................5
Question 1....................................................................................................................................5
Question 2....................................................................................................................................5
Question 3....................................................................................................................................5
Question 4 ...................................................................................................................................6
Question 5 ...................................................................................................................................6
Question 6....................................................................................................................................7
Question 7 Here are seven numbers.............................................................................................7
Question 8....................................................................................................................................8
Question 9 ...................................................................................................................................9
Question 10 Which fraction is bigger - 2/3 or 3/5?.....................................................................9
PART 1 - SECTION 2...................................................................................................................10
Question 1..................................................................................................................................10
Question 2..................................................................................................................................12
PART 2 .........................................................................................................................................13
A. Role of descriptive statistics in success of motion pictures .................................................13
B. Graphical Summaries............................................................................................................15
C. High performance outliers ....................................................................................................21
D. Relation between total gross sale and each of the other variable .........................................22
E. Scatter diagram reflecting relation between total and opening weekend gross sales ...........23

PART 1-SECTION-1
Question 1.
Solution:
Given data: To find IIII IIII II - IIII + IIII
IIII IIII I is the answer in the tally format.
Question 2.
Solution: x% of 60 = 42
x/100 * 60 = 42
x = 42 * 100/ 60
x = 70
Answer. 70 percentage of 60 equates to 42
Question 3.
FRACTION PERCENTAGE
A 35
02/05 B
C 12.5
03/02 D
Solution: In the above table, to determine the values of A, B, C and D
Value of A= 35/100 = 7/20
Value of B = 2/5 * 100 = 40
Value of C = 12.5/100 = 1/8
Value of D = 3/2 * 100 = 150

A carton contains 200 chocolate bars. What fraction of this number will each person get when
distributed to 25 Arden University students?
Solution: Total number of students = 25
Total number of chocolate bars = 200
Required fraction that each person gets= x/y
Therefore, x/y * 200 = 25
x/y = 25/200
x/y = 1/8
Answer. The fraction is 1/8
Question 4
Solution: Total cash JJ deposited = £50
Total number of tickets bought = 6
Remaining amount JJ received back = £5.60
Money Spent in buying tickets = £ (50 – 5.60) = £44.4
Price of each ticket = Money spent in buying tickets/Total number of tickets
= 44.40/6
= £7.4
Question 5
a) 10101 – 110
Solution:
10101 – 110 = 11001
Answer: The difference between 10101 and 110 is 11001
b)
Solution: 0.0001= 1/10000= 1/ (104) = 10-4
Answer: 0.0001 is written as a power of 1010-4