https://growinnova.com/event/statistical-analysis-in-excel/
Basan Shrestha, Trainer
Introduction: This is an era of data and visualization. Organizations and professionals need
data to inform decision making and planning. Statistics is a science of
collecting, measuring, analyzing, and visualizing data. Excel is a widely
available computer application with a vast potential to compile, analyze and
visualize data. The web-based communication technologies have availed distant
learning and sharing opportunities. Besides, the ongoing COVID-19 pandemic has
restricted movement and social gathering. In this context, GrowInnova is
hosting an online training on "Statistical Analysis in Excel".
Training Objectives: The main objective of the training is to provide knowledge and hands-on
practical skill on statistical data analysis using a spreadsheet. The specific
objectives are to introduce:
1.
knowledge on nature of
data and data entry techniques
2.
descriptive statistical
functions to measure centrality and spread of data
3.
statistical functions to
measure association among variables
4.
inferential statistics
related functions for hypothesis testing
5.
graphical measures to
visualize data
Contents
· Data and database management
(data type, data recording format, variable and table naming convention, data
validation)
· Descriptive statistics (frequency
distribution, measures of central tendency and dispersion)
· Distribution functions
(Binomial distribution, Normal distribution)
· Correlation
· Regression (bivariate and
multivariate)
· Cross tabulation and non-parametric
test (Chi-square test)
· Parametric tests (T-Test,
One-Way-ANOVA)
· Graphical presentation (Pie
chart, Bar diagram, Line chart, Combo)
Potential Participants: The course is appropriate for M&E professionals, data analysts, managers,
development workers, and students as well as individuals who are involved and
interested in research and development.
Course Fee: NPR. 1500 (Nepalese rupees one thousand and five hundred
only).
Date: 1 to 3 October 2020.
Time: 17:00 – 19:00 Nepal Time (GMT+05:45).
Registration: Numbers of seats for the training are limited, register soon to secure a seat. Please fill out this online form to book your seat:
https://forms.gle/Z1BUdJezZrSGMfcSA
Deadline: 25 September 2020.
Contact:
Asha Ram Gurung, Director of Training
and Capacity Building, asha@growinnova.com, 9851230438
Basan Shrestha, Trainer, basanshrestha@hotmail.com, basanshrestha70@gmail.com, 9841885457