What if analysis mac

The Solver add-in is similar to Goal Seek, but it can accommodate more variables. You can also create forecasts by using the fill handle and various commands that are built into Excel. For more advanced models, you can use the Analysis ToolPak add-in.

A Scenario is a set of values that Excel saves and can substitute automatically in cells on a worksheet. You can create and save different groups of values on a worksheet and then switch to any of these new scenarios to view different results. For example, suppose you have two budget scenarios: a worst case and a best case.

You can use the Scenario Manager to create both scenarios on the same worksheet, and then switch between them. For each scenario, you specify the cells that change and the values to use for that scenario. When you switch between scenarios, the result cell changes to reflect the different changing cell values. If several people have specific information in separate workbooks that you want to use in scenarios, you can collect those workbooks and merge their scenarios.

After you have created or gathered all the scenarios that you need, you can create a Scenario Summary Report that incorporates information from those scenarios.

A scenario report displays all the scenario information in one table on a new worksheet. Note: Scenario reports are not automatically recalculated. If you change the values of a scenario, those changes will not show up in an existing summary report. Instead, you must create a new summary report. If you know the result that you want from a formula, but you're not sure what input value the formula requires to get that result, you can use the Goal Seek feature. For example, suppose that you need to borrow some money.

You know how much money you want, how long a period you want in which to pay off the loan, and how much you can afford to pay each month. You can use Goal Seek to determine what interest rate you must secure in order to meet your loan goal. Note: Goal Seek works with only one variable input value.

If you want to determine more than one input value, for example, the loan amount and the monthly payment amount for a loan, you should instead use the Solver add-in. For more information about the Solver add-in, see the section Prepare forecasts and advanced business models , and follow the links in the See Also section. Goal Seek works differently from scenarios and data tables in that it takes a result and determines possible input values that produce that result.

Like scenarios, data tables help you explore a set of possible outcomes. Unlike scenarios, data tables show you all the outcomes in one table on one sheet. Using data tables makes it easy to examine a range of possibilities at a glance.

Because you focus on only one or two variables, results are easy to read and share in tabular form. A data table cannot accommodate more than two variables.

If you want to analyze more than two variables, you should instead use scenarios. Although it is limited to only one or two variables one for the row input cell and one for the column input cell , a data table can include many different variable values. A scenario can have a maximum of 32 different values, but you can create as many scenarios as you want. You can create one-variable or two-variable data tables, depending on the number of variables and formulas that you want to test.

Use a one-variable data table if you want to see how different values of one variable in one or more formulas will change the results of those formulas. For example, you can use a one-variable data table to see how different interest rates affect a monthly mortgage payment by using the PMT function. You enter the variable values in one column or row, and the outcomes are displayed in an adjacent column or row. For more information, see PMT function.

Input cell. List of values that Excel substitutes in the input cell, B3. Use a two-variable data table to see how different values of two variables in one formula will change the results of that formula. For example, you can use a two-variable data table to see how different combinations of interest rates and loan terms will affect a monthly mortgage payment.

Column input cell. List of values that Excel substitutes in the row input cell, B4. Row input cell. List of values that Excel substitutes in the column input cell, B3. Data tables are recalculated when a sheet is recalculated, even if they have not changed.

To speed up calculation of a sheet that contains a data table, you can change the Calculation options to automatically recalculate the sheet but not the data tables. A one-variable data table has input values that are listed either down a column column-oriented or across a row row-oriented.

Formulas that are used in a one-variable data table must refer to only one input cell. Type the list of values that you want to substitute in the input cell either down one column or across one row. Login Self-Study Courses. Financial Modeling Packages. Industry-Specific Modeling. Real Estate. Finance Interview Prep. Corporate Training. Technical Skills. View all Recent Articles. View Modeling Courses. Some final thoughts. Email provided.

Your Download is Ready. Inline Feedbacks. Minh Nguyen. July 13, am. I really would like to try it in numbers. Without a bit of information, though, it's difficult to build a map or even to suggest where to go looking for a map.

Any ideas how to perform what-if analysis? No, but at least that's enough information to go looking for a map, and may be enough information to bring about an 'Aha! That's what s he's talking about! A web search for ' simulation "monte carlo" ' did lead to this page , aimed at Excel users, but possibly applicable to Numbers. Sorry I can't be more helpful. Oct 22, AM in response to Barry In response to Barry Hey Barry, I think I didn't explain myself; the link you posted is about something I already know, I mean, I don't have any problems performing monte carlo simulation in excel.

It's just like the example in the link your posted. Anyway, I think it's just not possible in numbers I think because I haven't found any workaround. I think ms excel is just better for this kind of stuff.