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
Dates |
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 |
Venue |
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
DAY 1 |
DAY 2 |
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 |
(-) |
Comments