User Account

All Pages

Develop the tabular form and graphical bar chart

Assignment Help Other Subject
Reference no: EM131180124

Assignment: Analysing Household Data

Background: Have you been part of a national census? Privacy issues aside, a census is a complete enumeration which provides lots of data that can inform a government policies and actions - but to be useful, the data needs to be summarised (tabular or graphic form), analysed and interpreted. In this assignment, we will use statistical methods to summarise, analyse and interpret real world demographic data.

Objective: The objective of this assignment is to

  • Test your understanding of statistical methods and approaches
  • Improve your ability to use Excel for manipulation of data
  • Interpret the statistical results
  • Understand the real-world applications and implications of statistics

To complete this assignment you must

  • Complete a set of statistical analyses tasks on a unique data set available on LMS.
  • 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

  • Download Excel Data file Data_Assignment01 from LMS. Once you download this file, enter your Student ID in the space provided as shown in the picture below.
  • 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 (Tutorial 02, for instance) 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 is provided 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.

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. Organize 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 or why not?

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:

a. 1st Class = Very Poor

b. 2nd Class = Poor

c. 3rd Class = Moderate

d. 4th Class = Rich

e. 5th Class = Very Rich.

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% and bottom 10 % of your WEF household values?

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 disparity of your WEF?

Task 4-

A. What is the probability that a randomly selected head of a household is female and her HLE is Primary?

B. What is the probability that a randomly selected household head is male 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 CollegeDegree" are independent? Explain briefly.

Attachment:- Assignment.rar

Reference no: EM131180124

Questions Cloud

Interview two different types of local retail merchants : Interview two different types of local retail merchants (for example. a boutique owner and a manager of a franchise) to determine how the merchandise in their stores is distributed to them.
Strategy to obtain cooperation from the university : What probiems, if any, do you see with the use of the university's brand? -  What strategy should they pursue to obtain cooperation from the university?
How many stagnation points is there : Using 2DFlowPlus, investigate the flow past a circular building (for an ideal fluid with irrotational flow motion). How many stagnation points is there? Compare the resulting flow pattern with real-fluid flow pattern behind a circular bluff body (..
Review several of your classmates posts : Review several of your classmates' posts. Respond to at least two of your classmates. Challenge your classmates by asking a question that may cause them to reevaluate or confirm their understanding.
Develop the tabular form and graphical bar chart : What sampling method is used to select your sample data? Develop the tabular form and graphical bar chart of WI based on the following classification
How many print shops where there in 1994 : The number of print shops in operation during any year from 1990 to 2005 is given by the equation y=-2.5x^2+22.5x+45 where x is the number of years since 1990. How many print shops where there in 1994?
What other channels of distribution might tomboy tools use : What are the advantages and disadvantages of the in-home method of selling Tomboy Tools?- What other channels of distribution might Tomboy Tools use?
What is the laplacian of a function : Rewrite the definition of the Laplacian of a scalar function as a function of vector operators (e.g. grad, div, curl).
Did they adequately justify their assigned positions : Did they adequately justify their assigned positions? What scholarly information can you offer to support or refute their position? It is important to demonstrate critical thinking in your peer responses.

Reviews

len1180124

8/24/2016 3:05:53 AM

This is an Assignment of worth 15% in your total assessment. Each student will use a unique data set to complete this assignment. You should use Excel for all your computational work. Please give detailed calculations for all the given 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 which are required to support your solutions.

Write a Review

Other Subject Questions & Answers

  Ways in which zappos employees are empowered

Zappos has made it a priority to empower its employees and enable them to make more decisions. What are some specific ways in which Zappos employees are empowered

  How were these ideas applied to us foreign policy

Explain Manifest Destiny and American exceptionalism. How were these ideas applied to U.S. foreign policy at the turn of the 20th century? What do you see as the positives and negatives of American Imperialism?

  Process by people act and react in relation to others called

The process by which people act and react in relation to others is called:

  Find a few constellations in the night sky

A description of how you used this information to find a few (say three) constellations in the night sky. Include the date, time, and direction (e.g. North-West) that you saw each constellation. If you were in a place other than Toledo, also mention ..

  Finding a flexibility test

Find a flexibility test (V sit-n-reach, modified sit-and-reach, back-saver sit and reach, or back scratch test) and write up a lab report regarding the test, and include an introduction, methodology, results and conclusion.

  Create a productive work environment

Budgets play a critical role in management activities such as planning, controlling and motivating employees. Used effectively, budgets can help a company achieve its goals and create a productive work environment

  Choose a social marketing campaign

Choose a social marketing campaign

  Discuss how the given article could be improved

Critique the article for Statistical Significance. Discuss how the article could be improved. Explain whether you agree with the authors' conclusions, and why or why not.

  Water and electrolytes cannot move across cell membranes

Which of the following is TRUE? A - Water and electrolytes cannot move across cell membranes. B- Electrolytes freely move across cell membranes. C- Water freely moves across cell membranes D- Water and electrolytes move across the cell membranes only..

  Values may be self-governing

Values may be self-governing, but they do change with time. The link among personality, values, and work ethics is difficult to decipher. Your basic makeup is with you in every situation, especially in your organization.

  Cognition and behavior crucial component of learning process

Why are cognition and behavior crucial components of the learning process? write 200-300 word supply references apa format

  Support social arrangements including stratification

In the united states, wealth is distributed more equally than income. as surprising as it may seem, in the united states poor people typically have better health than rich people. The concept ideology refers to ideas that support social arrangements ..

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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