Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use pivot table, privot chart, and basic excel functions to answer the following questions for data in econ tab. 1. For each of the variables

Use pivot table, privot chart, and basic excel functions to answer the following questions for data in "econ" tab.

1. For each of the variables in the next tab "econ": what is the average, the standard deviation, min, max, and number of observation?

2 The variable sex indicates the sex of the head of a household. What percentage of households are headed by female (1 is male, 2 is female)?

What percentage of households are urban (variable =urban98, 0 is rural and 1 is urban)? What is the average household size (hhsize) for urban housholds with a male head of household? What is the average household size for urban housholds with a male head of household?

3. Create a new variable, agegroup, which takes value 1 if the individual is younger than 25 years, value 2 for age group 25-29, 3 for age group 30-34, 4 for age group 35-39, 5 for age group 40-44, 6 for age group 45-49, and 7 for ages 50 and above. Use either nested if() or vlookup() for creating this new variable. How many female heads of houshold are there in the age group 30-34?

4. Examine graphically the relationship between age of the head of household and location of the household (urban vs. rural), using pivot graph. In this graph, each bar should show the average value of urban for one of the age categories defined in question 3. 5. What percentage of households are urban for those headed by a female older than 50?

https://drive.google.com/file/d/1tFRJ1_TDU6evSZC74qaGLYiQ9OdRxb6m/view?usp=sharing

HERE IS THE GOOGLE LINK FOR THE EXCEL DATA

Step by Step Solution

There are 3 Steps involved in it

Step: 1

1 Calculate the Average Standard Deviation Min Max and Number of Observations for Each Variable Step... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Debra JeterJames Reeve, Jonathan Duchac, Horace Brock, Paul Chaney

4th Edition

0470506989, 978-0470506981

More Books

Students also viewed these Accounting questions

Question

Peoples understanding of what is being said

Answered: 1 week ago

Question

The quality of the proposed ideas

Answered: 1 week ago