Statistical Data Analysis with EXCEL

Z-testing for population means when population variances are known
T-testing means when the two samples are from distinct groups



Overview:

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
ANOVA


Lecture 4: Relations and Regression
Relations
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.


FOR MORE DETAILS, PLEASE CONTACT US AT:
DEPOCEN Traning Series
Education counsellor: Ms Thanh Thuy
Tel: +84-4-39367542 / +84-4-39351419
Email: training@depocen.org
Development and Policies Research Center
Rooms 6-7-8, 2nd floor, 216 Tran Quang Khai, Hoan Kiem district, Hanoi (Inside Vietnam Revolution Museum)