A 2-day certificate program – ‘Research Modelling using Excel and R’ was organized on March 9, 2019, at IIIT Allahabad. The objective of this workshop was to acquaint the participants with Microsoft Excel and R Studio by helping them carry out some hands-on exercises from the research domain.

Facts related to 2 Day Certificate Program


March 8 – 9, 2019

Fee (INR)

1500 (incl. of GST)

Last date to register

March 1, 2019

For Registration

https://apply.iiita.ac.in/event/ register


Department of Management Studies, IIIT Allahabad

Contact Information

utkarsh@iiitac.in | 9648844999 | 7376212828

Coverages @IIIT Allahabad

To cater to all kinds of participants from different functional domains, the research-centric hands-on exercises have been developed in a manner that involves the user solving simple to complex problems by using different research techniques



Introduction to Excel and its Applications

T-Test: Paired Two Sample for Means

Basic and Advanced Excel Functions

T-Test: Two-Sample Assuming Equal Variances

File Merging for Data Compilation

Z-Test: Two-Sample for Means

Simple Frequencies for Statistic calculations

Multiple Regression using Excel: Linear, Logit and Probit regression

Descriptive Statistics and Correlations

Import Data, Copy Data from Excel to R CSV & TXT Files

Two Sampled T-test • Paired T-test

Basic Data Analysis in RStudio

Cross-tabulation and Chi-Squared Test of Independence

Histograms in R

One-way ANOVA | Two-Factor ANOVA without Replication

Multiple Regression using R: Linear, Logit and Probit regression

Two-Factor ANOVA with Replicates

Stepwise Regression in R - Combining Forward and Backward Selection

F-Test Two-Sample for Variances


Important Note: The program would be a mix of lecture, hands-on exercises and experience sharing between participants and resource persons like Dr. Ankit Mahindroo - LM Thapar School of Management, TIET, Dr. Shailendra Kumar- IIITA (Organiser) and Dr. Utkarsh Goel - IIITA (Organiser).