Analyzing Household Expenditure Patterns: A Statistical Report

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

ANALYSING HOUSEHOLD DATA
1

Table of Contents
Task 1...............................................................................................................................................3
A..................................................................................................................................................3
B...................................................................................................................................................3
C...................................................................................................................................................5
Task 2...............................................................................................................................................6
A..................................................................................................................................................6
B...................................................................................................................................................6
C...................................................................................................................................................7
Task 3...............................................................................................................................................8
A..................................................................................................................................................8
B...................................................................................................................................................8
C...................................................................................................................................................8
D..................................................................................................................................................8
E...................................................................................................................................................8
References........................................................................................................................................9
2

Task 1
A.
Random selection procedure has been used in the report. It can be said that this method is the
most appropriate method if the nature and characteristics of the variables need to be taken into
consideration (Lowry, 2015). No statistical tools have been applied to arrive at the sample of
data. The major advantage of random selection procedure is that there is no involvement of
personal bias.
B.
Alcohol
Mean 1193.53
Standard Error 134.50
Median 782.00
Mode 0.00
Standard
Deviation
2126.62
Sample Variance 4522505.0
9
Kurtosis 67.33
Skewness 6.90
Range 24680.00
Minimum 0.00
Maximum 24680.00
Sum 298383.00
Count 250.00
Meals
Mean 1256.56
Standard Error 81.65
Median 960.00
Mode 0.00
Standard
Deviation
1290.97
Sample Variance 1666605.79
3

Kurtosis 4.44
Skewness 1.79
Range 8120.00
Minimum 0.00
Maximum 8120.00
Sum 314140.00
Count 250.00
Fuel
Mean 1982.05
Standard Error 212.67
Median 1275.00
Mode 0.00
Standard
Deviation
3362.56
Sample Variance 11306834.0
2
Kurtosis 141.55
Skewness 10.51
Range 48000.00
Minimum 0.00
Maximum 48000.00
Sum 495512.00
Count 250.00
Phone
Mean 1436.01
Standard Error 101.11
Median 1035.00
Mode 1200.00
Standard
Deviation
1598.63
Sample Variance 2555609.17
Kurtosis 47.14
Skewness 5.38
Range 18000.00
Minimum 0.00
Maximum 18000.00
4

Sum 359002.00
Count 250.00
Alcohol Meals Fuel Phone
0.00
10000.00
20000.00
30000.00
40000.00
50000.00
60000.00
Max
Q3
Q2
Q1
Min
C.
The descriptive statistics of the all the four variables are almost the same. However, if each and
every variable, it can be observed that there is a slighter difference between all the four primary
variables.
5

Task 2
A.
Top 10% value Bottom
10% value
147311 13120
59086 50618
117048 72423
25709 36448
76358 28553
59342 20424
95625 75249
56376 32986
147858 31030
73443 60366
12220 36932
30656 44722
41054 84975
12600 35213
57253 14672
68682 27085
23889 13244
12090 23567
46549 12385
92240 103916
25832 70782
68706 43443
40121 16288
76083 44136
46785 104336
B.
Household own a house 178
Household not owning any
house
72
Total 250
6

C.
10 12 14 16 18 20 22 24
0
2
4
6
8
10
12
Natural log of Texp
Natural log of ATaxInc
Natural log of ATaxInc 11.90
Natural log of Texp 10.04
Correlation coefficient of AtaxInc and
Texp
0.48
7

Task 3
A.
Particular
s
Male Femal
e
Total
Primary 30 29 59
Secondary 23 25 48
Intermediat
e
33 33 66
Bachelors 20 21 41
Master 15 21 36
Total 121 129 250
B.
The required probability is 15/250, i.e., 6%.
C.
The probability in the given case is 41.67% (15/36).
D.
The combined probability of females having bachelor degree is 21/250, i.e., 8.4%.
E.
It can be clearly observed that female and primary education is dependent on each other. This
can be proved from the correlation that has been determined between the given two variables
(Dodds, et. al., 2018).
8

References
 Baumard, P., 2018. Coopetiting with an irreconcilable asymmetric disadvantage. Routledge
Companion to Coopetition Strategies, pp.215-223.
 Dodds, R., Ali, A. and Galaski, K., 2018. Mobilizing knowledge: Determining key elements for
success and pitfalls in developing community-based tourism. Current Issues in Tourism, 21(13),
pp.1547-1568.
 Lowry, L. D., 2015. Bridging the Business Data Divide: Insights into Primary and Secondary
Data Use by Business Researchers. IASSIST Quarterly.
 Rahi, S., 2017. Research Design and Methods: A Systematic Review of Research Paradigms,
Sampling Issues and Instruments Development. International Journal of Economics &
Management Sciences.
9