The requested work in this mini-project assumes that you are familiar with what were done in the checkpoint assignments of your term project. Note that I will answer all questions regarding your term project, and will not provide help on this mini-project. It is expected that by actively doing the work in the term project, you are able to show your skills here again with a different dataset with the same structure. Please complete the following: 1)You are given a transaction dataset that is very similar to the one in your term project, but it is smaller – all the variables names have the same meaning. Please complete the industry analysis (on industry level sales trend across 3 years, seasonality, pricing pattern, and channel use). Please state the industry name at the top of your file. (20 marks) 2)Please identify the top 3 companies and compare their sales trends, pricing patterns, channel uses on a monthly basis. (20 marks) 3)Please add zipcode level median income information to this dataset (with a vlookup function), and then describe each of the top 3 companies’ customer base. Which of them are selling to relatively more affluent neighborhood? (20 marks) 4)Please use each of the top 3 companies’ 2005 data (the 2005 cohort of customers) and label their top/median/low spenders using an M-code (you need to do this one by one for each company). a.For the 2006-07 period, what proportion of sales were from old vs. new customers for each firm? Please also show a few screenshots of your work in Excel on how you get the numbers to answer this question. (20 marks) b.For the 2006-07 period, where did each firm’s top spenders go? Did they leave the industry? Or they were still buying but just buying from others?