I have to perform DEA on large number of banks, around 100 and I'm using TORA for problem optimization and going with the traditional way I would have to enter the data for all 100 banks manually which is making my work tedious. Can anyone suggest a simpler method to do the same?
for eg: forming groups of banks, categorizing them on the basis of some factors such as reserves or branches, then find out the average values and then perform DEA.
Will my above method give me right result?
You can use Microsoft EXCEL to generate the condition. Firstly, enter your data in columns and then, in some CELLS, by "=" you can write and generate your formula that are conditions.
Hi. Download this file.
http://s3.picofile.com/file/8188055200/12_.flv.html
Dear Dyvia:
DEA has been used in microfinance by the following author: Begoña Gutiérrez Nieto, from the university of Zaragoza, Spain.
Regards
Gustavo concari
In DEA your data entry includes inputs and outputs, so if you have large number of banks it is a credit using DEA for relative efficiency inspection. Make sure that you have the same input and output variables for all DMUs. If your data includes for some DMUs data on branches, you need to consolidate it to have the same data for each bank. Goodluck
Do let me know if these authors are able to help you do the required programming in excel:
http://www.sciencedirect.com/science/article/pii/S0378426613000186
- Badges
- Science topic
- Similar topics
- Phytochemistry
- Extracts