Cruelty Free International is an organisation that works solely to end animal testing for cosmetic purposes. Michelle Thew, the Chief Executive of Cruelty Free International says that the EU cosmetics ban has been a huge victory for animals and we are already seeing a positive knock-on effect around the world.
up vote 1 down vote. There's a couple of ways you can do sensitivity analysis on Excel. You can use data tables or the scenario manager. It depends on the number of variables you want to change in the analysis and what sort of output you'd like.Check out the following posts to learn more about both the methods.http://awaisa.wordpress ....our problem is a more straightfoward sensitivity analysis. Data Tables are a simple way to flex inputs through a model for simultaneous outputs, 1 way (1 changing variable) and 2 way tables (flexing a table of paired row and column inputs) can be added easily. 1  http://www.homeandlearn.co.uk/excel2007/excel2007s7p1.html.
You can use Excel's Goal Seek feature to find the answer. 1. On the Data tab, click What-If Analysis, Goal Seek. The Goal Seek dialog box appears. 2. Select cell D10. 3. Click in the 'To value' box and type 4700. 4. Click in the 'By changing cell' box and select cell C4. 5.Click OK.ext, select cell D10 (total profit) for the result cell and click on OK. Result: Conclusion: if you sell 70% for the highest price, you obtain a total profit of $4100, if you sell 80% for the highest price, you obtain a total profit of $4400, etc. That's how easy what-if analysis in Excel can be.