how to install data envelopment analysis on excel

of outputs and inputs are 2 as mentioned previously wherein Inputs are Total Capital and Deposits and Outputs are Total Loans and Profits. Number of time period, here is “one” because performance efficiency for only one year is being analyzed (FY2016).Mention the output file name where the dataset pasted (banks.txt) and also mention the name of the file where the results represented (result.txt).

10 in the current case example or 10 DMUs’. Decision making units (DMUs’) are defined by no.As in the above image banks.txt is file location for data. Then open the instruction file, data-ins.txt as in the DEA tool package (file name unchangeable as found while practical application). Imported data in data.txt fileĭefining the variables and files names in DEA The DEA instruction file Total Capital and Deposits) for the 10 case banks while importing the data to Data Envelopment Analysis (DEA). Total loans and Profits) and then add the Input variables (i.e. Quick Note: First add the Output variables (i.e. Importing data from MS Excelįirst step is to copy the variables from MS Excel to Notepad (banks.txt akin to data.txt). The underlying steps will help in understanding importing and importance of each part. MS Excel is used to compile the data collected from the various sources and literature followed in selection of input and output variables. The first step is to understand how to import data to DEAP.

In the previous article, “ Using Data Envelopment Analysis (DEA) program for measuring efficiency” the process to download Data Envelopment Analysis program (DEAP) was explained and the case problem in hand was defined.

How to install data envelopment analysis on excel