+ Reply to Thread
Results 1 to 3 of 3

Filling in cells when you only know row and column totals?

  1. #1
    Registered User
    Join Date
    07-05-2011
    Location
    Indianapolis
    MS-Off Ver
    Excel 2007
    Posts
    2

    Filling in cells when you only know row and column totals?

    I'm trying to combine two Census features, and my algebra is a bit rusty. I have a table with "Household Type" in 5 columns across the top and "Age of Householder" in three rows on the left. I have entered the total for every row and every column - now how do I calculate the value in each cell? I'm not sure this is possible because there may be more than one possible solution, but I'm hoping someone has an answer here. THANKS in advance for any guidance that can be offered.

  2. #2
    Valued Forum Contributor
    Join Date
    10-06-2008
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    365

    Re: Filling in cells when you only know row and column totals?

    Hi, you are off course right it can be more than one possible solution.
    You can however estimate the value of each cell, as far as I can understand that will be on the condition that there is no statistical connection between the two variables mentioned and the dependent variable:
    Each cells value will then be
    "Sum Row" * ("Sum Column" / "Total Sum")

  3. #3
    Registered User
    Join Date
    07-05-2011
    Location
    Indianapolis
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Filling in cells when you only know row and column totals?

    Thanks, that's exactly what I was using. Demographics is an inexact science - we break it down as much as we can and maintain the whole. Thanks for the help estige!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1