The local police department performs a crime analysis to determine which crimes are most likely to occur at which locations. The accompanying data file contains the types of crimes (CrimeType) that occurred at various locations (Location) in the city over the past five years.

a) Construct a contingency table that shows the frequencies for CrimeType and Location combinations. How many of the crimes were for burglary and happened in a residence? (3 points)

b) What percent of theft crimes occur in the street? (2 points)

c) What percent of crimes that occur in hotel/motel are battery? (2 points)

d) Construct a heat map displaying colors or intensity based on the frequencies. Which three crime types and location combinations are the most frequent ones? (3 points)