if else programming

Given P10-P50-P90 points from a distribution, how can we sample from that distribution. Create presentation quality cumulative distribution graphs (CDFs) of the distribution using SIPMath

Interview of Brian Putt by Alexei Sidorenko about Decision Analysis and Decision Quality. Wide ranging discussion covering from Framing to Analysis. Includes thought about implementation in a company

Value of Information (VOI) is often evaluated using decision trees. Using SIPmath we can calculate the value of information and also determine the Distribution of the Value of Information. Video takes a case example and walks through the example and analysis. Excel file is available at: https://1drv.ms/x/s!AgtEj5D79IYqgb4iQ...

Part 2 - Working only with Excel we optimize the ticket price for the reference case and compare that to the optimized decision policy and ticket prices with perfect and imperfect information. Evaluation conduced using simulation and Excel Solver rather than using decision trees.

This is the epilogue to 2 previous videos that evaluated the optimum price for concert tickets when we consider uncertainty in demand and cost using SIPmath. The epilogue updates the model, discusses why the triangular distribution was used and then shows how survey results can be utilized to determine a probabilistic demand profile for the tickets. The objective of the series is to demonstrate good Decision Quality practices. Excel file available at : https://1drv.ms/x/s!AgtEj5D79IYqgb4fM...

Describes a 10 period model that considered probabilistic demand to optimize the order quantity. Analysis is shown and the impact of using an order quantity that is not optimal. A copy of the model is available at https://1drv.ms/x/s!AgtEj5D79IYqgd0yX... or contact me at brian@theputts.com

This video extends the first video to include adding decisions to the model, probabilistic demand forecast and optimization Excel Solver. Excel model available at : https://1drv.ms/x/s!AgtEj5D79IYqgb4fM... . The model could have been done in Crystal Ball but instead utilized the free SIPmath Tools from Probability Management.

Working only with Excel we optimize the ticket price for the reference case and compare that to the optimized decision policy and ticket prices with perfect and imperfect information. Evaluation conduced using simulation and Excel Solver rather than using decision trees.

Part 3 - Working only with Excel we optimize the ticket price for the reference case and compare that to the optimized decision policy and ticket prices with perfect and imperfect information. Evaluation conduced using simulation and Excel Solver rather than using decision trees.

Discusses that uncertainties should be considered in our personal decisions. Example of Strategy table and discussion of probabilistic results for example problem of replacing a roof. Excel file available at: https://1drv.ms/x/s!AgtEj5D79IYqgbUmt...

Video describes how to set up an Excel model to evaluate the profit for holding a concert at high school. Excel file available at: https://1drv.ms/x/s!AgtEj5D79IYqgb4fM... . The probabilistic analysis is done using the free SIPmath Tool bar from www.probabilitymanagement.org. Includes instructions on how to install the SIPmath Tool Bar.

This is the epilogue to 2 previous videos that evaluated the optimum price for concert tickets when we consider uncertainty in demand and cost using SIPmath. The epilogue updates the model, discusses why the triangular distribution was used and then shows how survey results can be utilized to determine a probabilistic demand profile for the tickets. The objective of the series is to demonstrate good Decision Quality practices. Excel file available at : https://1drv.ms/x/s!AgtEj5D79IYqgb4fM...

Describes a 10 period model that considered probabilistic demand to optimize the order quantity. Analysis is shown and the impact of using an order quantity that is not optimal. A copy of the model is available at https://1drv.ms/x/s!AgtEj5D79IYqgd0yX... or contact me at brian@theputts.com

This video extends the first video to include adding decisions to the model, probabilistic demand forecast and optimization Excel Solver. Excel model available at : https://1drv.ms/x/s!AgtEj5D79IYqgb4fM... . The model could have been done in Crystal Ball but instead utilized the free SIPmath Tools from Probability Management.

Working only with Excel we optimize the ticket price for the reference case and compare that to the optimized decision policy and ticket prices with perfect and imperfect information. Evaluation conduced using simulation and Excel Solver rather than using decision trees.

Part 3 - Working only with Excel we optimize the ticket price for the reference case and compare that to the optimized decision policy and ticket prices with perfect and imperfect information. Evaluation conduced using simulation and Excel Solver rather than using decision trees.

Discusses that uncertainties should be considered in our personal decisions. Example of Strategy table and discussion of probabilistic results for example problem of replacing a roof. Excel file available at: https://1drv.ms/x/s!AgtEj5D79IYqgbUmt...

Video describes how to set up an Excel model to evaluate the profit for holding a concert at high school. Excel file available at: https://1drv.ms/x/s!AgtEj5D79IYqgb4fM... . The probabilistic analysis is done using the free SIPmath Tool bar from www.probabilitymanagement.org. Includes instructions on how to install the SIPmath Tool Bar.