View the step-by-step solution to:

Data from the 2000 U. Census show the following distribution of ages for residents of Ohio: Total Households 4,445,773 Family households (families)...

Spreadsheet uploaded, please provide all formula
1. 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 1 8 years 1,409,912 Married‐couple family 2,285,798 With own children under 1 8 years 996,042 Female householder, no husband present 536,878 With own children under 1 8 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.
Background image of page 1
2. A community health status survey obtained the follow- ing demographic information from the respondents: Age Frequency 1 8–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?
Background image of page 2

This question was asked on Jan 13, 2013.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
  • -

    Flashcards

    Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

    Browse Flashcards