scroll to top
Stuck on your essay?
Get ideas from this essay and see how your work stacks up
Word Count: 1,839
The increase in recent years in the sophistication power and user-friendliness of spreadsheets such as Microsoft Excel has meant that more decision makers are building their own spreadsheet models to help them in their decision making These models however are only as good as two things Firstly the data that goes into the model and secondly the logic of the relationships built into the model Inaccurate input data values or faulty logic can only produce bad results especially if the inaccurate data values are the key or critical variables Beaman Ratnatunga Krueger and Mudalige 2002 Obviously more care should be taken when estimating an input variable to which the output is highly sensitive and conversely less time and care taken in estimating an input variable to which the output is less sensitive Beaman et al 2002 But how model builder can identify which variables are key or critical Performing sensitivity analysis is the answer to this question Sensitivity analysis enables the model builder to identify the key variables In other words to identify those input variables to which the output is most sensitive Sensitivity analysis itself involves determining the impact on a models result of a change made to only one input variable while holding all other variables constant Small changes to this input variable may result in dramatic changes to the results In this case the results are said to exhibit high sensitivity to this input variable Alternatively a change in this input variable may produce little overall change in the results thus low sensitivity Beaman et al 2002 In short sensitivity analysis determines which input distributions have the biggest impact on the outputs Broadleaf Capital International Accessed 21 April 2004 Furthermore sensitivity analysis allows the decision maker to determine which input variables have the most impact on the organizations bottom line The decision maker may then decide whether it is appropriate to concentrate on those variables As well as allowing the decision maker
@Kibin is a lifesaver for my essay right now!!
- Sandra Slivka, student @ UC Berkeley
Wow, this is the best essay help I've ever received!
- Camvu Pham, student @ U of M
If I'd known about @Kibin in college, I would have gotten much more sleep
- Jen Soust, alumni @ UCLA