# Excel Statistics ?

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

1. ### oftpicbmwku1o...:]OT Supporter

Joined:
Oct 8, 2006
Messages:
59
4
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_PreludeThere might not be an "I" in the word "Team", but

Joined:
Mar 14, 2000
Messages:
14,523
9
Location:
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.

Joined:
Jun 11, 2003
Messages:
5,103
0
Location:
STL
4. ### oftpicbmwku1o...:]OT Supporter

Joined:
Oct 8, 2006
Messages:
59
4
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. ### EvilSSActive Member

Joined:
Jun 11, 2003
Messages:
5,103
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.

Joined:
Mar 14, 2000
Messages:
14,523
9
Location: