Question

Install the Analysis Tool Pak on your computer. Find any dataset online in the public domain. Copy around 15-20 into Excel, and then create a randomized data set.

Answer 1

First :

Steps to load and activate the Analysis ToolPak

1. Click the File tab, click Options, and then click the Add-Ins category.
2. In the Manage box, select Excel Add-ins and then click Go.
3. In the Add-Ins box, check the Analysis ToolPak check box, and then click OK.

Second :

Find a dataset online or download any dataset from kaggale.com or from data.gov.in

​​​​​​​​​​​and paste dataset into excel. Many dataset are available in excel as well as another format.

Third :

• After you load the Analysis ToolPak, the Data Analysis command is available in the Analysis group on the Data tab. Also excel sheet of dataset is open.
• Select the Data Analysis command . Go to data Tab and then click on Data Analysis.
• Select Sampling and then OK.
• Then select or type in the Input Range, Number of Samples and Output Range. Select OK.

Above steps for create a random dataset in excel.

​​​​​​

​​