An Interdisciplinary Research Society

Recent Trends in data Analysis in MS Excel

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

All Registered participants will get both Soft copy and Hard copy  Course Completion Certificate and those who got 50℅ scores in the final online Exam will get Qualified the Exam certificate and Topperswill get Topper in  Exam certificate and lifetime membership of RSRI Society. Participants once paid and registered through google form will be added to the WhatsApp group of Workshop within 12 hours from the time of registration. All the instructions, the link of Prerecorded videos, the link of the Mock exam, the link of the final exam, and the link for downloading the Softcopy certificate will be shared through the WhatsApp group only. There will not be any email confirmations. All queries will also be addressed through WhatsApp (WhatsApp no: 9025493434) only. Participants can use the WhatsApp group discussion platform for asking the questions related to lectures and all valid questions will be addressed through a video.

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

Dr. Ranjan Ghadai, Asst. Prof., Sikkim Manipal University, Sikkim
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

Last Date of Registration: 07/02/2021.
Result Declaration: 15/02/2021.
Distribution of  Softcopy certificate: 19/02/2021.
Distribution of Hardcopy Certificate: 28/02/2021.

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

Registration

Interested person can register for the workshop through below google form