Page 221 - TP_IT_V1.0_C10_flipbpookl
P. 221

•  One-Input What-If Analysis: One-input What-If analysis allows you to examine how changes in a single input variable
                   impact the outcome of a formula or calculation. You typically set up a column or row of cells containing different
                   values for the input variable, and then observe how these changes affect the result of a formula elsewhere in the
                   spreadsheet. For example, if you are analysing the impact of interest rates on loan payments, you might vary the
                   interest rate across a range of values to see how it affects the monthly payment.
                 •  Two-Input What-If Analysis: Two-input What-If analysis extends this concept to explore the effects of changes
                   in two input variables on the outcome of a formula or calculation. You set up a grid of cells containing different
                   combinations of values for the two input variables, and observe how changes in both variables simultaneously
                   affect the result of the formula. For example, if you are analysing the impact of both interest rates and loan terms
                   on monthly payments, you might vary both variables across a grid to see how different combinations affect the
                   payment amount.
                 What-if tool uses Data  Multiple Operations and is a planning tool for what-if questions. The Multiple Operations
                 tool creates a formula array to display the list of results applying the formula on a list of alternative values used in the
                 formula. This tool uses two arrays of cells, one array contains the input values and the second array uses the formula
                 and display the result. This What-if analysis tool is very helpful when we want to know how much profit we earn for a
                 particular product for a series of selling units.
                 Let us take an example to conduct an analysis with one input variable. Suppose you run a café where you sell sandwiches
                 for `8 each. It costs you `3 to make each sandwich. On top of that, you have fixed monthly expenses of `2000. How
                 would your monthly profit or loss be affected by the number of sandwiches sold?

                 To conduct an analysis with one input variable, perform the following steps:
                 Step 1:   Enter  data in a sheet that is used to calculate  the monthly profit  or loss  be  affected by  the number of
                         sandwiches sold.

                 Step 2:  Click on the cell B6 and type the =B5*(B2-B3)-B4 formula to calculate the profit or loss.















                 Step 3:  Press the Enter key. The output of the formula is displayed in cell B6.

                 Step 4:  Enter input values on the basis of which the output is to be generated using the formula.
                 Step 5:  Select the cell range for input values and output values.





















                                                                      Electronic Spreadsheet (Advanced) using LibreOffice Calc  219
   216   217   218   219   220   221   222   223   224   225   226