At the end of this course, the participants should be able to:

• Understand the importance of statistics for Administrators.
• Become familiar with the most used statistical terminologies
• Use Microsoft Excel
• Evaluate statistical tables and use it to make decisions
• Interpret charts to make informed decisions
• Use correlations and regression analysis
• Measure and track performance and efficiency

Terminologies and Concepts of Statistics

• Definition of statistics
• Branches of statistics
• Importance of statistics to Administrators
• Data
• Population and sample
• Variables
• Sources of data
• Data collection methods
• Questionnaire design
• Types of sampling
• Sampling errors
• Determining sample size

Using Excel Application

• Components of Excel window
• Saving files in Excel
• Cells organization
• Mathematical Functions and Equations in Excel

Using Statistical Tables for Decision Making

• Introduction
• Histogram for Qualitative Data
• Histogram for Quantitative Data

Using Charts for Decision  Making

• Importance of charts and data presentations
• Types of charts in Excel
• Bar Chart
• Line Chart
• Pie Chart

Using Descriptive Statistics

• Definition of Descriptive Statistics
• Measures of Central Tendency
• Average (Mean) & Median & Mode
• Quartile Percentages
• Measures of Variation
• Range
• Variance
• Standard Deviation

Correlation and Regression

• Correlation
• Linear Regression

Measuring Performance and Efficiency

• Measuring performance
• Types of performance indicators
• Efficiency
• Effectiveness
• Productivity
• Multifactor productivity
• Measuring changes in productivity