An Interdisciplinary Research Society

Data Analysis for Research in Excel

One Week STTP on Data Analysis for Research in MS Excel                     29 June 2020- 04 July 2020 (Online Mode)

                                   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 60℅ 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 29/06/2020 (Monday) to (04/07/2020 (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 04/07/2020 (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/

Dr. Nivetha Martin,

Important Dates

Last Date of Registration: 27/06/2020.
Result Declaration: 06/07/2020.
Distribution of  Softcopy certificate: 10/07/2020.
Distribution of Hardcopy Certificate: 30/07/2020 (Due to lockdown).

Registration

Interested person can register for the workshop through below google form
or