One Week STTP on Recent Trends in data Analysis in MS Excel (Online Mode)
08 - 13 February 2021
REST Society for Research International (RSRI)
About the Workshop
Schedule of workshop
The workshop is scheduled in the evening time from 4-7 pm from 01/02/2021 (Monday) to (06/02/2021 (Saturday). However, participants can watch videos(since it is pre-recorded) and give the mock exam as per their Convenient time. Every day 2 hours lecture, 30 minutes for WhatsApp group discussion, and 30 minutes for the mock exam (10 MCQ). The final Qualifying exam (40 MCQ) will be on 06/02/2021 (Saturday) from 6-7 pm and if anyone missing the final exam then you can give an exam along with re-exam participants without any additional charges. If any participants want to go for Re-exam to improve the score, then he/she have to pay Rs. 80/.
Introduction to MS Excel environment,
Importing data and recoding variables,
Making data visualizations,
Analyzing data with Pivot tables,
Computing frequencies and correlations,
Measures of Central Tendency and Dispersion,
Create and Edit Graphs,
Charts, and Plots, Normality Test,
ANOVA, Pearson Correlation,
Spearman Ranked Order Correlation,
Kendall's Tau B Correlation,
Point Bi-Serial Correlation,
Independent Samples T-test,
Paired Samples T-test, Chi-Square,
Linear Regression, Multiple Regression,
What-if analysis? Forecasting,
Sampling, Fourier analysis,
Dr. Kanak Kalita, Asst. Prof., VelTech University, Chennai.
For RSRI Member - Rs. 300.
For Non-RSRI Member - Rs.350
Registration costs can be paid through Paytm, Google Pay, and Phonepe with mobile no 9025493434.
Account name: M. Murugammal
Account no: 35324345531
Bank: State Bank of India, Kaveripattanam
IFSC code: SBIN0007463