Advantages of using Advanced Excel for a large data set

In recent years, big data has become a buzz word for them who are relying on digital technologies as it allows storage and analysis  of massive data. Here, big data includes both structured and unstructured data sets which require processing capabilities of modern tools. One of the most popular tools to handle big data is Advanced Excel and its relevant add-ons (Rose, Spinks, & Canhoto, 2015).

Read more »

Variable management in STATA

Data entered in STATA can be classified either as numeric or string type. Associated with each type of data is its storage type i.e. the numbers are stored as byte, int, long, float, or double. STATA takes “float” as the default storage type for its variables. Similarly byte, int and long are usually used to hold integers. The table given below defines the storage type with minimum and maximum value for each variable along with byte size. Read more »

Creating a do-file

Do-file is an interface in Stata which allows the researcher to compile all the commands and results at one place. Once the commands are stored in do file, one do not need to enter the command again. One can simply run the do file and get all the results at once. Unlike SPSS wherein, the output sheet is automatically generated every time you run a test. All the commands and results in this file can be mailed together. Read more »

Correlation analysis using STATA

Correlation analysis is conducted to examine the relationship between dependent and independent variables. There are two types of correlation analysis in STATA.

  1. Pairwise correlation which treat each pair of variables separately and only includes observations which have valid values for each pair in the data set.
  2. The second type of correlation is the normal correlation which takes the entire data set as one and calculates the correlation for all valid values.

Read more »

Introduction to STATA

STATA, like SPSS is a smart data analysis tool used for data management and analysis. It is a fast and easy to use, across all operating systems such as Windows, Unix and Mac. Our module is based on Windows version of STATA 11.0. Read more »

Determining the impact of an event on share prices using the event study

Event study helps to determine the effect of an event on a dependent variable. In most cases event study is used to determine the impact of an event on the stock prices of a company. The main motive of the event study is to find whether the event has abnormal returns on the prices of the stock. In other words whether the prices would have changed if the event has not taken place. To conduct the event study following steps can be followed: Read more »

Solutions to the problems faced during statistical analysis using panel data

In one of my recent projects I had to use panel data for analysis. During the data analysis I faced some problems which may be the most common problems in panel data analysis. So here are some of the problems with their possible solutions that helped me.

Read more »

Breaking the code of writing a research paper

Research paper writing is a challenging task. You have to deal with criticism as sportingly as you accept compliments. Writing a research paper is not like bulk content writing or general promotional or blog writing. Read more »


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