Hello.
I have a problem where I have to gauge correlation between three different variables which are age, interest and ***. What would be the best way to find out whether i.e 20 to 30 males are interested in this product?
Thank you.
Hello.
I have a problem where I have to gauge correlation between three different variables which are age, interest and ***. What would be the best way to find out whether i.e 20 to 30 males are interested in this product?
Thank you.
Given a list of age, interest and s*x in columns A B and C
=COUNTIFS(A1:A1000,">=20",A1:A1000,"<=30",C1:C1000,"Male",B1:B1000,D1)
will return number of males aged 20 to 30 with an interest in a specific product held in D1
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks