business analytics

Question 1 sheet Filter the sales data to show only sales for the south region and then sort from highest to lowest Question 2 sheet use conditional formatting to highlight the top 10% of values and the bottom 10% of values Question 3 sheet calculate the bill equation of the line that best matches the data Question 4 sheet Use a What-If analysis to determine the price change you would need to make to produce a profit of $1,000. Question 5 sheet Forecast sales with 90% confidence interval Question 6 sheet create a pivot table that shows sales by salesperson per month Write a managerial report based on the results of the analyses performed. Each chart/table should have an informative title. Feel free to update design/theme/color scheme for results obtained. Copy & paste each chart/table neatly into Word. A brief description/explanation should accompany each chart/table