Question Description

I need help with a Business question. All explanations and answers will be used to help me learn.

CAN YOU DO:

I HAVE EBOOK

Data from the 2000 U.S. Census show the following distribution of ages for residents of Ohio:  

Total Households  4,445,773 

 Family households (families)  2,993,023 

 With own children under 18 years  1,409,912 

 Married‐couple family  2,285,798 

 With own children under 18 years  996,042 

 Female householder, no husband present  536,878 

 With own children under 18 years  323,095 

 Nonfamily households  1,452,750 

 Householder living alone  1,215,614 

 Householder 65 years and over  446,396 

a.  Construct a column chart to visually represent these data. 

b.  Construct a stacked bar chart to display the sub categories where relevant. (Note that you will have to compute additional subcategories, for instance, under Family households, the number of families without children under 18, so that the total of the subcategories equals the major category total. The sum of all categories does not equal the total.) 

 c.  Construct a pie chart showing the proportion of households in each category. 

  A community health status survey obtained the following demographic information from the respondents: 
 

 Age  Frequency 

 18–29  297 

 30–45  661 

 46–64  634 

 65 +  369  

Compute the relative frequency and cumulative relative frequency of the age groups. Also, estimate the average age of the sample of respondents. What assumptions do you have to make to do this?