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. Here are instructions for enabling Data Analysis in Excel 2010. 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.
The Data Analysis ToolPak is added from the Office menu. Instructions for adding the Data Analysis tool pack to Microsoft Excel How to Load the Microsoft Excel Data Analysis ToolPak: Excel 2007-2010.
0 kommentar(er)
