Assignment 1 Instructions
Analysing Household Data
Statistics for Business and Finance (BUS5SBF)
Have you been part of a national census? Privacy issues aside, a census provides lots of data that can inform government policies and actions - but to be useful, the data needs to be analysed and interpreted.
In this assignment, we will use statistical methods to analyse and interpret real-world demographic data.
The goal of this assignment is to
• Test your understanding of statistical methods and approaches
• Improve your ability to use Excel for manipulation of data (see here for some guides on using Excel)
• Understand the real-world applications and implications of statistics
To complete this assignment you must
• Complete a set of statistical analysis tasks on a unique data set (both tasks and data set will be provided to you)
• Submit a report in word detailing your response to each task (the final answer and reasoning including calculations that led to it)
• Submit an excel document that contains your data set and the calculations you used to complete the tasks
• This is an individual Assignment worth 20%. Each student will use a unique data set to complete the assignment.
• You should use Excel for all your computational work.
• Please provide detailed calculations for all the tasks. Not explaining how you arrived at your conclusions may result in only partial marks being awarded for those tasks.
• Present your computer results in appropriate tabular form. Also, include graphs where required to support your answers.
• Please do not copy your data set or assignment questions on the word files you are submitting since this will trigger plagiarism detection and might affect your submission. Submit the data set you use as a separate excel document.
• Copying someone else's work would result in plagiarism. Please read LTU's policy on plagiarism stated in the Subject Learning Guide for this subject.
• Do not submit zip folders containing your work.
• Submit the data set in excel file with your detailed working in the same file. You can use separate sheets in the same Excel file for each task with properly labelled parts.
• Submit your detailed report in word or pdf format only.
• Use the marking rubric as a guide when working on your assignment
Instructions: Analysing Household Data
In this assignment, you will be analysing and interpreting household data.
Step 1: Prepare Data Set
• You need to download and modify the generic data set to identify the sample you will be working on. More information on the data set is available below.
• Important: You do not need to analyse the entire data set – only draw a random sample of 250 households. This must be done first and the rest of your statistical analysis will be based on this data set.
• You will need to know how to manipulate data in Excel. You can use any other compatible spreadsheet tool (for example Numbers for Mac OS, OpenOffice, LibreOffice etc) but be aware that some of the functions differ slightly.
• There are plenty of resources online and in this LMS that will show you how to perform these tasks in Excel. Use these resources (and Google) to improve your skills as you progress. If you have a particularly difficult challenge, share it in the forum and your tutors or peers will help.
Step 2: Analyse Data & Submit Report
• You will be presented with a set of tasks to run on your unique data set (of 250 households) - the full list of tasks are listed below.
• As much as possible, complete these tasks within the excel document. You will need to submit your excel document at the end of the assignment.
• You will also submit a brief report in word addressing all the tasks below. When responding to the tasks, please explain the reasoning behind your answer, and refer to your Excel sheet.
Data Set: Household data
The DataSet for this Assignment is available on LMS (Data Set for Assignment 01.xls). This includes information about 2000 households across the following variables.
• Income: Annual Income in AUD,
• ATaxInc: After-tax annual income in AUD
• Grocery: Annual expenditures on groceries in AUD
• Alcohol: Annual expenditures on alcohol in AUD
• Meals: Annual expenditures on meals eaten out in AUD
• Fuel: Annual expenditures on fuel in AUD
• Cloth: Annual expenditures on clothing in AUD
• Phone: Annual expenditures on phone in AUD
• Utilities: Annual expenditures on utilities (Water, Gas, Electricity) in AUD
• Texp: Annual total expenditures in AUD
• Children: Number of children in a household
• Adults: Number of adults in a household
• OwnHouse: This is a categorical variable and takes value 1 if a household owns a house and 0, otherwise.
• GHH: Gender of the Head of Household (M: Male, F: Female)
• Highest Degree: Highest Level of Education, where the Highest Level of Education is;
Tasks for Analysis of Data Set
Complete the following tasks based on the unique data set you generated. These questions should be answered in a Word document, with brief reasoning to justify your answers. Your answers and reasoning should correlate with the tables and graphs from the excel sheet.
A. Draw a random sample of two hundred and fifty (250) households as per the sample selection procedure. What sampling method have you used to select your sample data? In your opinion, is this the best method of sampling particularly when one is interested in characteristics like the gender of the household head, education levels etc., why or why not?
B. Compute the descriptive statistics and draw a Box-Whisker plot of Expenditures on the following variables (all series in one graph!);
(i) Alcohol (ii) Meals (iii) Fuel (iv) Phone
C. Use information from the descriptive statistics and the boxplots in part (B) above to present a summary of your findings by contrasting different features of these distributions.
A. Construct a frequency distribution of the expenditures on Utilities, using the following classification (11 classes).
1 2 ... 10 11
Classes 0 - 300 300 - 600 ... 2700 - 3000 More than 3000
B. Using frequency distribution of the utilities above, what is the percentage of households who spend on Utilities
1. at the most $900 per annum
2. between $1500 and $2700 per annum, and
3. more than $3000 per annum.
A. Find the top 5% value and the bottom 5% value of the household’s annual after-tax income (AtaxInc). What do these two values imply?
B. The series OwnHouse represents whether a household owns a house or not. Let X be a random variable such that X = Number of households who own a house.
(i) Is this a quantitative or a qualitative variable?
(ii) What would be the probability distribution of this random variable if we choose randomly (a) Only 1 household? (b) 250 households? Provide any relevant condition(s) to justify your answer.
C. Draw a scatter plot of natural log of total expenditures against the natural log of after-tax income, that is, ln(texp) against ln(ataxinc) and compute the coefficient of correlation. Express your finding of the relationship between the two variables.
A. Construct a contingency table between the gender and the level of education.
B. What is the probability that the head of a household is a male and his higher level of education is Intermediate?
C. What is the probability that the head of household is a female and has the Bachelor degree?
D. What is the proportion of having the Secondary as the highest degree from among males?
E. Do you think that the events -gender of household head is female- and -having the Master Degree- are independent?
Marks Distribution (Total Marks = 100)
Task 1 15 + 10 + 10 = 35
Task 2 7.5 + 7.5 = 15
Task 3 5 + 5 + 5 = 15
Task 4 12.5 + 2.5 + 2.5 + 2.5 + 5 = 25
Proper Numbering of the tasks and questions and explanation
Tables with Title/Caption,
Use of 4 significant digits after the decimal,
Graphs with captions, legends, labelled axis, and
properly cited references. 2 x 5 =10