The file DVDExcel.xlsx contains a large data set of 10,000 customer transactions for a fictional chain of video stores in the United States. Each row corresponds to a different customer and lists

• (1) a customer ID number (110,000),
• (2) the state where the customer lives,
• (3) the city where the customer lives,
• (4) the customer's gender,
• (5) the customer's favorite type of movie (drama, comedy, science fiction, or action),
• (6) the customer's next favorite type of movie,
• (7) the number of times the customer has rented movies in the past year, and
• (8) the total dollar amount the customer has spent on movie rentals during the past year.

The data are sorted by state, then city, then gender. We assume that this data set represents the entire population of customers for this video chain.

Imagine that only the data in columns A through D are readily available for this population. The company is interested in knowing the following information.

• Analyze the customer demographics.
• Compute the percentage of customers in CA, NY and TX.
• What cities in CA, NY and TX have the largest number of customers? For CA, NY and TX, what percentage of the customers are in the city with the largest number of customers?
• The number of males and females in CA, NY and TX who favor each of the different movie types.
• The relationship between the number of times the customer has rented movies in the past year, and the total dollar amount the customer has spent on movie rentals during the past year.
• Observations about this company, the stores and customers.

Important Notes:

please explain thoroughly for understanding.