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, application of specific efficiency testing software is important using the data envelopment analysis (DEA).Thus, 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 performance of an organization manually. But in many literatures, 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

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

  • Importing data and defining the variables in DEAP The previous article, explains the process to download Data Envelopment Analysis (DEA) and define the case problem in hand. The first step now is to understand how to import data in DEAP.
  • Introduction to SPSS and using it SPSS is an acronym for “Statistical Package for Social Science” and is a Windows based program which is used to perform different tasks like, data entry, analysis and further presentation of results through tables and graphs.
  • Multivariate analysis with more than on one dependent variable The normal linear regression analysis and the ANOVA test are only able to take one dependent variable at a time. So one cannot measure the true effect if there are multiple dependent variables. In such cases multivariate analysis can be used. Thus, multivariate analysis (MANOVA) is done […]
  • Frequency analysis with SPSS In my previous article “Introducing Data” we discussed about importing files and creation of data sheet in SPSS. Moving further, in this article I will be discussing about the most basic technique which can be applied within SPSS i.e. Frequency Testing.
  • T-test using SPSS When using this statistical test, you are testing the null hypothesis that 2 population means (average) are equal. The alternative hypothesis is that they are not equal.


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