Preparing a model to showcase industry expertise using the data point system

To showcase industry expertise I developed a model for any particular industry and based on the model the graph was to be prepared. The main motive of developing such a model was to show our expertise in the industry and keep up to date with the latest trends and changes. To achieve the main objective of such model there are some points which should I consider:

  • The industry should be related to our research studies
  • Data for the variable should be available on a monthly basis
  • The model should be dynamic so that more variables can be included in future if required
  • The model should be based on the point system so that the trend can be shown in a single graph

Preparing the model for the manufacturing sector in India

Given the above points, I developed a model showing the efficiency of the manufacturing sector in India. Before deciding the industry and technique, it was important to conduct a thorough research about the availability of the monthly data for the Indian macroeconomic variables. The study in-focus is related to foreign direct investment and its impact on the Indian economy. After reviewing different government websites and open data sources I finalized four variables for which the data was available freely on monthly basis. The four variables are:

  • Index of industrial production
  • Total exports
  • Foreign direct investment
  • Bank credit

Once the variables are finalized then the task was to connect the four variables and create a data point system for the manufacturing sector. However, it was important to use some technique to integrate all the variables and come out with a single point system.

Among the four variables, bank credit and foreign direct investment were used as input by the manufacturing sector. On the other hand exports and the index of industrial production is the indicator of the output of this sector. So there are two input variables and two output variables for the manufacturing sector. On the basis of the categorization of the variable, I decided to measure the efficiency of the manufacturing sector in India. The efficiency can be measured for any combination of input and output and the efficiency value always lies between 0 and 1. Here 1 represents the efficient, in other words, if some entity has an efficiency value of 1, it is using the input optimally to produce maximum output.

Technique and the software used for the model

Model measuring the efficiency of manufacturing sector in India using two input and two output

Model measuring the efficiency of the manufacturing sector in India using two input and two output

There are different software and techniques which can be used to measure the efficiency of an entity. However, among all the available software, Data Envelopment Analysis Program (DEAP) comes out to be the best option for my model. This is because DEAP allows the user to choose a different model based on their research objectives.

For example: one can use either input oriented or output oriented model based on whether are focusing on minimization of input or maximisation of the output. Similarly, one can choose between different returns to scale, namely the increasing returns to scale (IRS), constant returns to scale (CRS) and decreasing returns to scale (DRS). The number of input and output is dynamic. Furthermore the software is freely available and easy to use.

Results and graph presentation

I have collected the monthly data for all the four variables for the time period January 2016- December 2016 to measure the efficiency of the manufacturing sector. For this model, I have selected the output-oriented model because the manufacturing sector does not have much control in the input used for this mode. The equation for the output-oriented model can be written as;

max,l f,

st         –fqi + Ql ³ 0,

xiXl ³ 0,

N1¢l = 1

l ³ 0


K is the number of inputs, M is the number of outputs and I is the number of firms

xi is the Kx1 vector of inputs of i-th firm

qi is the Mx1 vector of outputs of ith firm

X is Kx1 input matrix. Q is the Mx1 output matrix

f is the scaler : 1£ f £ ¥

Technical efficiency is 1/f

Using the above model for the manufacturing sector in DEAP gives the following result.

Efficiency of the manufacturing sector in India from Jan-Dec

The efficiency of the manufacturing sector in India from Jan-Dec

As discussed above the sector is performing efficiently in the month of March, May, June and December. In all other months, the value of efficiency is less than one. This means that the sector was not able to utilize its input to produce maximum possible output.

Indra Giri

Indra Giri

Senior Analyst at Project Guru
He completed his Masters in Development Economics from South Asian University, New Delhi. His areas of interest includes various socio development issues like poverty, inequality and unemployment in South Asia. Apart from writing for Project Guru he loves to travel and play football in his spare time.
Indra Giri

Latest posts by Indra Giri (see all)

Related articles

  • Performing Malmquist DEA in hospitality industry The Malmquist productivity index or more commonly malmquist Data Envelopment Analysis (DEA) was first incepted by the researcher Malmquist in 1953 as a quantity to be used in the analysis of consumption of inputs (Färe, Grosskopf, & Margaritis, 2011).
  • Executing cost DEA of banks using Data Envelopment Analysis Program (DEAP) The cost efficiency analysis or cost data envelopment analysis or cost DEA is evaluated when information on prices and costs are available from the source of the data collected for input and output variables (Cooper, Seiford, & Zhu, 2011).
  • Overcome common challenges in GM (1,1) modelling using MS Excel GM (1,1) modelling is a popular grey forecasting method because of its computational efficiency. There are many challenges in GM (1,1) modelling, but they are solvable using MS Excel. This article is a detailed guide on how to overcome these challenges.
  • Slacks based measure or SBM analysis in DEA Slacks based measure or SBM analsysis is a non-radial model to solve the problem in the "additive model" developed by Charnes, Cooper, & Rhodes in 1978. This model can discriminate between efficient and inefficient Decision-Making Units (DMU).
  • Variable returns to scale in DEA and summary of efficiency and slacks Variable returns to scale (VRS) is a type of frontier scale used in data envelopment analysis (DEA). It helps to estimate efficiencies whether an increase or decrease in input or outputs does not result in a proportional change in the outputs or inputs respectively (Cooper, Seiford, & Zhu, 2011).


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