What sampling method is used to select your sample data

Assignment Help Applied Statistics

Reference no: EM131431436

Analysing Household Data

Statistics for Business and Finance

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 (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 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

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 the 100 samples randomly selected for you. This must be done first. The rest of your work 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 100 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 1000 households across the following variables.

Weekly Income (WI),
Weekly Expenditure on Food (WEF),
Highest Level of Education (HLE)1,
Family Size (FS), and
Gender of the Head of Household (GHH)

Instructions within the excel document will explain how to select your 100 unique samples to form the data set you will use for your assignment.

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 excel sheet (where applicable, make references in this document to your excel sheet)

Task 1

A. Organise your sample data in a spreadsheet as per the instructions in the Excel sheet.

B. What sampling method is used to select your sample data?

C. Do you think that is the best method of sampling? Why not? Why yes?

D. What is the best statistic used to compare the volatility in WEF, WI, and FS values? Why?

Task 2

A. Develop the tabular form and graphical bar chart of WI based on the following classification:

1st Class = Very Poor
2nd Class = Poor
3rd Class = Moderate
4th Class = Rich
5th Class = Very Rich.

For this task, you need to divide your data into 5 categories. Use Box-Whisker plot to decide the bins for these categories.

B. What is the most frequent group in your WI sample data? What does that indicate in terms of your data distribution?

C. Do you think your WI of sample data is normally distributed? Provide the "statistical reason" for your answer?

Task 3

A. What is the top 10% value and the bottom 10 % value of your WEF household?

B. What is the probability that your WI values will be less than or equal to $200?

C. What is the probability that FS will be equal to 2?

D. Is there any outlier(s) in your sample data of WEF? Show the graph or prove for that! If yes, what is the best statistic to measure the dispersion of your WEF?

Task 4

A. What is the probability that the head of household is woman and her HLE is Primary?

B. What is the probability that the head of household is man and has the College degree?

C. What is the proportion of having the Secondary as the highest degree from among males?

D. What is the proportion of having the Intermediate as the highest degree from among males?

E. Do you think that the events "gender of household head is male" and "having the College Degree" are independent?

Attachment:- Data Set.rar

Reference no: EM131431436

Questions Cloud

Describe how the information given about consumer demand : In each of the following examples, describe how the information given about consumer demand helped managers develop the appropriate strategies to increase profitability and how this information was obtained.

Calculate the dividend payout and dividend yield : FINA 6001 Managing Finance Assignment. Provide answers to the following: Report the dividend payments over the last three years and Calculate the dividend payout and dividend yield

Explain factors in the organizations external environment : Specify the nature, structure, and types of products or services of Apple, and identify two key factors in the organization's external environment that can affect its success.

What is the businesss current market value : MBA 520- What does your assessment imply for future business health and performance? For example, what is the business's current market value? What is its price-to-earnings ratio?

What sampling method is used to select your sample data : Statistics for Business and Finance (BUS5SBF). In this assignment you will be analysing and interpreting household data. Organise your sample data in a spreadsheet as per the instructions in the Excel sheet. What sampling method is used to select you..

List the make and model of desired hardware devices : Electronic spreadsheets are useful tools, especially when creating a business budget. Once a spreadsheet is set up correctly in Excel®, values can be modified at any time, and the electronic spreadsheet will automatically update itself. Students w..

What percent of problems take more than five minutes : What percent of the problems take more than 5 minutes to resolve? Suppose we wish to find the middle 50% of the problem-solving times. What are the end points of these two times?

Organizational learning and creativity play : How does organizational learning and creativity play in helping managers to improve their decisions?

Discuss the importance of understanding cultural differences : Discuss three nonverbal differences you might encounter if you are transferred to manage a company in Rio de Janeiro, Brazil. Discuss the importance of understanding cultural differences when negotiating with people in another country.

Reviews

len1431436

3/18/2017 12:28:43 AM

Complete and accurate. Data organised optimally, appropriate visualisation and organisation tools used. Appropriate tools used accurately, with correct result. All reasoning provided, with clear linkages. Results applied within context, using accurate theory. Best possible outcomes reached, with detailed & well reasoned conclusions.

3/18/2017 12:28:32 AM

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. 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. Submit the data set on excel files along with the word document. Demonstrate in the Word report that your manual calculations match the Excel computational work. Use the marking rubric as a guide when working on your assignment.

3/18/2017 12:28:25 AM

In this assignment, we will use statistical methods to analyse and interpret real world demographic data. 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.

Write a Review

Required(*) Message

User Account

All Pages