3. You are working for the esteemed HQ of Dunder-Mifflin Company, and they have asked for you to analyze and report on the performance of their various offices and sales team. Below you will find the sales data you received from accounting. [Total 20 points] a. Create a excel table from the raw sales date you received from accounting for you to do your analysis (Hint: often at work data you get will be a mess; check for errors/inconsistencies in the data and cleanup) b. Show a bar chart showing the annual sales of the salespeople, add data labels and then change data labels to $ format. c. Show a bar chart of the salespeople in the Scranton office with sales above $300,000 per year. d. Plot a bar chart of annual revenue of all offices, put data labels on the bars and do an error check for the Scranton office using a function. Compare the total annual revenue and costs of all the sales offices on one chart and write reason on why you chose that chart type and what message would you convey to your executives. Salesperson Office Customer Discount Sales $ \begin{tabular}{l|l|r|r|} \hline Column 1 & Column 2 & & Column 3 \\ \hline Scranton & $ & 1200000 \\ \hline Philadelphia & $ & 950000 \\ Allentown & $ & 820000 \\ \hline Elmira & $ & 710000 \\ \hline Binghamton & $ & 750000 \\ Grandtotal & $ & 4430000 \\ \hline \end{tabular}