Question 1:

Using the McNelson data, how many states have 9 or less unique districts?

Question 2:

What is the total 5 year sales revenue for zip code 44955?

Question 3:

What was the total 5 year revenue for Texas?

Question 4:

How many of the 346 schools listed in the McNelson data are located in

Idaho?

Question 5:

What percentage of the 346 schools listed in the McNelson data have a

graduation rate of 91% or higher?

Question 6:

Using 2019 sales data, Frank wants you to determine the school with the

lowest percentage of Buhi products sold to 9th grade male students. For your analysis,

compare the number of products sold to 9th grade male students at each individual

school to the total number of products sold to all grades and genders at each individual

school. Which school would you recommend (your answer should be the school's ID)?

Question 7:

What percentage of high school sales came from males in 2019?

Question 8:

What percentage of Willowcreek Middle School's students live within half-

mile of the school?

Question 9:

In 2019, what percentage of total products purchased across all grades

and genders were from zip code 43453?

Question 10:

Of the 346 schools listed in the McNelson data, how many schools are in

Pennsylvania and have a graduation rate of 91% or higher?