9 Replies Latest reply on Apr 30, 2016 7:42 AM by Chandra Bhaskar

    How do I visualize this data?

    shreya agarwal

       

      I need help in visualizing this data age wise. I tried bars, stacked bars, but none of it is able to capture all my data effectively. I'd like to show the change in ownership age wise over time. Not sure, how should this data be rearranged to be able to visualize it better. Can somebody please help?

       

                                                                                                                                                                                                                                                                          

      200020012002/r2003
      Age of   HouseholderTotalOwnerTotalOwnerTotalOwnerTotalOwner
      United States, total102,58469,222103,94970,529105,32071,517106,11172,428
      Less than 25 years5,9661,3006,2691,4146,3941,4646,4751,477
      25 to 29 years8,1993,0988,1133,1618,2593,2058,2573,289
      30 to 34 years9,9415,41810,0035,48810,2105,60210,1385,728
      35 to 39 years11,5767,54711,2557,37910,9617,14310,8347,055
      40 to 44 years12,0168,48512,1478,59711,8798,52111,8108,420
      45 to 49 years10,8378,13211,1998,44911,2418,41311,4018,600
      50 to 54 years9,4167,4139,9967,81810,1587,90810,2487,986
      55 to 59 years7,4575,9527,6046,1568,2896,6998,5956,952
      60 to 64 years6,0134,8496,1645,0406,4435,2556,8115,581
      65 to 69 years5,6804,7365,5854,6035,6634,6955,5994,621
      70 to 74 years5,4214,4225,3414,4065,1554,2545,1894,258
      75 years and over10,0617,87210,2728,01910,6678,35910,7588,463
      200020012002/r2003
      Age of HouseholderTotalOwnerTotalOwnerTotalOwnerTotalOwner
      United States, total102,58469,222103,94970,529105,32071,517106,11172,428
      Less than 25 years5,9661,3006,2691,4146,3941,4646,4751,477
      25 to 29 years8,1993,0988,1133,1618,2593,2058,2573,289
      30 to 34 years9,9415,41810,0035,48810,2105,60210,1385,728
      35 to 39 years11,5767,54711,2557,37910,9617,14310,8347,055
      40 to 44 years12,0168,48512,1478,59711,8798,52111,8108,420
      45 to 49 years10,8378,13211,1998,44911,2418,41311,4018,600
      50 to 54 years9,4167,4139,9967,81810,1587,90810,2487,986
      55 to 59 years7,4575,9527,6046,1568,2896,6998,5956,952
      60 to 64 years6,0134,8496,1645,0406,4435,2556,8115,581
      65 to 69 years5,6804,7365,5854,6035,6634,6955,5994,621
      70 to 74 years5,4214,4225,3414,4065,1554,2545,1894,258
      75 years and over10,0617,87210,2728,01910,6678,35910,7588,463
        • 1. Re: How do I visualize this data?
          Dan Eggleton

          Not to sound like an idiot but... I'm assuming the total column is total households, what does owner signify?

          • 2. Re: How do I visualize this data?
            shreya agarwal

            Sorry, I didn't paste the data correctly. You're right Total is Total households, and Owners represents -- people owning the households. For instance, Total US Households -- 102,584 -- out of that 69,222 are owned, while rest others are rented. 

            • 3. Re: How do I visualize this data?
              Dan Eggleton

              Try this:

               

               

              Age GroupCategoryYear# of Houses
              <25Total Households20005,966
              25-29Total Households20008,199
              30-34Total Households20009,941
              35-39Total Households200011,576
              40-44Total Households200012,016
              45-49Total Households200010,837
              50-54Total Households20009,416
              55-59Total Households20007,457
              60-64Total Households20006,013
              65-69Total Households20005,680
              70-74Total Households20005,421
              >75Total Households200010,061
              total usTotal Households2000102,584
              <25Owner Occupied20001,300
              25-29Owner Occupied20003,098
              30-34Owner Occupied20005,418
              35-39Owner Occupied20007,547
              40-44Owner Occupied20008,485
              45-49Owner Occupied20008,132
              50-54Owner Occupied20007,413
              55-59Owner Occupied20005,952
              60-64Owner Occupied20004,849
              65-69Owner Occupied20004,736
              70-74Owner Occupied20004,422
              >75Owner Occupied20007,872
              total usOwner Occupied200069,222
              <25Total Households20016,269
              25-29Total Households20018,113
              30-34Total Households200110,003
              35-39Total Households200111,255
              40-44Total Households200112,147
              45-49Total Households200111,199
              50-54Total Households20019,996
              55-59Total Households20017,604
              60-64Total Households20016,164
              65-69Total Households20015,585
              70-74Total Households20015,341
              >75Total Households200110,272
              total usTotal Households2001103,949
              <25Owner Occupied20011,414
              25-29Owner Occupied20013,161
              30-34Owner Occupied20015,488
              35-39Owner Occupied20017,379
              40-44Owner Occupied20018,597
              45-49Owner Occupied20018,449
              50-54Owner Occupied20017,818
              55-59Owner Occupied20016,156
              60-64Owner Occupied20015,040
              65-69Owner Occupied20014,603
              70-74Owner Occupied20014,406
              >75Owner Occupied20018,019
              total usOwner Occupied200170,529
              <25Total Households20026,394
              25-29Total Households20028,259
              30-34Total Households200210,210
              35-39Total Households200210,961
              40-44Total Households200211,879
              45-49Total Households200211,241
              50-54Total Households200210,158
              55-59Total Households20028,289
              60-64Total Households20026,443
              65-69Total Households20025,663
              70-74Total Households20025,155
              >75Total Households200210,667
              total usTotal Households2002105,320
              <25Owner Occupied20021,464
              25-29Owner Occupied20023,205
              30-34Owner Occupied20025,602
              35-39Owner Occupied20027,143
              40-44Owner Occupied20028,521
              45-49Owner Occupied20028,413
              50-54Owner Occupied20027,908
              55-59Owner Occupied20026,699
              60-64Owner Occupied20025,255
              65-69Owner Occupied20024,695
              70-74Owner Occupied20024,254
              >75Owner Occupied20028,359
              total usOwner Occupied200271,517
              <25Total Households20036,475
              25-29Total Households20038,257
              30-34Total Households200310,138
              35-39Total Households200310,834
              40-44Total Households200311,810
              45-49Total Households200311,401
              50-54Total Households200310,248
              55-59Total Households20038,595
              60-64Total Households20036,811
              65-69Total Households20035,599
              70-74Total Households20035,189
              >75Total Households200310,758
              total usTotal Households2003106,111
              <25Owner Occupied20031,477
              25-29Owner Occupied20033,289
              30-34Owner Occupied20035,728
              35-39Owner Occupied20037,055
              40-44Owner Occupied20038,420
              45-49Owner Occupied20038,600
              50-54Owner Occupied20037,986
              55-59Owner Occupied20036,952
              60-64Owner Occupied20035,581
              65-69Owner Occupied20034,621
              70-74Owner Occupied20034,258
              >75Owner Occupied20038,463
              total usOwner Occupied200372,428
              • 5. Re: How do I visualize this data?
                shreya agarwal

                Thanks much, Dan. This is really helpful.

                • 6. Re: How do I visualize this data?
                  Dan Eggleton

                  No problem.  Interesting data set.

                  • 7. Re: How do I visualize this data?
                    Patrick A Van Der Hyde

                    Shreya,

                     

                    I have marked Dan's answer as the correct one to assist others in finding the solution provided should someone else have a similar question. 

                    • 8. Re: How do I visualize this data?
                      shreya agarwal

                      Sure. Absolutely. Thanks.

                      • 9. Re: How do I visualize this data?
                        Chandra Bhaskar

                        Hi Shreya,

                         

                        Dan's  answer is correct..

                         

                        Can u pls send age wise raw data, it's clear me for more visualize...