2nd Workshop
Data Analysis using Microsoft Excel
Three Days Workshop For Faculty and Students
View MoreThe role of statistics in research for collecting and analyzing small or large scale data is significant. Statistics is a branch of mathematics used to demonstrate research findings, support hypotheses, give credibility to research methodology and draw conclusions. It helps the researcher in understanding how to plan, conduct and evaluate the research. The workshop will detail the selection of statistical methodology, includes a selection of suitable measures or parameters, a selection of evaluation methodology and analyzing data for drawing reliable conclusions by defining appropriate system models.
Platform: Cisco Webex
From: 14th Jul 2021
To: 16th Jul 2021
Time: 05:15 PM
To: 06:15 PM
Event Coordinators

Mrs. Ashwini Shinde
Assistant Professor

Dr. Varsha Harpale
Associate Professor
Event Speakers

Dr. Varsha Harpale
Associate Professor

Dr. Leena Sharma
Associate Professor

Mrs. Ashwini Vaze
Assistant Professor

Mrs. Minakshi Panchal
Assistant Professor

Mr. Dinesh Kute
Assistant Professor
Event Schedule
Day 1: Wednesday, 14th July 2021

Mrs. Ashwini Vaze
Introduction to data Analysis, descriptive statistics, Measures of Central Tendency and Dispersion.

Mr. Dinesh Kute
Correlation, Covariance, Regression analysis using the data Analysis Tool in Excel.
Day 2: Thursday, 15th July 2021

Dr. Leena Sharma
Case study on descriptive Statistics using the data analysis tool in Excel.

Mrs. Minakshi Panchal
Sampling techniques and its types, case study on sampling using the data analysis tool in Excel.
Day 3: Friday, 16th July 2021

Dr. Varsha Harpale
Hypothesis testing (T-Test, F-Test, Z-Test, Chi-Square test) using the data analysis tool in Excel.

Dr. Leena Sharma
Case study on Hypothesis Test (One-way ANOVA, Two-way ANOVA).