Category Archives for Sensitivity Analysis

Easy One-Way Sensitivity Analysis on Weighted Sum Models in Excel (Part 2)

May 17, 2012
/ Advanced Excel Analysis Dashboards Math No VBA Sensitivity Analysis
/ By Jordan Goldmeier

Wow, it’s been a while since my last article. I’ve actually been pretty busy the last few weeks putting the finishing touches on an Excel deliverable for one of my company’s clients. We delivered the product about a week ago and things have just now started to slow. So now it’s back to blogging. If […]

Easy One-Way Sensitivity Analysis on Weighted Sum Models in Excel (Part 1)

April 15, 2012
/ Advanced Excel Analysis Dashboards Math No VBA Sensitivity Analysis
/ By Jordan Goldmeier

This article describes what I like to call “Easy One Way Sensitivity Analysis” in Excel. I’ve used it before in several dashboards. If you want to try it out for yourself before reading ahead, both Healthcare dashboards on the Fun Downloads page implement my Easy One Way Sensitivity Analysis method. Here’s a pic of one of […]