The second group is designed to work as a standalone data analysis package. Enter the input range and the output range, and then select the options that you want. In the Analysis Tools box, click the tool you want to use. Access the data analysis tools To access the data analysis tools, follow these steps: On the Tools menu, click Data Analysis. 9 Analysis ToolPak: The Analysis ToolPak is an Excel add-in program that provides data analysis tools for. 8 Solver: Excel includes a tool called solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems. You provide the data and parameters for each analysis, and the tool uses the appropriate statistical or engineering macro functions to. If you need to develop complex statistical or engineering analyses, you can save steps and time by using the Analysis ToolPak. This is done by selecting Office Button > Excel Options > Add-Ins in Excel 2007 or File > Help|Options > Add-Ins in Excel 2010/2013, and clicking the Go button at the bottom of the window. If this option is not visible you may need to first install Excel’s analysis tool pack. This section illustrates the powerful features Excel has to offer to analyze data.

Quick analysis button excel 2016 mac