To enable the Data Analysis tool in Excel, go to the File menus Options tab.

Once we get the Excel Options window, from Add-Ins select any of the analysis pack, lets say Analysis Toolpak and click on Go.

This will take us to the window from where we can select one or multiple Data analysis tool packs which can be seen in the Data menu tab.

Usually, data analysis tool pack is available under the Data tab.

Look at the below data of two teams scoring pattern in the tournament.

As of now, I dont know how much units price I have to increase.

Since I dont have any other special criterias to test I am clicking on the SOLVE button.

To make a profit of 30000 I need to sell the products at 11 per unit instead of 10 per unit.

Data Analysis For Excel On How To Use The

Here we discuss how to use the Excel Data Analysis Tool along with excel examples and downloadable excel template.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

Data Analysis For Excel On Mac