Question 2 The consultancy is now interested in looking at the sales of shoes and pints in different countries. You obtain the data on consumption in England; Wales and Scotland. a. In the dataset r"pints and shoesarlsx\" there is a numerical variable called country where 1 is England; 2 is Wales and 3 is Scotland. Calculate the average price and quantity sold of shoes and pints per country. b. Plot the demand curve for pints per country. c. Use the data in \"pints and shoesxlsx", create one dummy variable per country. d. Use the data in \"pints and shoes.xlsx" to estimate the parameters of the following model: 3i = \"To 'l' 31px + 1322i "l' 335,- + 18414: + 3i where 31 is sales of shoes per individual, P1 is the average price of shoes paid per individual; 31 is the average price of pints paid per individual G; is a dummy variable equal to 1 if individual i is a Female and III otherwise A1 is a set of dummy variables per country. Introduce the set of country dummy variables in the model in a way in which you could interpret the results respect to England. Determine whether the coefficient ill; 132,133.134 are statistically different from zero at the signifiean ce levels of ll], {105 and ill. Interpret the results