Skip to main content

Importance of exploratory data analysis of dummy variables, logit/probit using eviews

By IMPRI Team 
 
IMPRI Generation Alpha Data Centre (GenAlphaDC) along with IMPRI Impact and Policy Research Institute, New Delhi conducted a Two-Week Immersive Online Hands-On Certificate Training Course on Exploratory Data Analysis with Categorical Variables Regression Models Dummy Variables and Logit/Probit using EViews, on December 10 and 17, 2022. The expert trainer for the course was Professor Nilanjan Banik, Professor at Mahindra University. He is a Visiting Consultant at IMPRI and an Academic Consultant with Geneva Network, United Kingdom, and a Senior Consultant with Hankuk University of Foreign Studies, South Korea.
The convenors for the event were Prof Vibhuti Patel, Visiting Professor at IMPRI and a Former Professor, Tata Institute of Social Sciences (TISS), Mumbai; Dr Soumyadip Chattopadhyay, Associate Professor, Economics, Visva-Bharati, Santiniketan and a Visiting Senior Fellow, IMPRI; Dr Arjun Kumar, Director, IMPRI. The training course had participants from the field of data and policy– including students, professionals, researchers, and many others.

Day 1 | December 10, 2022

The session began by going through the basics of Regression. The first question he pondered upon is what the meaning of a “dummy” is. He stated that in essence, it means a replica. Here, in a regression model, if X is a dummy variable, it means that it is a qualitative variable. He began by laying down some assumptions about the dependent and the independent variables. First, X and the Error Term (e) are not related, if related, there will be a problem of endogeneity. X is not quantitative if it is a dummy variable. He explained how we can constitute various qualitative traits in a dummy variable such as gender, and ethnicity among others in a regression model. It tries to capture the impact of any variable that is qualitative in nature.
Second, he mentioned that a dummy variable can capture any break or shift in data. He used the example of the Indian economic reforms of 1991, which was a breakpoint in terms of per capita GDP levels. After 1991 there was a big jump in GDP growth. In other words, there was a structural break. Dummy variables can capture such structural breaks. Thirdly, he mentioned that dummy variables can also be used to de-seasonalize the data. Using Excel, he showed how to incorporate dummy variables in a regression model and how dropping a dummy variable is important in order to avoid a Dummy Trap. He also showed how to de-seasonalize the data, using Excel. After de-seasonalizing the graph turned out to be more stable than before.
After explaining over Excel, he showcased the same data set on EViews. He selected the variables such as sales figures, trends, etc. He then created the dummy variables out of the four quarters. He ran the regression without the dummy first. Then he showcased a data set where he introduced a dummy and ran the regression. The data set used was US Trends in Gross Personal Income and Gross Personal Savings from 1959 to 2007. The dummy variables reflected the recession points from 1981 to 1984. The regression diagram consequently showed the breaking point due to the recession of 1981. The session ended for the day with this, after which, Professor Banik went on to take questions and clear doubts of the trainees. The next class was saved to learn Logit and Probit Models.

Day 2 | December 17, 2022

The second day of the session conducted by Professor Nilanjan Banik, titled, “Exploratory Data Analysis with Categorical Variables Regression Models: Dummy Variables and Logit/Probit using EViews” was devoted to the concepts of Logit and Probit. Professor Banik started by explaining the basic equation of a regression model, and the components within it. Here, the motive was to explain the concept of dummy variables, and the Probit/Logit model, when the variables X and Y are qualitative respectively. Then with an example of hourly wage rates, he showed how to interpret dummy variables for various categorical variables.
After explaining dummy variables, he followed it up by talking about Logit functions. He mentioned that in Logit functions, the dependent variable, Y, takes values of 1 or 0. The Logit or Probit model describes the odds of an individual meeting the outcome variable, given a certain trait or characteristic. He mentioned the importance of LR tests in Probit models. The Logit/Probit models primarily deal with the dependent variable (Y). He showed that the Y variable takes values between negative infinity to positive infinity. He proved this by showing the method to derive the value of Y using Probability. Since the P value will be between the value of 0 and 1, the Y value will take the value of negative Infinity to positive infinity.
After delving into theory, he started a practical lesson on the above discussions with the help of a data set on EViews. First, he showed how to introduce dummy variables on a set of observations. Then, Professor Banik went on to show how to interpret Logit functions on EViews. For this, he again used the previous US data on Savings and Income to show the recession point. Using other data he showed how smoking is affected by age, income, and education. He explained what the P value shows using the formula for the same. He also showed it practically based on the regression model and the results generated from it. Then he took questions from the trainees which he promptly clarified. With this, the two-day training course ended.
---
Acknowledgement: Aaswash Mahanta is a research intern at IMPRI

Comments

TRENDING

A comrade in culture and controversy: Yao Wenyuan’s revolutionary legacy

By Harsh Thakor*  This year marks two important anniversaries in Chinese revolutionary history—the 20th death anniversary of Yao Wenyuan, and the 50th anniversary of his seminal essay "On the Social Basis of the Lin Biao Anti-Party Clique". These milestones invite reflection on the man whose pen ignited the first sparks of the Great Proletarian Cultural Revolution and whose sharp ideological interventions left an indelible imprint on the political and cultural landscape of socialist China.

Two more "aadhaar-linked" Jharkhand deaths: 17 die of starvation since Sept 2017

Kaleshwar's sons Santosh and Mantosh Counterview Desk A fact-finding team of the Right to Feed Campaign, pointing towards the death of two more persons due to starvation in Jharkhand, has said that this has happened because of the absence of aadhaar, leading to “persistent lack of food at home and unavailability of any means of earning.” It has disputed the state government claims that these deaths are due to reasons other than starvation, adding, the authorities have “done nothing” to reduce the alarming state of food insecurity in the state.

Epic war against caste system is constitutional responsibility of elected government

Edited by well-known Gujarat Dalit rights leader Martin Macwan, the book, “Bhed-Bharat: An Account of Injustice and Atrocities on Dalits and Adivasis (2014-18)” (available in English and Gujarati*) is a selection of news articles on Dalits and Adivasis (2014-2018) published by Dalit Shakti Prakashan, Ahmedabad. Preface to the book, in which Macwan seeks to answer key questions on why the book is needed today: *** The thought of compiling a book on atrocities on Dalits and thus present an overall Indian picture had occurred to me a long time ago. Absence of such a comprehensive picture is a major reason for a weak social and political consciousness among Dalits as well as non-Dalits. But gradually the idea took a different form. I found that lay readers don’t understand numbers and don’t like to read well-researched articles. The best way to reach out to them was storytelling. As I started writing in Gujarati and sharing the idea of the book with my friends, it occurred to me that while...

New RTI draft rules inspired by citizen-unfriendly, overtly bureaucratic approach

By Venkatesh Nayak* The Department of Personnel and Training , Government of India has invited comments on a new set of Draft Rules (available in English only) to implement The Right to Information Act, 2005 . The RTI Rules were last amended in 2012 after a long period of consultation with various stakeholders. The Government’s move to put the draft RTI Rules out for people’s comments and suggestions for change is a welcome continuation of the tradition of public consultation. Positive aspects of the Draft RTI Rules While 60-65% of the Draft RTI Rules repeat the content of the 2012 RTI Rules, some new aspects deserve appreciation as they clarify the manner of implementation of key provisions of the RTI Act. These are: Provisions for dealing with non-compliance of the orders and directives of the Central Information Commission (CIC) by public authorities- this was missing in the 2012 RTI Rules. Non-compliance is increasingly becoming a major problem- two of my non-compliance cases are...

What's behind Donald Trump's 'narco-state' accusation against Venezuela

By Manolo De Los Santos  The US government has revived its campaign to label Venezuela a "narco-state", accusing its top leadership of drug trafficking and slapping hefty bounties on their heads for capture. This campaign, which only momentarily took a backseat, is a strategic fabrication, not a factual assessment. This accusation, particularly amplified under the Trump Administration, is a calculated smokescreen to justify a long-standing agenda: the overthrow of the Venezuelan government and the seizure of its vast oil and mineral resources. A closer examination of the facts reveals a country that has actively fought drug trafficking on its own terms and a US government with a clear and consistent history of destabilizing independent countries in Latin America.

N-power plant at Mithi Virdi: CRZ nod is arbitrary, without jurisdiction

By Krishnakant* A case-appeal has been filed against the order of the Ministry of Environment, Forest and Climate Change (MoEF&CC) and others granting CRZ clearance for establishment of intake and outfall facility for proposed 6000 MWe Nuclear Power Plant at Mithi Virdi, District Bhavnagar, Gujarat by Nuclear Power Corporation of India Limited (NPCIL) vide order in F 11-23 /2014-IA- III dated March 3, 2015. The case-appeal in the National Green Tribunal at Western Bench at Pune is filed by Shaktisinh Gohil, Sarpanch of Jasapara; Hajabhai Dihora of Mithi Virdi; Jagrutiben Gohil of Jasapara; Krishnakant and Rohit Prajapati activist of the Paryavaran Suraksha Samiti. The National Green Tribunal (NGT) has issued a notice to the MoEF&CC, Gujarat Pollution Control Board, Gujarat Coastal Zone Management Authority, Atomic Energy Regulatory Board and Nuclear Power Corporation of India Limited (NPCIL) and case is kept for hearing on August 20, 2015. Appeal No. 23 of 2015 (WZ) is filed, a...

1857 War of Independence... when Hindu-Muslim separatism, hatred wasn't an issue

"The Sepoy Revolt at Meerut", Illustrated London News, 1857  By Shamsul Islam* Large sections of Hindus, Muslims and Sikhs unitedly challenged the greatest imperialist power, Britain, during India’s First War of Independence which began on May 10, 1857; the day being Sunday. This extraordinary unity, naturally, unnerved the firangees and made them realize that if their rule was to continue in India, it could happen only when Hindus and Muslims, the largest two religious communities were divided on communal lines.

Ground reality: Israel would a remain Jewish state, attempt to overthrow it will be futile

By NS Venkataraman*  Now that truce has been arrived at between Israel and Hamas for a period of four days and with release of a few hostages from both sides, there is hope that truce would be further extended and the intensity of war would become significantly less. This likely “truce period” gives an opportunity for the sworn supporters and bitter opponents of Hamas as well as Israel and the observers around the world to introspect on the happenings and whether this war could have been avoided. There is prolonged debate for the last several decades as to whom the present region that has been provided to Jews after the World War II belong. View of some people is that Jews have been occupants earlier and therefore, the region should belong to Jews only. However, Christians and those belonging to Islam have also lived in this regions for long period. While Christians make no claim, the dispute is between Jews and those who claim themselves to be Palestinians. In any case...

Fate of Yamuna floodplain still hangs in "balance" despite National Green Tribunal rap on Sri Sri event

By Ashok Shrimali* While the National Green Tribunal (NGT) on Thursday reportedly pulled up the Delhi Development Authority (DDA) for granting permission to hold spiritual guru Sri Sri Ravi Shankar's World Culture Festival on the banks of Yamuna, the chief petitioners against the high-profile event Yamuna Jiye Abhiyan has declared, the “fate of the floodplain still hangs in balance.”