Basic Statistical Analysis Using MS Excel 

 

Deals with methods of collecting, organizing, presenting and summarizing data.  Course coverage includes how sets of data are organized into tables, graphs and charts, and how such data can be effectively summarized. The course illustrates the art and science of presenting data into meaningful statistical information.

The course includes lectures, where concepts and methods are presented, discussed, and applied on real data using MS Excel and PhStat; interaction with participants for clarifications; hands-on exercises and group/workshop outputs for presentation on the last day of the course.

Course Aim

The course shall provide basic knowledge in data organization, presentation. and enhance skills in interpreting statistical results. In the end, participants should be able to identify various types of data and sources, describe data collection procedure, construct statistical tables and graphs for various types of data, compute descriptive statistical measures, analyze various types of data using rates, ratio and proportion, use index number to analyze and interpret data and prepare a statistical report using descriptive statistics.

Course Participants

Recommended for personnel involved or will be involved in summarizing, tabulating, presenting and interpreting statistical data. Background in statistics is not necessary but would be helpful.

Course Coverage

Introduction to Statistical Concepts
Measures of Averages
Measures of Dispersion
Variance and Standard Deviation
Ratio, Proportion and Percentages
Quartiles and Percentiles
Exploratory Data Analysis
Tabular Data Presentation Techniques
Case Analysis

Course Duration: 36 hours/5 days

Registration:

To register and further inquiry, please contact the Training Division at Telefax Nos. (632) 436-1426/9297543 or email it to japebenito@srtc.gov.ph or cemojica@srtc.gov.ph

.