Statistical Analysis of Expenditure Data: A Practical Assignment

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

Table of Contents
Answer A:....................................................................................................................................................2
Answer B:....................................................................................................................................................3
Graph for Name and Food.......................................................................................................................3
Graph for Name and Clothing..................................................................................................................3
Graph for Name and Entertainment........................................................................................................4
Graph for Name and Charitable Giving....................................................................................................4
Answer C:....................................................................................................................................................5
Scatter Diagram between Marital Status and Food.................................................................................5
Scatter Diagram between Marital Status and Clothing............................................................................5
Scatter Diagram between Marital Status and Entertainment..................................................................5
Scatter Diagram between Marital Status and Charitable Giving..............................................................5
Answer D:....................................................................................................................................................6

Table of figures
Figure 1: Name and Food............................................................................................................................4
Figure 2: Name and Clothing.......................................................................................................................4
Figure 3: Name and Entertainment.............................................................................................................5
Figure 4: Name and Charitable Giving.........................................................................................................5

Assessment Part 1
Section 1
Answer 1
 IIII III – IIII = IIII
Answer 2
 70 * X % = 49
 X = 49* 100 / 70
 X = 70
Answer 3
a)
Fraction Percentage
9 / 20 45 %
2 / 3 66.6 %
9 / 40 22.5%
7 / 5 140 %
1) Total number cereal bars = 150
 Number of students = 20
 Fraction = 150 / 20
 Fraction = 15 / 2
Answer 4
 Total Amount = £50
 Number of tickets = 3
 Change received = £4.20
 Price of each ticket = £50 - £4.20 / 3 = £15.26
Answer 5
a)
 10011 +10101 = 0101000
 19 + 21 = 40

b)
Answer 6
a) Total savings made
 X – 20% = 100
 X = 125
b) If 4 hairdos were done
 25*2 = 50
Answer 7
a) Mean of seven number = (5 + 12 + 12 + 8 + 4 + 10 + 5) / 7 = 8
b) Mode is 5 & 12
Answer 8
Total number of people = 200
Positive response = 200 * 3 / 5 = 120
Positive response of men = 80 * 9 / 10 = 72
Positive response of women = 120 – 72 = 48
Answer 9
 mean = (14 + 14 + 15 + 15 + 15 + 15 + 15 + 16 + 16 + 16 + 16 + 17 + 17 + 17 + 17 + 18 + 18 + 18 +
18 + 18) / 20
 mean = 16.25
 Students scored less than mean are 11 students.
Answer 10
5/9 is bigger as this is a positive number.
Section 2
Answer 11
a) Select the column in which sorting according to alphabetical order is to be performed.

Select the tab “Data” and click on ascending button.
Figure 1: Sorting by Name
b) Worked more than 35 hours in the week.
c) Average Amount = 530.70
d) 2-D line graph would be suitable as in this analysis can be easily done.
Brayton
Castlemain
Charleston
Clement
Dykes
Hall
Marfouche
Messi
Morkoe
Neville
Patridge
Philips
Praveen
Smith
Surname
0
100
200
300
400
500
600
700
800
900
Net Amount
Net Amount
e) Every column is unique so there are no chances of replicating the data.
f)

Answer 12
a) Total number of females = 8
b) Hourly rate which are >25 = 11
c) Total number of names with ‘p’ in them = 3
d) number of females net amount >= 495 are 3
e)

Assessment Part 2
Answer A:
Total, standard deviation, median and mean are calculated in the excel sheet. It is seen that total
amount spend on food, clothing, entertainment charitable giving are 2765, 1720, 900, 150 respectively.
Table 1
Name Campus Marital
Status Food Clothing Entertainment Charitable
Giving
Total
expenditure
Jenny London S 160 230 80 0 470
Annie Manchester S 180 220 50 10 460
Hacdy Manchester M 255 145 45 15 460
Martin Birmingham S 240 165 100 0 505
Ahmed London M 375 195 140 10 720
Sean London S 185 135 130 20 470
Alice London M 260 260 70 20 610
Belinda London M 320 140 105 15 580
Berjie Birmingham S 245 230 60 40 575
Barbara Manchester M 305 150 100 0 555
Liam Birmingham M 400 80 100 20 600
Total 2765 1720 900 150
Mean 276.5 172 90 15
Median 257.5 157.5 100 15
Standard
Deviation 73.33522725 53.8103666 32.57470048 11.54700538

Answer B:
Graph for Name and Food.
Food
Jenny Annie
Hacdy Martin
Ahmed Sean
Alice Belinda
Berjie Barbara
Liam
Figure 2: Name and Food
Graph for Name and Clothing.
Clothing
Jenny Annie
Hacdy Martin
Ahmed Sean
Alice Belinda
Berjie Barbara
Liam
Figure 3: Name and Clothing.

Graph for Name and Entertainment.
Entertainment
Jenny Annie
Hacdy Martin
Ahmed Sean
Alice Belinda
Berjie Barbara
Liam
Figure 4: Name and Entertainment.
Graph for Name and Charitable Giving.
Charitable Giving
Jenny Annie
Hacdy Martin
Ahmed Sean
Alice Belinda
Berjie Barbara
Liam
Figure 5: Name and Charitable Giving.

Answer C:
Scatter Diagram according to single and married.
Food Clothing Entertainment Charitable Giving
0
500
1000
1500
2000
2500
Scatter Diagram
Single Married

Answer D:
 Total Entities = 11
 Number of expenditure above £ 500 = 7
 Total Married: 6
 Number of person living in London: 5
 Total numbers of person living in London are married and have expenditure above £ 500
are 3