HOW TO USE ANALYSIS TOOLPAK EXCEL 2016 INSTALL

If you get prompted that the Analysis ToolPak is not currently installed on your computer, select Yes to install it.If Analysis ToolPak is not listed in the Add-ins available drop-down list, select Browse to locate it.In the Add-ins available box, check the Analysis ToolPak box, and then select OK.Select Add-Ins, and then in the Manage box drop-down list, select Excel Add-ins, then select Go.Select the Microsoft Office button or the File tab, and then select Excel Options/ Options.N.B: If the Data Analysis option is not installed, you can install it by following the instructions below: Select the Data tab and Data Analysis as per screen shot below.

The screen shot below will be used for this example.ġ. Note: You are welcome to download the sample workbook to practice this exercise. This tool selects a random sample from your range of values (a sample being a portion of the whole range), therefore ensuring that your competition winner has been chosen with integrity. An example of this is the following say your marketing team is running a lucky draw competition and needs your help in selecting a winner by random, you can use the Sampling Analysis tool to ensure that this winner is selected without favour. The Sampling Analysis Tool is great for when you need to randomly select a number from a given range of values. This week’s tip is especially handy when running competitions for your business, so please share it with your promotions and marketing teams.

How to use analysis toolpak excel 2016