An EXCEL Add-in Implementation for Collocation-Based Stochastic Response Surface Method

Bin Liang,Shan Huang,Kok‐Kwang Phoon
2007-01-01
Abstract:A general probabilistic method called collocation-based stochastic response surface method (CSRSM) was developed previously. It involves the propagation of input uncertainties through a computation model to arrive at a random output vector. It is assumed that the unknown random output can be expanded using a polynomial chaos basis with corresponding unknown coefficients. The unknown coefficients are evaluated using a collocation method because it has the important practical advantage of allowing existing deterministic numerical codes to be used as black boxes. An EXCEL add-in is developed to produce the basis functions (multi-dimensional Hermite polynomials) without resorting to symbolic algebra practitioners. This is a major practical advantage that would bring realistic probabilistic analyses within reach of the practitioners. Full EXCEL implementation details are illustrated using a simple slope problem involving six input random variables. The results show the ease and successful implementation of the proposed EXCEL-based CSRSM.
What problem does this paper attempt to address?