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

Clive Lloyd among great batsmen Alan Border, Javed Miandad, Rahul Dravid,Ted Dexter

By Harsh Thakor  Few batsmen struck a cricket ball with such vengeance or contempt as Clive Lloyd, who was the ultimate embodiment of power. Perhaps no left-hander batted more like Gary Sobers. Hard to think of any left hander in is time, with such wide range of strokes or at best batting in a more cavalier or imperious manner. At his best Clive could take domination to the scale rarely transcended and was a spectacle to witness.. It is hard to do justice to the joy Clive radiated out on the middle. Clive Lloyd nurtured and knitted a bunch of talented individuals to transform into possibly the best test team ever in the 1980's.Literally led a renaissance or gave a new dimension to Caribbean cricket. Never did West Indian cricket nurture such father figure.  Clive made a great contribution in elevating the morale or epitomising the spirit of the Afro-American West Indian Community and image of black people in the eyes of the white Community. As a cricketer he gave the ultimate knock

Vishwanath has been unfairly excluded from global list of 100 best cricketers

By Harsh Thakor  Gundappa Vishwanath scaled zones in batting artistry or wizardry unparalleled amongst Indian batsmen. The best of his batting was a manifestation of the divine. He was also the epitome of cricketing sportsmanship. Sadly 40 years ago he unceremoniously bid farewell to the International cricket world, after the concluding test at Karachi in 1982-83., in January end. Very hard to visualise a character like Vishwanath being reborn today His memories are embedded in cricket lovers today when sportsmanship and grace have virtually been relegated to oblivion with the game of cricket turned into a commercial commodity. Today agro and unsporting behaviour is a routine feature Vishy shimmered cricket’s spirituality. His behaviour on the cricket field was grace personified, No one in his age defined cricket more as a gentleman’s game, than Vishy. Vishwanath could execute strokes that were surreal with his steel wrists. His strokeplay resembled the touches of a painter’s brush,

Abrogation of Art 370: Increasing alienation, relentless repression, simmering conflict

One year after the abrogation by the Central Government of Art. 370 in Kashmir, what is the situation in the Valley. Have the promises of peace, normalcy and development been realised? What is the current status in the Valley? Here is a detailed note by the People’s Union for Civil Liberties , “Jammu & Kashmir: One Year after Abrogation of Art. 370: Increasing Alienation, Relentless Repression, Simmering Conflict”:

Reproductive, conjugal rights of women in India amidst debate of uniform civil code

By IMPRI Team  A Three-Day Immersive Online Legal Awareness and Certificate Training Course on “Reproductive and Conjugal Rights of Women in India” is an initiative of the Gender Impact Studies Center (GISC), at the IMPRI Impact and Policy Research Institute, New Delhi, and ran for three consecutive days starting from December 22, 2022 to December 24, 2022. The online paid certification was aimed to provide attendees with an enriching experience on the gender discourse with a special focus on women’s rights and the much-discussed reproductive rights in India.

Covid jabs: Pretexts cited to justify young, healthy succumbing to heart attacks

By Jay Ihsan   Truth is stranger than fiction – when dedicated doctors raised the red flag against the mRNA Covid-19 vaccines, they were persecuted and their concerns barred from being heard. These honest doctors unequivocally made it known the Moderna Pfizer vaccines injure the heart and human body. One of them, Dr Peter McCullough, an American cardiologist, has repeatedly issued the clarion call to people to reject these harmful vaccines. An equally alarmed World Council for Health said the harmful Covid-19 vaccines should be removed from the market and the global inoculation must be stopped. “In Japan the vaccines were not mandated or made compulsory. The vaccines are not safe or effective enough to mandate them. The day the vaccines go away will be a day of celebration,” Dr Mccullough had lamented during an interview with India’s media outfit, Qvive several months ago. Meanwhile, the number of people jabbed with the Covid-19 mRNA vaccines died soon after or have developed lifelong

Gender gap 17%, SC and ST levels of education between 7% to 14% below upper classes

By IMPRI Team  The treatment of school education in a holistic manner and improving school effectiveness in terms of equal opportunities for schooling and learning outcomes has been the aspiration of all and multiple challenges are faced to maintain and provide proper education. On the occasion of India@75: Azadi Ka Amrit Mahotsav, as part of its series- the State of Education- #EducationDialogue, #IMPRI Center for ICT for Development (CICTD), IMPRI Impact and Policy Research Institute, New Delhi organised a special deliberation on The State of School Education In India with Prof Muchkund Dubey, who is the President of the Council for Social Development, New Delhi. The moderator for the event, Dr Simi Mehta CEO and Editorial Director of the IMPRI. The chair of the event was Prof Jandhyala B.G. Tilak, an Indian Council of Social Science Research (ICSSR) National Fellow, the Distinguished Professor at the Council for Social Development, New Delhi and also a Former Professor & Vice-Ch

Rahul Dravid exhibited selflessness in heights unscaled by any other Indian batsman

By Harsh Thakor*  On January 11th maestro Rahul Dravid turned 50. No Indian batsmen were ever more of an embodiment of temperament or grit.as Rahul Dravid. Dravid was the best ambassador of sportsmanship in cricket in his day and age. In his time no Asian batsmen did what the doctor ordered, to the extent of Dravid. Dravid was manifestation of single-mindedess, tenacity and selflessness in sport. One hardly has an adjective to the ice coolness and craft Dravid exhibited in adjusting to the given situation. Rarely did any batsmen exhibit such a clinical o methodical approach to batting.

NHRC blindly followed BSF status report on fencing farmland off Indo-Bangladesh border

Kirity Roy, Secretary, Banglar Manabadhikar Suraksha Mancha (MASUM) writes an open letter of protest against the action taken status report on restriction imposed by the BSF personnel upon the villagers of Changmari near Indo-Bangladesh border: *** I have the honour to inform you that we received one action taken status report dated 11.01.2023 from your Commission in respect of the above referred case from where it is revealed that your authority closed the case based on the report of the concerned authorities. In this connection I again raise my voice as the enquiry in respect of the above referred case was not properly conducted. Hence I submit this open letter of protest for the ends of justice. From the action taken status report of the Commission dated 11.01.2023 it is reported that concerned authority submitted a report dated 18.01.2022 where it is reported that the concerned area comes under the OPS responsibility of BOP Chengmari, 62 Bn BSF and is highly susceptible to trans-bo

Data analytics: How scientific enquiry process impacts quality of policy research

By IMPRI Team  Given the multidimensionality of policy and impact research, tech-driven policy prescriptions are playing a dominant role in the 21st century. As such, data analytics have become integral in this space. IMPRI Generation Alpha Data Centre (GenAlphaDC) , IMPRI Impact and Policy Research Institute New Delhi has successfully conducted a #WebPolicyTalk 6-Week Immersive Online Hands-on Certificate Training Course on Data Analytics for Policy Research, spanning over 6-consecutive Saturdays from October 15th to November 19th, 2022. Along with this, datasets for hands-on learning were also provided for data analysis and learning. Participants were required to make a submission for evaluation at the end of the course, to obtain the certificate. This course comprised hands-on data learning sessions and various expert sessions on data discourses. The course especially catered to data and policy enthusiasts – including students, professionals, researchers, and other individuals lo

Brutal assault on Delhi Univ students as fear grips present rulers on rise of dissent

By Arhaan Baaghi  Various democratic student organizations (bsCEM, fraternity, DSU, SIO, AIRSO) had planned a screening of the BBC documentary "India: The Modi Question" in the Delhi University Arts Faculty, but the guards of the university and the Delhi police along with paramilitary forcefully detained the students just because we were trying to watch a documentary that scrutinizes the role of Modi in 2002 Gujarat riots. At first when the students started screening the documentary, the electricity of the department building was cut down. Students were brutally beaten by the police and university guards. Female students were also brutally manhandled and beaten. This whole incident shows the Brahmanical Hindutva fascist nature of the government and the university authority that is working as its puppet. An activist of bsCEM was manhandled by a male security guard, who tried to pull out his T shirt. Also various female activist were dragged by male security guards and their h