Draw a scatter plot of natural log of total expenditures

Assignment Help Other Subject
Reference no: EM131619174

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 a 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
- 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 in a report in word detailing your response to each task (the final answer and reasoning / calculations that led to it)
- Submit an excel document that contains your data set and the calculations you used to complete the tasks

Important:
- This is an individual Assignment worth 30%. 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.

Instructions: Analysing Australian Household Data

In this assignment you will be analysing and interpreting real data of two thousands (2000) Australian households. This data has been taken from 2005 HILDA (Household, Income and Labour Dynamics in Australia) Survey. We will treat these 2000 Households as population and would perform a statistical analysis by drawing a sample (which, indeed,would be a subsample!) of 200 households.

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 200 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 200 samples) - 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 Data Set for this Assignment is available on LMS (Data Set for Assignment01.xls). This includes information of 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;
P: Primary
S: Secondary
I: Intermediate
B: Bachelor
M: Master

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.

Task 1
A. Draw a random sample of two hundred (200) 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, 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. Also, use an appropriate measure of variation to compare the variability in expenditures on these four variables. Explain, why is this an appropriate measure.
D. Present a summary of your findings about the shape and spread of the distribution of these variables using information from the boxplots and the descriptive statistics.

Task 2
A. Construct a frequency distribution of the expenditures on Utilities, using the following classification (9 classes);
1 2 ... 8 9
Classes 0 - 400 400 - 800 ... 2800 - 3200 More than 3200
B. What is the percentage of households that spend on Utilities
1.
a.
i. at the most $ 1200 per annum
ii. between $1200 and $2400 per annum, and
iii. more than $2400 per annum.

C. Draw the histogram of the expenditures on Utilities by households in your sample. Do you think the utility expenditures are normally distributed? Provide the "statistical reason" for your answer?

Task 3
A. What is the top 10% value and the bottom 10 % value of household's annual after tax income (AtaxInc)? What does these two values imply?
B. What does the mean (average) of variable OwnHouse imply?
C. What is the probability that a randomly selected household will have a family size (FS= Adults + Children) equal to 5?
D. Draw a scatter plot of natural log of total expenditures against natural log of after tax income, that is, ln(texp) against ln(ataxinc) and compute the coefficient of correlation. Express your finding about the relationship between the two variables.

Task 4
A. Construct a contingency table between the gender and the level of education. Using information in this table, can we say that male and female heads of the households differ in their higher level of qualification?
B. What is the probability that the head of household is a female and her higher level of education is Intermediate?
C. What is the probability that the head of household is a male and has the Bachelor degree?
D. What is the proportion of having the Secondary as the highest degree from among females?
E. Do you think that the events "gender of household head is male" and "having the Master Degree" are independent?

Attachment:- Data Set.xlsx

Verified Expert

This task provides a clear working example on generating the random samples using random number generation techniques. Contingency tables were created to determine the marginal probability and conditional probability values

Reference no: EM131619174

Questions Cloud

Perpendicular to the mid-point of a dipole : Calculate the electric field at a distance of 3.0 m perpendicular to the mid-point of a dipole consisting of point charges of ±1.0 C 10.0 cm apart
Rate of acceleration for the car : Also what is the rate of acceleration for the car?
Discuss the impact and methods of interest groups : Define interest groups and discuss the impact and methods of interest groups. How can a group use protests as a tool?
Discuss tone of the interview of michael crowe was warranted : In what ways were Michael Crowes 4th, 5th and 14th amendment rights violated
Draw a scatter plot of natural log of total expenditures : Draw a scatter plot of natural log of total expenditures against natural log of after tax income, that is, ln(texp) against ln(ataxinc) and compute the coefficient of correlation.
Drafts a meeting announcement and agenda : Drafts a meeting announcement and agenda, and explains the assumptions underlying the choices made in drafting these documents.
Describe frieda fromm-reichmanns role at chestnut lodge : What are some of the most important ways Dr. Hornstein differentiates Chestnut Lodge from other mental hospitals of the 1930s-1950s
Determine financial review section statement of interest : Other Information in a Financial Review Section of an Annual Report. Gustav Humphreys (chair of the board) and Ingrid VanEns (vice president, finance).
Discuss what are some of the environmental challenges faced : What are some of the environmental challenges faced by immigrant women

Reviews

inf1619174

10/13/2017 5:05:57 AM

This assignment was for my friend and he received his grade too. So, as per him, he received very good grade for the solution. I am eagerly waiting for mine and will hope for the same grade. Thank you so much Expert and the My assignment team for taking good care of us. You deserve 5-star ratings from me. Goodluck!

inf1619174

10/13/2017 5:04:14 AM

if you use articles for information then use schorlarly articles and give reference in APA style. Assignment 1 Instructions.docxI have made payment for my assignment. Please found attached REceipt. 24826566_1Screenshot 20170830-103759.png Data Set for Assignment01-Household Surveyxls.xlsx how to select random data.pdf

len1619174

8/30/2017 3:05:34 AM

Don’t do: • 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. Do: • Submit the data set on 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

len1619174

8/30/2017 3:05:23 AM

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 a 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.

len1619174

8/30/2017 3:05:11 AM

student of masters of accounting and financial management.This assignment is related to statistics for business and finance(subject). i want to confirm can do this assignment.

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd