Checking the calculation formulas under scenario 2

This preview shows page 5 - 7 out of 7 pages.

Checking the calculation formulas under Scenario 2 (column D) and Scenario 3 (Column E) shows how the assumption parameter $B$5 stayed the same and the variable parameters are correctly referenced under each scenario column:Scenario 2:Scenario 3:
5.With the three scenarios set up, describe John’s situation in Scenario 2 and Scenario 3 so we can tell a brief story,to John, about the numbers selected in each of the ‘what-if’ scenarios.6.With scenarios and respective formulas created, we will conduct sensitivity analysis. Experiment with changing the Assumption Parameters (red), selecting one to change at a time, to higher and lower values and observe howthe changes impact the calculations (green) for each scenario. Ensure to change them back to their original values after conducting sensitivity analysis.Note: With the absolute references in the calculation formulas, changing a value in the Assumption Parameter should display changes in all of the scenarios results. Which assumption parameter has the greatest impact on John’s final savings? Which assumption parameter has e leleleleast impact?GradingSummary of DeliverablesThis completed document:oClassification exerciseoProblem statementoBrief story of each What-if cases in Scenario 2 and Scenario 3oSensitivity Analysis of the assumption parameters: least impact and greatest impactA completed version of the spreadsheet with formulas presentRubricThere are no 100% “right answers” for data modeling (otherwise we would be able to predict the future). Each component will be graded on overall quality and how each component supports each other and the overall model.QuestionWeightData Modeling/30Problem Statement/10Spreadsheet Engineering/20Formulas Setup/20What-if Scenario Descriptions/10Sensitivity Analysis/10

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture