please show me the answer and step how to do it!

125% + T M MATH 205 - Assignment 1 Section 1: Review of the Basics of Statistics This assignment deals with topics covered in Weeks 2, 3, and 4. Each Question can also be found in the textbook - and is accompanied in the table by page references from the chapter where a similar example is shown. Marks Page Question Question Reference # 2 Review of Stats 1. Open the Salesum document, and add functions to calculate the average, Max, Min and Count on rows 18-21 in columns B-E. 2. In Cell B25 type an answer to the following question: Is the average computed in B18- E18 a good predictor of how much a new expense might cost, should we incur a new expense next year? Why or why not? Save the document on your computer as FirstNameLastNameSalesum.xIs. 4 Review of Stats 1. Continuing with your Salesum. xIs document, copy the titles in cells B6:E6 and paste them into cells B9:E9. Select cells A9:E15. Press the F11 key at the top of your keyboard to create a bar chart. 3. Re-arange the chart if required so that the months (Jan-Apr) appear on the bottom axis of the chart, and the Legend contains the expenses. 4. Add a trendline to the chart for the "Salaries' expense. 5. Right click on the trendline to add the option of showing the trendline equation on the chart as well. 6. Copy and paste this equation into cell B27 of Sheet 1. 7. In cell B28, type the predicted value for August for the salaries expense based on this equation to show your understanding of it. For the rest of this assignment, create a Word document to type your answers to each question. Save the document as FirstNameLastNameAssignment1. doc. You will upload both of these files using the 'Browse' button at the bottom of the assignment to submit your assignment. Alternatively, with extremely legible handwriting I will accept scanned pages of your hand written assignment in a PDF document. 4 Ch.7-10 3 Ch. 7-14 3 Ch. 7-32 4 Ch. 7-34 5 Ch. 10-2Sales/Expense Summary Sales Increase 7% Expense Increase 10% Jan Feb Mar Sales 600,000 642,000 686,940 Apr 735,025.8 Expenses: Salaries 325,00 357,500 393,250 432.575 Travel 100,000 110,000 121,000 67,760 133,100 Advertising 56,000 61,600 Dues 1,500 74.536 Postage 2,370 1,650 2.607 1,815 1,996.5 2,867.7 Utilities 3.400 3,740 3.154.47 4,114 Total Expenses 188,270 537,097 4,525.4 590,806.7 649,887.37 Average Expense Maximum Expense Minimum Expense Count of Expenses Gross Profit Sheet1 Sheet2 Sheet3