I am trying to come up with an approximate formula for the failure probability of an event which can be caused by four independent things.

I have a lot of measured data (100's of rows) of failure probability. Basically, I have a spreadsheet with these columns:

Failure Probability | Vendor | Distance | Continent | Configuration

Where vendor is one of five choices, distance is in km, continent is self explanatory, and configuration is one of three choices.


I am not quite sure where to begin on developing the formula that would have variables of the four header names (vendor, distance, continent, configuration) and output the failure probability.

Thanks for any help you can provide!