Basic Business Statistics Using Excel

Running head: BASIC BUSINESS STATISTICS USING EXCEL
Basic Business Statistics Using Excel
Name of the Student:
Name of the University:
Author Note:

BASIC BUSINESS STATISTICS USING EXCEL
1
Table of Contents
Introduction................................................................................................................................2
T1.A. Sampling...........................................................................................................................2
T2.B. Descriptive Statistics and Box-Whisker plot of Expenditures..........................................2
T3.C. Features of Each Distribution...........................................................................................3
T2.A. Top and Bottom Value of After-tax annual income.........................................................3
T2.B. Description of Households (HH) owning a housing.........................................................4
T2.C. Scatter plot of ln(Texp) against ln(Ataxinc).....................................................................5
T3.A. Contingency Table between the Gender and the Level of Education..............................6
T3.B.C. &D. Probability Computation with the Contingency Table..........................................6
T3.E. Events "Gender of Household Head is Female" and "Education is Primary"..................7
Conclusion..................................................................................................................................7
Reference and Bibliography.......................................................................................................8

BASIC BUSINESS STATISTICS USING EXCEL
2
Introduction
In the recent periods there has been a lot of use of data science and statistics in
business, research and studies in health, finance, accounts and social science to get the
insight. They are using these in purpose of research, financial industries and banking
industries are using these in order to enhance the business and also to raise the profit and
reduce the costs. Here, the report will analyse the income and expenditure of a household
with the help of basics statistics technique, figures and charts to visualise with the help of
MSExcel. In the below sections, sampling and important findings are discussed.
T1.A. Sampling
There is a data on income, expenditure and demographics of HH and simple random
sampling is performed to choose the data in order to analysis. The simple random sample is
selected while the probability of each observation is equal across the population (Lohr, 2019).
The best method is simple random sampling with the demographic characteristics of HH like
the gender, education levels etc. as the researcher can extract any smallest subgroup from the
population for the research.
T2.B. Descriptive Statistics and Box-Whisker plot of Expenditures
Table 1: Descriptive Statistics of Alcohol, Meals, Fuel and Phone
Descriptive Statistics
Alcohol Meals Fuel Phone
Mean 1128.8 1191.9 2213.37 1446.3
Median 782 840 1560 1080
Mode 0 0 2400 1200
Standard Deviation 1327.58 1392.03 3146.21 1729.22
Sample Variance 1762478 1937736 9898619 2990219
Kurtosis 6.62222 10.1313 60.4812 36.1467
Skewness 1.99228 2.66492 6.61245 5.16118
Range 9385 9600 36000 16500
Minimum 0 0 0 0
Maximum 9385 9600 36000 16500