Skip to main content

Whatif analysis

What if whatif analysis?

Sometimes it is also known as sensitivity analysis is a tool and way to calculate value of a formula in Microsoft Excel or OpenOffice based on different scenarios (different values). For an example if unit price of an item is 100 and you have a table with unit price, number of items and total value of all the items, you can create different scenarios to calculate total price based on different number of items.

Unit price

100

No of items

1

Total value

100


Using whatif analysis you can

    • Analyse results based on different values of changing variables for example cost of travel based on miles and or type of vehicle used etc.

    • If you want to see how will you get a desired results you can use Goal Seek

    • See the effects of one or two variables on a formula using data tables.

    • Prepare forecasts and advanced business models

    • It is different in Microsoft Excel and OpenOffice, here I am presenting an example in OpenOffice and after that I will give some links for Microsoft Excel examples

What-If Analysis in Microsoft Excel

The What-If Analysis tool in Microsoft Excel works a bit differently compared to other tools.

Using Scenario Manager:

  1. Take a table with three columns (or any dataset).
  2. Select the cell or cells you want to analyze (even a single cell can be selected).
  3. Go to Data > What-If Analysis > Scenario Manager.
  4. A new dialog box will appear. Click Add to create a new scenario.
  5. In the Add Scenario dialog, enter a name for your scenario.
  6. Select the changing cells (by default, the cell you selected earlier will be chosen).
  7. Click OK, and another dialog box titled Scenario Values will appear.
  8. Enter the value for this scenario and click OK.
  9. Repeat steps 4 through 8 to add multiple scenarios.
  10. To view the results of each scenario, select it in the Scenario Manager and click Show.
  11. Click the Summary button in Scenario Manager to generate a report. You will get an option to choose either:
    • Scenario Summary – Displays a table with values for all scenarios.
    • Scenario PivotTable Report – Creates a pivot table showing changing values and corresponding calculated results in different rows.

Examples of What-If Analysis in Microsoft Excel:

 

Comments

Post a Comment

Popular posts from this blog

Virtual environments in python

 Creating virtual environments is essential for isolating dependencies and ensuring consistency across different projects. Here are the main methods and tools available, along with their pros, cons, and recommendations : 1. venv (Built-in Python Virtual Environment) Overview: venv is a lightweight virtual environment module included in Python (since Python 3.3). It allows you to create isolated environments without additional dependencies. How to Use: python -m venv myenv source myenv/bin/activate # On macOS/Linux myenv\Scripts\activate # On Windows Pros: ✅ Built-in – No need to install anything extra. ✅ Lightweight – Minimal overhead compared to other tools. ✅ Works across all platforms . ✅ Good for simple projects . Cons: ❌ No dependency management – You still need pip and requirements.txt . ❌ Not as feature-rich as other tools . ❌ No package isolation per project directory (requires manual activation). Recommendation: Use venv if you need a simple, lightweight solut...
Post a Comment
Read more

Building a Simple Text Generator: A Hands-on Introduction

Introduction Text generation is one of the most exciting applications of Natural Language Processing (NLP) . From autocorrect and chatbots to AI-generated stories and news articles , text generation models help machines produce human-like text. In this blog post, we’ll introduce a simple yet effective text generation method using Markov Chains . Unlike deep learning models like GPT, this approach doesn’t require complex neural networks—it relies on probability-based word transitions to create text. We’ll walk through: ✅ The concept of Markov Chains and how they apply to text generation. ✅ A step-by-step implementation , fetching Wikipedia text and training a basic text generator. ✅ Example outputs and future improvements. The Concept of Markov Chains in Text Generation A Markov Chain is a probabilistic model that predicts future states (or words) based only on the current state (or word), rather than the full sentence history. How it works in text generation: 1️⃣ We analyze a gi...
Post a Comment
Read more

Mastering Trade-Off Analysis in System Architecture: A Strategic Guide for Architects

 In system architecture and design, balancing conflicting system qualities is both an art and a science. Trade-off analysis is a strategic evaluation process that enables architects to make informed decisions that align with business goals and technical constraints. By prioritizing essential system attributes while acknowledging inevitable compromises, architects can craft resilient and efficient solutions. This enhanced guide provides actionable insights and recommendations for architects aiming to master trade-off analysis for impactful architectural decisions. 1. Understanding Trade-Off Analysis Trade-off analysis involves identifying and evaluating the conflicting requirements and design decisions within a system. Architects must balance critical aspects like performance, scalability, cost, security, and maintainability. Since no system can be optimized for every quality simultaneously, prioritization based on project goals is essential. Actionable Insights: Define key quality ...
Post a Comment
Read more