Database Analytics: "Car Discount" file posted on Canvas has data on the discount the customer receives, the gender of the customer along with other variables. Use this data set to perform the following: Count the number of customers with income greater than $40,000. Count the number of customers who are male, and those who are females. a. b. C. Count the number of customers who are male and older than 40 years old. d. Sort the data by the amount of discount the customer receives, largest to smallest. e. Using Excel's filter function to extract the following: 1. All female customers with discount of $1,500 or more. 2. All male customers with income greater than $30,000 who got a discount of $1,000 or more. f. Using Excel's IF function, classify the amount of discount the customer receives based on the following: If the discount is less than $1,000, classify it as low. If the discount is between $1,000 and $2,000, classify it as medium. If the discount is greater than $2,000, classify it as high.

Database Analytics: "Car Discount" file posted on Canvas has data on the discount the customer eceives, the gender of the customer along with other variables. Use this data set to perform the following: a. Count the number of customers with income greater than $40,000. b. Count the number of customers who are male, and those who are females. c. Count the number of customers who are male and older than 40 years old. d. Sort the data by the amount of discount the customer receives, largest to smallest. e. Using Excel's filter function to extract the following: 1. All female customers with discount of $1,500 or more. 2. All male customers with income greater than $30,000 who got a discount of $1,000 or more. f. Using Excel's If function, classify the amount of discount the customer receives based on the following: If the discount is less than $1,000, classify it as low. If the discount is between $1,000 and $2,000, classify it as medium. If the discount is greater than $2,000, classify it as high. Database Analytics: "Car Discount" file posted on Canvas has data on the discount the customer eceives, the gender of the customer along with other variables. Use this data set to perform the following: a. Count the number of customers with income greater than $40,000. b. Count the number of customers who are male, and those who are females. c. Count the number of customers who are male and older than 40 years old. d. Sort the data by the amount of discount the customer receives, largest to smallest. e. Using Excel's filter function to extract the following: 1. All female customers with discount of $1,500 or more. 2. All male customers with income greater than $30,000 who got a discount of $1,000 or more. f. Using Excel's If function, classify the amount of discount the customer receives based on the following: If the discount is less than $1,000, classify it as low. If the discount is between $1,000 and $2,000, classify it as medium. If the discount is greater than $2,000, classify it as high