Conducting a Sensitivity Analysis with Multiple Operations
Although the command name “Multiple Operations” is not particularly descriptive, this feature enables you to do a sensitivity analysis of data in a spreadsheet. In a nutshell, a sensitivity analysis allows you to place a function (or formula in a spreadsheet) and then view the different outcomes that are provided when you vary the input to the function. For example, you could use the function PMT, which uses the rate (for a monthly payment remember to divide the rate by 12 in the function), number of payments, and the principal on a loan, to create an analysis sheet that shows you the different payment amounts at different car prices. Since a sensitivity analysis allows you to vary two ...
Get StarOffice™ 5.2 Calc Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
