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
-
