**Unformatted text preview: **All random variables in this analysis can be modelled as normally distributed. Solution steps 1. Calculate standard deviation of random of the bias factors by using equation Standard deviation = mean value x COV 2. Simulate random numbers in between 0 and 1 in 4 columns for 4 random variables using command RAND(). In excel sheet, it is shown as U1, U2, U3 and U4. 3. Simulate Bias factor by using command NORMINV(probability,mean,standard_dev), In excel, it has been shown by Z1, Z2, Z3 and Z4. 4. Simulate P, B, D and L by multiplying Z1, Z2, Z3 and Z4 with corresponding nominal values respectively. 5. Calculate moment of inertia using I = BD 3 /12. 6. Now calculate maximum deflection using given equation. 7. Finally use AVERAGE() and STDEV() command to estimate mean and standard deviation of the maximum deflection....

View
Full Document

- Winter '18