One Week STTP on Recent Trends in data Analysis in MS Excel (Online Mode)
08 - 13 February 2021
Organized by
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/.
Course Content
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,
Resource Person
https://smu.edu.in/smit/dept-faculty/faculty-list/ranjan-kmr-ghadai.html
Dr. Kanak Kalita, Asst. Prof., VelTech University, Chennai.
https://kanakkalita-com.webnode.com/
Important Dates
Registration Cost
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.
Bank details:
Account name: M. Murugammal
Account no: 35324345531
Bank: State Bank of India, Kaveripattanam
IFSC code: SBIN0007463