URGENT! Please help me answer these questions!!!

[fu_chowder]

How to create formulas in excel to answer these questions:

1. Where is the best place to open a gym?
2. Where is the best place to look for a prospective boyfriend or girlfriend?
3. Do women earn less than men?

Using an excel data sheet that lists: age, weight, income, paytype, carvalue, gender, if the person lives alone or not, if the person lives in (house/condo/apt), and how many mall trips they take.


PLEASE HELP! PLEASE HELP!

 

[Expiry]

Before you create the formula, you need to know how you're trying to measure this, ie. what is your criteria.

Are you wanting to open a gym near to people that are overweight, ie. they need it, or near people that are not overweight, ie. they'll probably use it.

The formula is the last bit. It's the logic and reasoning that you need to work out, first.

 

[fu_chowder]

there can be many different answers, but im having trouble how and which formulas to use to solve them.

Any thoughts how you would solve these questions? explanation would be very helpful

 

[crusader]

Your comments seem to indicate you are seeking analysis on opening a business. The first step would be collect relevant data. Putting that data on a spreadsheet would be the next step.

First, get the data and then worry about the formulas. If you have the data, please provide more specifics and assistance will be forthcoming...