Problem 3:Home Station Inc. is reviewing its weekly sales.

Problem 3:Home Station Inc. is reviewing its weekly sales. The sales data is reported by each department manager and can be found in HW1 Sales.txtfile. The owner wants to rotate the department managers in each of the store’s departments, so each manager becomes more familiar with the entire store’s operation. Your task is to determine the impact of rotating the managers on store sales by quarterly sales by department and by manager. You are to use Tableau application on this problem. If it is easier, rename your variables after connecting your text file to Tableau or import the data to Excel, then connect the Excel file to Tableau. Create the appropriate sheets to analyze the department sales by quarter. (Hint: You will need to readjust/regroup your data by quarters).1.Which department had the highest quarterly sales and in which quarter did it occur?(create sheet 1 with Department field in rows, Sales and Date fields in columns, Sales fieldwill re-adjust itself). Display your results using Text Tableoption.2.Which manager had the highest sales for each department? In which quarter did the manager’s highest sales occur? (create sheet 2 with Manager field in row, Department and Sales fields in columns). Display your results using Highlight Tablesoption.3.Which department resulted in the highest sales?(create sheet 3 Department field in columns, Manager and Sales fields in rows).Display your results using Box-and-whiskerplots option.4.From the above results, which manager would you choose to manage each department on a long-term basis? Support your recommendations with values from the Tables.5.Your results should be added to a Dashboard, give each sheet an appropriate name, print the dashboard to PDF using HW1LastnameFirstnameProblem3.Problem 4The file HW 1 2012FuelEcon.xlsxcontains 309 cases extracted from the U.S. Environmental Protection Agency’s 2012 Fuel Economy Guide data for 2012 model years cars and trucks. The variables include:•company that manufacturesthe cars•engine displacement (in liters) •fuel types (regular or premium gasoline)•type of wheel drive (A = all, F = front, R = rear)•fuel efficiency rating for highway driving in terms of miles per gallon (HWY MPG)Usingrisk value at 5%, youare to perform the following tasks:1.Perform descriptive statistics on the given variables. Comment on the results.2.Develop an estimated regression equation to predict the fuel efficiency for highway driving given the numerical independent variables. 3.Consider the categorial variables given, develop an estimated regression equation to predict the fuel efficiency for highway driving given all independent variables. (Hint: you will need to use dummy variables).4.Based on the above results(questions 1, 2, 3), give your comments, recommendations and conclusions.Note:For this problem, you can use either Excel or SPSS for your analysis.You are to address all regression assumptions in this problem (see Chapter 2 Slides-part 3).