2nd Workshop

Data Analysis using Microsoft Excel

Three Days Workshop For Faculty and Students

View More
About Event

The 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

Coordinator

Mrs. Ashwini Shinde

Assistant Professor

Coordinator

Dr. Varsha Harpale

Associate Professor



Event Speakers

Speaker

Dr. Varsha Harpale

Associate Professor

Speaker

Dr. Leena Sharma

Associate Professor

Speaker

Mrs. Ashwini Vaze

Assistant Professor

Speaker

Mrs. Minakshi Panchal

Assistant Professor

Speaker

Mr. Dinesh Kute

Assistant Professor


Event Schedule

Day 1: Wednesday, 14th July 2021

Mrs. Ashwini Vaze

Mrs. Ashwini Vaze

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

Mr. Dinesh Kute

Mr. Dinesh Kute

Correlation, Covariance, Regression analysis using the data Analysis Tool in Excel.

Day 2: Thursday, 15th July 2021

Dr. Leena Sharma

Dr. Leena Sharma

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

Mrs. Minakshi Panchal

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

Dr. Varsha Harpale

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

Dr. Leena Sharma

Dr. Leena Sharma

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

Day 4: Saturday, 17th July 2021

Day 5: Sunday, 18th July 2021

Day 6: Monday, 19th July 2021

Day 7: Tuesday, 20th July 2021