Using Data Envelopment Analysis (DEA) program for measuring efficiency

Measuring efficiency to benchmark the performance of organizations such as banks, financial firms, ports, hotels etc. is important. In one of the recent projects, the analyst found Statistical Package for Social Science (SPSS) and MS Excel to be unsuitable to process data collected to measure efficiency. Thus, the application of specific efficiency testing software is important using the data envelopment analysis (DEA). Thus, the application of specific efficiency testing software is important using the data envelopment analysis (DEA). Data envelopment analysis (DEA) is the most commonly used program for this purpose (Coelli, 2008). This software has been programmed and copyrighted by Tim Coelli from of University of New England (Centre for Efficiency and Productivity Analysis, Department of Econometrics, Australia). The software is a DOS-based command system and comes in a zipped format along with guidelines on how to use it. However, the program did not indicate how one can use the DOS command to conduct the test. It only contained interpretations of the sample results.

However, MS Excel can be used to benchmark the performance of an organization manually. But in many kinds of literature, it was found to be not reliable as it does not show the actual value of efficiency since the variables may be biased. Furthermore, the MS Excel add-ins are developed to help in efficiency testing, have limitations. On the other hand in the case of SPSS, there is no such efficiency test. However, large corporations can have access to other software, but this module is basically focused to help academicians in conducting their researches. Moreover, based on literature reviews, data envelopment analysis helps to evaluate key performance indicators and benchmarking analysis to measure efficiency (Beasley, 2017).

Installing the software

In order to install the software package; copy and paste the link to the address page on the browser or directly click on the link →

  1. After downloading, firstly unzip the program from the zipped folder and extract the contents to a new folder (Name it DEAP according to convenience).
  2. The zip folder contains four main files i.e., executable file “DEAP.EXE” (which is the main executable file and the DOS file), startup file “DEAP.000” (this file is linked to the executable file as it contains the algorithm to conduct efficiency test), data.txt (file name for notepad where dataset is to be pasted) and data-ins.txt (this includes the set of parameters, defining the scales and variables). These are the main file systems which will enable the researcher to perform efficiency test.

Defining the case study

A case study was considered, which will help to understand the importance of using data envelopment analysis. In this module, 10 banks will be benchmarked for efficiency on different input and output variables. Out of the 10 Indian banks considered for the study, where 5 each from the public sector and the private sector banks have been identified for the research. The main objective of the study was to find the efficiency levels of the banks and enable a comparative analysis for same. In the study, two input variables (Total Capital and Deposits) and two output variables (Total Loans and Profits) have been considered. The importance of taking Total Capital and Deposits as the input variables is because they act as the bank’s source of capital inflow which helps the banks for outflow i.e. Loans and Net Profits. Any finances that inflow in an organization to help improve services, compete and survive are input Here, the input variables and output variables were extracted from the Annual Reports of the respective banks of FY-2016. Moreover, literature can be consulted for more similar input variables and output variables of banking sectors.

In the next article, how to import data and define variables and files names will be shown in DEAP v2.0.


Avishek Majumder

Research Analyst at Project Guru
Avishek is a Master in Biotechnology and has previously worked with Lifecell International Private Limited. Apart from data analysis and biological research, he loves photography and reading. He loves to play football and basketball in his spare time with an avid interest in adventure and nature. He was also a member of the Scouts in his school and has attended Military training.
Avishek Majumder

Related articles



  1. Dear

    Hello! After you can visited the page by to see the software that we realize. Congradualations the deap is very good.

    • Dear Mariana,
      Thank you for going through the article. More articles are available on our site. I have visited the page you recommended. I will surely analyze data in the DEA software your group created and wish you success on the same.

      For any assistance do get back to us.

  2. Hello Sir;
    I am a research scholar from udaipur, Rajasthan. I am working on a prediction model for Indian Banking Industry. For the benchmarking i need to apply DEA. I have data of 78 banks (Public, private and Foreign banks operating in India.). I don’t find any free DEA Frontier software which can analyze more than 20 DMU. Could you please help me in this.

    • Hello Samta Ordia,

      It’s a very big dataset you are working on but as the problem, you are facing it will be really difficult to have a free software were more than 20 DMUs can be used. My suggestion is if you want to use a free software, divide the three types of bank and separately analyze their efficiency. For this, you will also have to shorten the number of DMUs 78 to 60. After checking the efficiency separately, conduct another efficiency test among the most efficient ones. Now you can predict a model for Indian Banking Industry. I hope it will be helpful for you.

      For any more assistance, you can reply us to your queries.

      Thanks and regards,

      Avishek Majumder

  3. can i use the software for quality health care assessment in peripheral health systems

  4. Dear Majumder,
    I have a big dataset ; 291 rice farmers for efficiency analysis. Following your suggestion to Santa Ordia, I have done the analysis using Stata vrs dear. Can I merge the guests or vrs the and use it as dependent variable in Tobit regression?
    Thanks for the service


We are looking for candidates who have completed their master's degree or Ph.D. Click here to know more about our vacancies.