Microsoft Excel Data Analysis

Running Head: A STUDY ON THE HOUSEHOLD DATA
A STUDY ON THE HOUSEHOLD DATA
Name of the Student:
Name of the University:
.
Author Note:

A STUDY ON THE HOUSEHOLD DATA1
Task 1
A. Here a random sample of 250 households has been taken by using random selection
procedure. In this process, random numbers are created and the dataset is sorted
according to the generated random numbers from which the sample was selected. Due
to randomization, the sample reflects the entire population and reduces sampling
error. Moreover, all the households have equal chance of being selected in the sample.
Hence, this is the best sampling method for this data.
B. The descriptive statistics and box plots of the variables- alcohol, meals, fuel and
phone are given below.
Table 1: Descriptive Statistics
Alcohol Meals
Mean 1070.776 Mean 1105.576
Standard Error 84.6086 Standard Error 76.3080
Median 587 Median 720
Mode 0 Mode 0
Standard Deviation 1337.7795 Standard Deviation 1206.5356
Sample Variance 1789654 Sample Variance 1455728
Kurtosis 10.1459 Kurtosis 6.1005
Skewness 2.4116 Skewness 2.1274
Range 10428 Range 7800
Minimum 0 Minimum 0
Maximum 10428 Maximum 7800
Sum 267694 Sum 276394
Count 250 Count 250
Fuel Phone
Mean 1808.064 Mean 1392.792
Standard Error 100.3622 Standard Error 89.7956
Median 1440 Median 1080
Mode 0 Mode 1200
Standard Deviation 1586.8652 Standard Deviation 1419.7933
Sample Variance 2518141 Sample Variance 2015813
Kurtosis 3.9027 Kurtosis 17.8801
Skewness 1.5562 Skewness 3.6312
Range 10200 Range 10800
Minimum 0 Minimum 0
Maximum 10200 Maximum 10800

A STUDY ON THE HOUSEHOLD DATA2
Sum 452016 Sum 348198
Count 250 Count 250
Graph 1: Boxplots for expenditures
C. Table 1 shows that on average, the annual expenditures on alcohol, meals, fuel and
phones are 1070.7761071, 1105.5761106, 1808.0641808 and 1392.7921393
AUD respectively. The standard deviations are 1337.7795, 1206.5356, 1586.8652 and
1419.7933 respectively, which indicate that the data points are widely varied. The
median shows that in 50% households, the annual expenditure on alcohol is less than
587AUD. 50% household spent less than 720 AUD on meals, 740 AUD on fuel and
less than 1080AUD on phone annually. The minimum value for any of these
expenditure is 0. The mean is greater than the median in each case. Moreover, the
skewness coefficients are also positive. Hence, the distributions of annual expenditure
of each of the mentioned variables are positively skewed.
The graph shows that the medians are closer to the first quartile than the third
quartile for each of the variables. This implies that the distribution is positively