Statistical analysis is now possible in Excel. Now when the “ Data” manu item is selected, there should be an option called “Data Analysis” on the far-right-hand side of the ribbon. You will be returned to the spreadsheet that you were working on. Step 3Ĭlick “OK” and the selected data packs will be installed. If a prompt says that the Analysis ToolPak is not currently installed on your computer, click Yes to install it. If Analysis ToolPak is not listed, click “Browse” to locate it. Choose “ Analysis ToolPak” and “ Analysis ToolPak – VBA” In the “ Manage” drop-down box at the bottom, select “ Excel Add-ins” and press “ Go…”Ī dialogue box will appear. In the menu, go to File > Options and then click on “ Add Ins” on the left-hand menu. In the Manage box, select Excel Add-ins and then click Go. Here are instructions for enabling Data Analysis in Excel 2010. Click the File tab, click Options, and then click the Add-Ins category. Microsoft Office’s Excel package contains a number of data-analysis tools for professionals who require an ability to perform sophisticated mathematical analyses of data. Instructions for adding the Data Analysis tool pack to Microsoft Excel
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |