You should be confident with accessing the Analysis ToolPak in Excel 2019, specifically for the quick analysis of financial, statistical, and engineering data. We will use the ToolPak to obtain the descriptive statistics of a range of weather data in a workbook and look at how to use the what-if analysis tools such as Goal Seek and Scenario Manager.
The tools in the Analysis ToolPak in Excel 2019 are used to gain more statistical scrutiny from your worksheet data. If you are not used to creating complex formulas in Excel, but you need to perform statistical t-tests or chi-square tests and/or correlations, then the Analysis ToolPak has the answers without having to waste valuable time trying to recreate these formulas.
