Statistics and Data Analysis Assignment: Numeracy, Data, and IT

This assignment solution provides a comprehensive overview of numeracy, data analysis, and IT concepts, covering various mathematical calculations and statistical methods. The document begins with an executive summary and then delves into detailed solutions for numerous questions related to percentages, fractions, mean, mode, and other statistical measures. The solution includes calculations, explanations, and the application of spreadsheets to solve problems. Furthermore, the assignment extends to descriptive statistics, exploring the role of these methods in analyzing data, particularly in the context of motion pictures. The solution includes the use of descriptive statistics such as mean, median and variance to analyze performance, and the interpretation of graphical summaries, and other data analysis techniques. The assignment also explores data interpretation, including the analysis of outliers and the relationship between different variables. Overall, the assignment showcases the practical application of statistical concepts and data analysis techniques.

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