Excel Statistics ?

Discussion in 'OT Technology' started by oftpicbmwku1o, Sep 12, 2007.

  1. oftpicbmwku1o

    oftpicbmwku1o ...:] OT Supporter

    Joined:
    Oct 8, 2006
    Messages:
    57
    Likes Received:
    0
    Location:
    Lawrence, KS
    I have an excel sheet with a column asking gender with values of 1 or 2 and omit non response values. Then what they selected from a separate column with 3 conditions, I need to know the frequency of these conditions put into cells. What formula can I accomplish this with. Thank You for any responses
     
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Your question is way to convoluted to get a response other than... WTF?

    So here's what I suggest, you first tell us what you are really trying to do because there's probably a better way.

    Secondly, tell us what the result set should look like. It's much easier to reverse engineer that than decode the gibberish that you wrote.
     
  3. EvilSS

    EvilSS New Member

    Joined:
    Jun 11, 2003
    Messages:
    5,104
    Likes Received:
    0
    Location:
    STL
  4. oftpicbmwku1o

    oftpicbmwku1o ...:] OT Supporter

    Joined:
    Oct 8, 2006
    Messages:
    57
    Likes Received:
    0
    Location:
    Lawrence, KS
    Ok, yea I understand its pretty vague. I have a list of data from a survey one of the columns asks whether they are male our female and then write in 1 or 2 respectivly. Another column asks what their economic beliefs are 1 liberal, 2 conservative, 3 moderate. I need to find how many male and females chose 1 liberal 2 conservative 3 moderate.
     
  5. EvilSS

    EvilSS New Member

    Joined:
    Jun 11, 2003
    Messages:
    5,104
    Likes Received:
    0
    Location:
    STL
    Easy way?
    Make a copy of the file.
    Use the sort in excel to sort your data by male/female (1/2) (be sure to include both columns so the answers still match up after the sort)
    split the data by sex, copy and paste a few columns over
    Sort each set (male/female) by economic belief
    count (hint: excel will count rows when you highlight down a column).

    There are more "proper" ways to do it with the formulas a the site I listed, or you could also create a graph, but I think the above would be the fastest if it's not an insane amount of data.
     
  6. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    =COUNT(IF(($B$1:$B$7=1)*($C$1:$C$7=1),$C$1:$C$7))

    This assumes your data starts at row 1, ends at row 7, column B is sex, column C is pol views. When you enter the formula, enter Shift-Ctrl-Enter instead of just enter.

    This will find how many males are liberal. Change the formula to:

    =COUNT(IF(($B$1:$B$7=2)*($C$1:$C$7=3),$C$1:$C$7))

    to see how many females are moderate. Remember to hit S-C-Enter everytime you change the forumla.
     

Share This Page