Numeracy, Data and IT Assignment

This assignment focuses on numeracy and data analysis, covering topics like percentages, discounts, mean, mode, and more. It includes a case study on the success of motion pictures, analyzing the relationship between various variables and using graphical summaries to interpret data.

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

Question 6
a)
Solution: Given data, 15 percent has been given as discount.
Let cost for 100 % without discount be X
So, after getting discount of 15 %, that is 85 % cost is £48
Thus, Total savings = 48/ (85 %) = 48*100/85 = £56.47
Answer: The total savings amounted is £53.64
b)
Solution: Given, number of meals = 6
Let us assume that Ola and her friends visited the restaurant be 2 times in 2 weeks.
Thus, Average = Total amount spent/ Total number
= [(48*2) + (56.47*4)] /6
= (96 + 225.88) / 6
= £53.64
Answer: The average savings amounted is £53.64
Question 7 Here are seven numbers.
12 5 12 10 4 5 8
a) Work out the mean of the seven numbers.
Solution: To find mean of seven numbers= Sum of all numbers/ Total number
= (12+5+12+10+4+5+8)/7
= 56/ 7
= 8
b) What is the mode of the seven numbers?
Solution: Mode is defined as a particular number that occurs most frequently in a given set.
Thus, for given set, X= {12,5,12,10,4,5,8}

In this given set, there are more than one terms that occurs frequently.
Terms 4 5 8 10 12
Occurrence of
terms in given
set
1 2 1 1 2
Henceforth, the mode is 5 and 12.
Question 8
Solution: Given data-
Number of men = 40 = x
Number of women = 60 = y
Total number of people= Number of men + Number of women
= (40+60) = 100
Also given, 3/5 of people said yes. Thus, X can be taken as number of people who said Yes.
So, X = 3/5 * 100
X = 60
Another given statement is as follows: 9/10 of Men said Yes;
Let number of men who said yes be 'a'. So, 9/10 of Men = 9/10 * x = a
Let number of women who said yes be 'b'. So, Fraction of Women = b
Hence, X = a + b
60 = 9/10 * x + b
60 = (9/10 * 40) + b
60 = 36 +b
or b = 60- 36
b = 24

Number of women who said Yes is 24.
Thus, fraction women who said yes is 24/100= 6/25
Answer: Fraction of Women who said Yes is 6/25
Question 9
MARK FREQUENCY
14 2
15 5
16 4
17 4
18 5
TOTAL 20
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.
Solution: Given data:
Total number of students = 20
Formula to be used, mean = Sum of marks obtained/ Total number of students
= {(14*2) + (15*5) +(16*4) +(17*4) +(18*5)}/20
= {28+75+64+68+90}/20
= 325 / 20 = 16.25
From the table, it is evident that students scored 14,15 and 16 would re-take tests, as it is leass
than the mean of 16.25.

Thus, 11 students must retake.
Question 10 Which fraction is bigger - 2/3 or 3/5?
Solution: Given data, 2/3 = 0.6667
3/5 = 0.6
Hence, 0.6667 > 0.6
Thus, 2/3 > 3/5.
Answer: 2/3 is bigger fraction
PART 1 - SECTION 2
Question 1
a)
Solution: The following steps will be taken to sort the given sheet into ascending alphabetical
order.
1. First 'cell B' must be highlighted using the cursor. This means select the entire column
to sort.
2. Then click on 'Data' on the menu-bar.
3. Select 'Sort' option; click on lowest to the highest option where alphabetical order is
given, that is. A to Z.
4. Click to arrange the surnames in ascending order.
b)
Solution:
11 The following commands must be used to attain the below table:11 Click on the Hours worked column, that is E.11 Then go to menu-bar on Home.11 Click on Sort & Filters option.11 Then on Filters option.

11 Click on the arrow given on the side of the Hrs worked.11 Select 'Numbers Filter' option and select greater than 30.11 Lastly the below tabular column would be achieved.
Name Surname
G
ende
r
Hourly
Rate
Hrs
Worked Gross Amount Deductio
ns
Net
Amount
Dykes Bolten F £21.0
0 35 £735.
00
£1
10.25
£62
4.75
Messi Patridge M £10.0
0 40 £720.
00
£1
08.00
£61
2.00
Morko
e Neville F £20.0
0 35 £700.
00
£1
05.00
£59
5.00
Smith Philips M £24.0
0 32 £768.
00
£1
15.20
£65
2.&0
c)
Solution: From given spreadsheet, Average amount is given = £530.80
So, it is clear that 6 people earned below the given average.
First Name Net Amount
Andy £382.50
Bronwyn £374.00
Candice £382.50
Tanika £285.60
Sandra £309.40
Charlotte £433.50
d)
Solution: Bar Graph will be considered suitable to use in representing Net Amounts.
Consider the following below graph.

e)
Solution: C column might have been used to conduct replication.
f)
Solution: Formula used for cell H20 is as follows:
= sum (H4:H18)
Answer: The acquired results in the value is Grand Total of £5,292.95
Question 2
Write the functions or commands for the following:
a. Total number of males
Home menu < Sort & Filter < Filter < Select arrow mark < Select M < OK
b. Total number of records with hourly rate greater than £20
Home menu < Sort & Filter < Filter < Select arrow mark < Select Text Filters < Custom Filters <
Select greater than £20 < OK
0 1 2 3 4 5 6 7 8 9 10

c. Total number of surnames with the letter ‘m’ in them
Home menu < Sort & Filter < Filter < Select arrow mark < Select Text Filters < begins with m <
OK
d. Sum the Net Amount for the males who earned a Net Amount greater than or equal to £595
Home menu < Sort & Filter < Filter < Select arrow mark < Select Text Filters < Custom Filters <
Select greater than or equal to £595 < OK
e. To Search the database (the whole spreadsheet) to find ‘Smith’ and the corresponding
Deductions
Type Control + F and write Smith to find it.
PART 2
A. Role of descriptive statistics in success of motion pictures
Descriptive statistics quantitatively explains the attributes or characteristics of gathered
information. This type of statistics summarises the sample instead of learning or making
interference regarding the sample or the variables. The performance of motion pictures depends
upon four different variables namely Opening gross sales (OGS), Total gross sales (TGS),
number of theatres (N) and number of weeks picture remained in top 60 (W). The application of
descriptive statistics on these variables specify the performance characteristics of motion picture.
This evaluation is essential as it helps motion picture industry to analyse the most successful and
worst performing pictures so that further strategies or actions can be taken. The key descriptive
statistics which can be used for enhancing success of industry are as follows:
Total:
The total values are one of the simplest ways to analyse the performance. The TGS
indicate the overall profit achieved by a particular motion picture. It helps industry to evaluate
that how much benefit it has achieved after eliminating the operational expenses. Though TGS
gives a bigger clarity of the performance the success can also be measured by having totals of
other variables. For instance, the total duration for which a picture remained in top 60 or in

theatre indicate that audience is giving a positive response towards the work and it will achieve
the success benchmark.
Mean:
This statistical description describes the average value received by different success
variables of motion pictures. This attribute helps industry to calculate the expected success rate
or profit values from the available records. Thus, it provides the expected future returns in a
quick and simpler manner. Similarly, the performance of each of the motion picture depends
upon above discussed four variables. Thus, by calculating the mean or average of every picture it
is possible for the industry to predict and calculate the most successful or the least successful
picture. The mean value of opening sales can also be used by the industry to compare its
performance by past records or to define targets for the future success.
Median:
The median describes the value which separates the upper and lower half values from a
specific data set. For instance, with median value motion picture can determine which pictures
have ranked above and below than a particular rated picture. For sales analysis when profits can
vary greatly for various pictures then median statistics does not skew by the influence of
extremely small or high values. Similarly, industry can make conclusion that if particular picture
has achieved success if it has total gross sales above median value of TGS. Thus, median values
inform that if industry has been able to achieve its sales or profit targets or not.
Variance:
The variance explains that how a specific value differs or vary from the average or
expected value. This attribute can describe that whether estimated sales records have been
achieved or not. With the help of variance, it is possible for the motion picture industry to
evaluate the difference between its budget and actual cost or the difference between expected and
real profit achieved. Thus, variance can also be employed by the industry to analyse that how
specific performance variables vary over specific period of time so that they can be improved.
Standard deviation:

Standard deviations tell about the variability and volatility of performance of each of the
pictures produced by the industry. It can also be used to evaluate the overall performance
characteristic of particular picture. For instance, all success dependent variables affect the
success. Thus, standard deviation will describe the overall impact on determining success or
failure of each picture. It can also be used to find out the error margins. For instance, with this
approach motion picture industry can make recommendations that for enhancing total sales how
many numbers of theatres can be increased or how the opening collections of pictures influences
the success levels and standards.
Thus, by using above discussed statistical attributes the factors influencing success can be
determined and regulated.
B. Graphical Summaries

1. Motion Picture versus OGS
Motion picture OGS (Opening gross sales in
$millions)
Coach Carter 29.17
Ladies in Lavender 0.15
Batman Begins 48.75
Unleashed 10.9
Pretty Persuasion 0.06
Fever Pitch 12.4
Harry Potter and the Goblet of
Fire
102.69
Monster-in-Law 23.11
White noise 24.11
Mr. and Mrs. Smith 50.34

Figure 1.Motion Picture vs OGS
Summary: The above graph infers that Harry Potter and Goblet of Fire is the highest earning
motion picture with opening gross sales of 102.69 million dollars.
2. Motion Picture vs TGS
Motion picture TGS (Total gross sales in
$millions)
Coach Carter 67.25
Ladies in Lavender 6.65
Batman Begins 205.28
Unleashed 24.47
Pretty Persuasion 0.23

Fever Pitch 42.01
Harry Potter and the Goblet of
Fire
287.18
Monster-in-Law 82.89
White noise 55.85
Mr. and Mrs. Smith 186.22
Figure 2. Motion Picture vs TGS
Summary: The above graph infers that Harry Potter and Goblet of Fire is the highest earning
motion picture with total gross sales of 287.18 million dollars.
3. Motion Picture versus N
Motion picture N (Number of Theaters )

Coach Carter 2574
Ladies in Lavender 119
Batman Begins 3858
Unleashed 1962
Pretty Persuasion 24
Fever Pitch 3275
Harry Potter and the Goblet of Fire 3858
Monster-in-Law 3424
White noise 2279
Mr. and Mrs. Smith 3451

Figure 3: Motion Picture versus N
Summary: The above graph infers that Harry Potter and Goblet of Fire and Batman Begins
opened in 3858 theatres and took top positioning.
4. Motion Picture versus W
Motion picture Weeks on Top 60 (W)
Coach Carter 16
Ladies in Lavender 22
Batman Begins 18
Unleashed 8
Pretty Persuasion 4
Fever Pitch 14

Harry Potter and the Goblet of Fire 13
Monster-in-Law 16
White noise 7
Mr. and Mrs. Smith 21
Figure 4.Motion Picture vs W
Summary: The above graph infers that Ladies in Lavender was on for 22 weeks followed by Mrs.
And Mr. Smith for 21 weeks respectively.
C. High performance outliers
By considering all associated success parameters the high-performance outliers can be
analysed by measuring the mean performance of the picture.
Motion picture OGS (Opening
gross sales in
$millions)
TGS (Total gross
sales in $millions)
Mean value
of profit
(in $millions)

Coach Carter 29.17 67.25 48.21
Ladies in Lavender 0.15 6.65 3.4
Batman Begins 48.75 205.28 127.02
Unleashed 10.9 24.47 17.68
Pretty Persuasion 0.06 0.23 0.15
Fever Pitch 12.4 42.01 27.2
Harry Potter and the Goblet of
Fire
102.69 287.18 194.93
Monster-in-Law 23.11 82.89 53
White noise 24.11 55.85 39.98
Mr. and Mrs. Smith 50.34 186.22 118.28
From the above calculation it is observed that Harry Potter and the Goblet of Fire is the
first high performance outlier. After considering its opening day sales and overall sales from all
outlets the mean sales records achieved by this picture are highest. Thus, it can be considered as
the best performer in all aspect and variables.
D. Relation between total gross sale and each of the other variable
The different success variables of motion picture industry influence each other. Thus,
their interrelations with TGS is described as below:
Relation between TGS and opening gross sales:
The OGS directly influences the TGS in a non-linear pattern. When OGS records for a
particular picture are high then TGS is also increased but the incremented value also depends
upon revenues collected from other days. The opening sales changes are directly reflected in
TGS. It is also possible that opening day sales of motion pictures can affect the overall TGS. For
instance, when OGS of any picture are extremely good then audiences are motivated to show
positive response towards picture. In such cases there is higher probability that in further days
the sales collection for the picture will be increased from the bulk OGS. Thus, in turn the TGS
will increase further. The OGS and TGS shares a dependency on each other. It is also possible

that despite of low OGS the higher values of frequent days collection can give significant rise to
TGS.
TGS and number of theatres in which picture was screened:
TGS variable is used to determine the overall success of picture. The motion picture
industry provides the screening of its pictures in various theatres. The total value of TGS can be
considered as the sum of gross sales collected from every theatre. However, it is not assured that
increased number of theatres will guarantee the increase in TGS. It is possible that there may be
great variation in the sales profits of every theatre thus they will have a non-uniform impact on
TGS. The theatres which have excellence sales and performance records usually generate major
contribution to the TGS. Thus, motion picture industry ensure that its pictures are screened
among top theatres as well as in majority of theatres so that more audience can view the picture
and success rate as well as TGS is enhanced.
Dependency between TGS and number of weeks (W) for which the picture sustained its
position in top 60:
It is always matter of pride for motion picture industry when its picture holds position in
top 60 for long duration. It shows that picture is greatly appreciated by the people and great
response is received from them. However, TGS and W are completely dependent upon each
other. The pictures which have record breaking TGS considered to be successful and can easily
sustain the place in top 60 for a greater number of weeks. Thus, W can be increased if TGS is
higher. Similarly, when a picture continues to be in top 60 ranking for good value of W then
more people are inspired to watch the picture and increase the TGS.
These interdependencies between all variables is essential to analyse. This analysis helps motion
pictures to improve their strategies and profitability. It also demonstrates that how other variables
can improve the TGS of the pictures.
E. Scatter diagram reflecting relation between total and opening weekend gross sales
The total gross sales (TGS) and opening gross sales (OGS) are closely related to each
other and their relation can be considered to have non-linear and positive correlation. Though
higher values of OGS will definitely increase the TGS value but the overall increment in TGS
also depends upon the sales of picture in consecutive days. Thus, it can be said that TGS not only

depends on only OGS instead it is calculated by adding OGS with sales collection in other days.
It shows that there exists a non-linear relation between both of these variables which is
controlled by third variable. However, it is definite that whenever OGS are increased there will
be an increment in TGS. It demonstrates that there is positive correlation which means that
positive change in one quantity will be reflected in another variable as well.
The positive and non-linear relation between TGS and OGS is represented by above scatter
diagram.
Illustration 1: Scatter diagram showing
relation between TGS and OGS