TRCINDIA.CO.IN
Transformatory Research Collaborative
Quest for Transformation
Training and Workshops
UPCOMING....
Ten days’ E-workshop on Introductory and intermediate statistics
September 1-10, 2025
About: This E-Workshop will provide 20 hours of intensive training on introductory and intermediate level statistics. It will be highly beneficial for candidates from any discipline who want to develop aptitude for statistical analysis and apply it at a fair level. The workshop will focus on both theoretical rigor and practical exercise. Participants must be familiar with MS Excel or above.
How to apply
Interested candidates should submit the google form using following link:
https://docs.google.com/forms/d/1oTkhZUPmuKBwCNs81ZCHL6zJgn-2KGM0GNVCxr3keqE/edit
Application deadline: August 30, 2025
​Registration fee: INR 1500/- [payment through bank transfer or UPI]
Contact email: trcindia2022@gmail.com
​​
Bank Details
State Bank of India, Patna 800004
Account Name: Transformatory Research Collaborative
Account No: 41290487175
IFSC: SBIN0003516
UPI: 9199200554​
​
Resource persons
1) Neetu Choudhary, PhD
Current Affiliation: Arizona State University and Raiganj University through ICSSR
Experience: 15 years of experience in quantitative research using advanced data analysis tool​
​
2) Abhijit Ghosh, PhD
Current Affiliation: Mahatma Gandhi College (affiliated to SKBU)
Experience: 12 years of experience in using advanced statistical tools and analysis
Course Module
1.Introduction: Types of data and variable 2 hrs.
-
Describing quantitative data .
-
Pie Chart, Bar Graph, and Histograms
-
Box-and-Whisker Plot and Scatter Plot​
-
-
2. Describing distribution 2 hrs.
-
Normal distribution
-
Mean, median, quartile, percentile
-
Standard deviation
3. Probability 4 hrs.
-
Randomness
-
Probability models
-
Random variable- it’s mean and variance
-
Types of probability distribution
-
Standardizing Data and the Standard Normal Curve
-
Normal approximation
4. Sampling 2 hrs.
-
Sampling design
-
Sampling techniques
-
Parameter and statistic
-
Expected value and standard error
-
Central limit theorem
5. Relationships 4 hrs.
-
Correlation
-
Design of experiments
-
Observation versus experiment
-
Least square regression
-
Multiple regression
​
6. Inference and hypothesis testing 2 hrs.
-
Parametric vs. non-parametric test
-
p-values as Measures of Evidence
-
t-test; F-test, Two-sample z-test
-
Inferences for categorical data
-
Inferences for regression
7.Analysis of categorical data 2 hrs.
-
Chi-square
-
​ANOVA [One way]
​​
8. Projection 2 hrs.
-
Population
-
Extrapolation
-
Interpolation
​____________________________________________________________________________________________________________
COMPLETED
TRC successfully completes​ four days E Workshop on "Basic statistics with Excel for a Multidisciplinary team" during
May 28-31, 2025
​​
About
This e-workshop targeted at a multidisciplinary team and will equip the participants with essential data analysis skills using
Microsoft Excel. The programme was particularly tailored to the needs of scholars from diverse background at any stage of
their career. The training introduced participants to basic statistical methods and their analysis using Microsoft Excel.
​
How to apply
Interested candidates should submit the google form using following link:
​Registration fee: INR 1000/- [payment through bank transfer or UPI]
Contact email: trcindia2022@gmail.com
​​
Bank Details
State Bank of India, Patna 800004
Account Name: Transformatory Research Collaborative
Account No: 41290487175
IFSC: SBIN0003516
UPI: 9199200554​
​
Resource persons
1) Neetu Choudhary, PhD
Current Affiliation: Arizona State University and Raiganj University through ICSSR
Experience: 15 years of experience in quantitative research using advanced data analysis tool​
2) Abhijit Ghosh, PhD
Current Affiliation: Mahatma Gandhi College (affiliated to SKBU)
Experience: 12 years of experience in using advanced statistical tools and analysis
Course content​
Unit 1: Introduction to Excel for Data Analysis
-
Overview of Excel interface and key features
-
Understanding data types and formats
-
Basic navigation and shortcuts
Unit 2: Data Handling and Cleaning
-
Importing and organizing data in Excel
-
Sorting and filtering data
-
Removing duplicates and handling missing values
-
Data validation and conditional formatting
Unit 3: Basic Formulas and Functions
-
Arithmetic and logical functions (SUM, AVERAGE, IF, COUNTIF)
-
Text functions (LEFT, RIGHT, CONCATENATE, TRIM)
-
Lookup functions (VLOOKUP, HLOOKUP, INDEX-MATCH)
Unit 4: Data Visualization in Excel
-
Creating charts and graphs (bar, line, pie, scatter plots)
-
Formatting and customizing visual elements
-
Using PivotCharts for dynamic visualization
Unit 5: Descriptive Statistics and Basic Analysis
-
Understanding measures of central tendency and dispersion
-
Using Excel’s built-in statistical functions (MEAN, MEDIAN, MODE, STDEV, CORR)
-
Introduction to PivotTables for summarizing data
Unit 6: Introduction to Data Analysis Tools in Excel
-
Using Goal Seek and Data Tables for analysis
​
Target audience
-
Researchers with various disciplines
-
Graduate/PG students
-
Professionals looking to enhance data analysis skills
-
Entrepreneurs and business analysts
-
Anyone interested in learning basic data analysis using Excel
​
Benefits
Training
Certificate of participation
Need-based support for one month after the completion of workshop
​