Questions
Discuss among the team and come up with five distinct question classes relevant to the Yelp dataset.
Here is a simple question class provided as an example that has only one variable.
How many businesses have more than X review counts?
Three example of specific questions in this class are:
- How many businesses have more than 1000 review counts?
- How many businesses have more than 500 review counts?
- How many businesses have more than 100 review counts? Come up with five additional question classes. Each must have two or three variables.
What percentage of businesses in city X have a rating higher than Y stars?
Three example of specific questions in this class are:
- What percentage of businesses in Phoenix have a rating higher than 1 star?
- What percentage of businesses in Detroit have a rating higher than 4 stars?
- What percentage of businesses in Denver have a rating higher than 3 stars?
What percentage of businesses in category X with a rating lower than Y stars are still in business?
Three example of specific questions in this class are:
- What percentage of restaurants with a rating lower than 2 stars are still in business?
- What percentage of doctors with a rating lower than 2 stars are still in business?
- What percentage of bars with a rating lower than 3 stars are still in business?
What is the amount of business type X in city Y?
Three example of specific questions in this class are:
- What is the amount of restaurants in Denver?
- What is the amount of garages in Philadelphia?
- What is the amount of cobblers in New York City?
At time X what businesses are open in city Y?
Three example of specific questions in this class are:
- At 9 AM, what businesses are open in Boston?
- At 4 AM, what businesses are open in Boulder?
- At 12 AM, what businesses are open in Aspen?
At time X on day Y, how many businesses are open in state Z?
Three example of specific questions in this class are:
- At 17 on Monday, how many businesses are open in AZ?
- At 19 on Monday, how many businesses are open in AZ?
- At 21 on Monday, how many businesses are open in PA?