ADM 1370 Lecture Notes - Lecture 2: Relational Database Management System, Affinity Analysis, Mapreduce

• School: University of Ottawa
• Department: Administration
• Course: ADM 1370
• Professor: Craig Kuziemsky

Document Summary

What-if analysis: the study of how the uncertainty in the output of a model can be attributed to different sources of uncertainty in the model inputs. Using a spreadsheet, what-if analysis involves changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet. What-if analysis tools in excel include: scenarios, goal seek, data tables. Solver: an add-in program that searches for the best solution to a problem with several variables. Used to find the best way to allocate resources. Requires three parameters: target cell typically contains a formula that is directly or indirectly based on the adjustable cells and constraints: Dependent variables and independent variables need to be formulated appropriately: adjustable cells are the cells whose values are adjusted until the constraints are satisfied, constraints specify the restrictions: Typically in the form of inequalities or equations.