Excel Sensitivity Testing

We also have Free training videos on this site ( visit the Home page or the Training Page)

A few basics of Excel sensitivity testing are shared below. The Excel sensitivity testing can indicate which inputs will have the maximum consequences for the outcomes. It can also be used to assess whether a model is practical since users will normally have a general notion of what the outcome can be if they make an alteration.

Excel sensitivity testing can be used to assess the accuracy of a model. For example an enterprise has a specific model and needs to ensure a specific accuracy range for their budget. The test may indicate that the hypothesis with the most severe consequence is the asset rate investment and that a deviation or alteration of just one percent can have a tremendous impact.

It is also an excellent method for highlighting specific sections of the model and ensures a better understanding of how the model will be affected by changes. You can utilize it to get comfortable working with unfamiliar models. The function does have a few limitations such as the limit of assumption alterations, which should be done with great care as even a small change can have a tremendous impact on the outcome of the model.

Since the Excel sensitivity testing will not indicate the best or worst scenarios and since it includes several factors at once, the tool should be used in conjunction with other tests to ensure the best results. The above and many more specific test tools for the Microsoft Software Package are explained in-depth through our training pages and programs.