Statistical Data Analysis with EXCEL


The course provides participants with an introduction to using Excel to import, export data, produce descriptive statistics, hypothesis testing,ANOVA and regression. You must cover basic statistical theory.

You will receive copies of the PowerPoint slides used in the presentations and suggested reading lists which can be provided by DEPOCEN.

Duration: 1 day

Course Content:

Following an overview of the main features of this course and an introduction to essential terminology, you will proceed logically through the following:

Lecture 1: Introduction to MS Excel
Building a database
Import and export data into a sheet of Excel
Functions for basic statistics

Lecture 2: Descriptive Statistics
Data analysis tools
  Using the descriptive statistics tool
  Building confidence interval
Creating a Histogram
Generating random numbers
Sampling data

Lecture 3: Hypothesis Testing and ANOVA
Creating a Scatter Plot
Z-testing for population means when population variances are known
T-testing means when the two samples are from distinct groups
Paired Sample T-tests

Lecture 4: Relations and Regression
Linear Regression Analysis

Course Instructor:
Doan Quang Hung is the instructor of the course. He is an experienced expert in using Excel for data analysis, STATA, CsPro.

Preparatory Reading:
The following are recommended as background reading that will help participants to understand and get the most out of this course: 

Excel for data analysis, Nguyen Ngoc Anh and Nguyen Dinh Chuc, Published by DEPOCEN. «« Download
 Excel 2007 data analysis for dummies, Stephen L.Nelson, Published by Wiley Publishing, 2007
Statistical Analysis with Excel, Vijay Gupta, Published by VJ Books Inc, Canada; 2007.

DEPOCEN Traning Series
Education counsellor: Ms Thanh Thuy
Tel: +84-4-39367542 / +84-4-39351419
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.
Development and Policies Research Center
Rooms 305 -307, 3rd floor, 12 Trang Thi Str., Hoan Kiem District, Hanoi (Inside The First Restaurant)

This month
All days
Our client
CONEMUND PLAN FHI 360 Jica MCNV PSI ActionAid idrc Save the Children UK UK Embassy esrc VASS AusAID UNICEF National Council for Science and Technology Policy Caritas APEC Secretariat eria IFAD UNIDO ILO Oxfam Chemonics The Asia Foundation British Council DFID UN-Women undp World Bank
Contact us
Development and Policies Research Center
Add: Suite 305-307, 12 Trang Thi Street, Hanoi, Vietnam, Tel: 04-39351419 | Fax: 04-39351418