Bolted joint statistical spreadsheet

A system and method for statistically analyzing a structural member design is provided to obtain a probability that the structural design will meet predetermined design criteria. The present invention provides for numerous spreadsheets, interrelated by way of a macro, to performing statistical analysis on a design, wherein one spreadsheet accepts design input variables. The design input variables are then evaluated by a number of recommended design criteria. If the design fails to meet the recommended design criteria, the user can establish the design (e.g., optimize it in one embodiment) using the optimization spreadsheet. The optimization spreadsheet established the structural member design by automatically adjusting various design inputs so that the structural member design satisfies as many design criteria as possible. Once the desired design input values are discovered, a probability spreadsheet uses random data points to calculate the probability that the structural member design will fail to meet the design criteria.