Business Statistics Analysis: Income and Expenditure

This report presents an analysis of household income and expenditure data using basic statistical techniques and MS Excel. The study employs simple random sampling to examine income, expenditure, and demographic characteristics, focusing on variables like gender and education levels. Descriptive statistics, including mean, median, mode, and box plots, are used to analyze expenditure patterns on goods such as alcohol, meals, fuel, and phone services. The report also investigates the top and bottom income percentiles, assesses the proportion of households owning a house, and explores the relationship between after-tax income and total expenditure through scatter plots and correlation analysis. Furthermore, the report includes a contingency table to analyze the relationship between gender and education levels and computes probabilities related to these variables. The conclusion highlights key findings, such as spending patterns and the impact of income on expenditure.