B ITM 215 Information Lecture Notes - Lecture 12: Dialog Box
Document Summary
Itm 215 - lecture 12 - what-if analysis. Goal seek is a method for finding solutions to problems by working backwards from the end result to determine the input to produce that result. By doing so, you can test different input values for a formula without having to retype or copy the formula for each value. One-variable data tables: a data table organizes the results of several what-if analyses within a single table. Insert a formula that references the input cell in the upper-left cell of the table. When setting up a one-variable data table, you must decide which value to manipulate. Create a two-variable data table: a two-(cid:448)aria(cid:271)le data ta(cid:271)le a data analysis tool that provides results based on changing two variables, with a two-variable data table, you can compare results for two variables. For instance, you can compare how different interest rates and different down payments impact the monthly car payment.