Develop specific knowledge and skills in data collection and analysis by learning scientific methodologies and using essential statistical measurements that will make your data meaningful, simple, and ready to report and make decisions upon. In addition you will be able to use important functions in Excel and SPSS that are beneficial for data analysis and interpretation.

Course Objectives:

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

• Understand the concept, fundamentals, and terminologies of statistics.
• Realize the difference between data and information.
• Collect necessary data using different tools and methods
• Prepare and structure a questionnaire that fulfills the customers’ requirements.
• Simplify and summarize data using descriptive statistics
• Analyze data using formulas and data analysis function in Excel
• Define variables in SPSS and enter create data base
• Plot data on different types of charts using Excel.

Target Audience:

All employees responsible for collecting and analyzing data, including accountants, finance and business professionals, as well as employees working in planning and performance monitoring, quality, and operations departments, and for those who are interested in market research studies and questionnaire design

• Data Analysis
• Collecting data
• Data Analysis
• Data Collection
• Decision Making
• Analytical thinker
• Resource Forecasting
• Questionnaire Design
• Measuring performance
• Microsoft Excel
• SPSS
• Technical Report Writing

Course Methodology:

This training course will be carried out through the use of best practices and the right combination of engaging and purposeful tools such as:

• Practical, relevant case studies
• Group activities and workshops
• Related role plays
• Experiential learning
• Brainstorming
• Stimulating mental activities
• Engaging team competitions
• Suitable training Videos
• Presentations
• Self–assessments
• Learning with Simulations and Games

Concept of Statistics & Importance

• Types of data
• Sources of data
• Data collection techniques
• Data collection methods

Sampling Techniques

• Probability sampling
• Non-probability sampling
• Determination of sample size

Questionnaire Design

• Types of questions
• Types of measurement scales
• Testing a validity and reliability of questionnaire

Introduction to( SPSS )

• SPSS menu
• Data coding and entry
• Data tabulation and charting.

Descriptive Statistics

• Measures of central tendency
• Measures of variation
• Using Excel to apply descriptive statistics
• Using Excel to plot and draw data

Regression and Correlation

• Simple correlation analysis
• Simple linear regression analysis

Forecasting

• Methods of forecasting
• Simple moving average
• Weighted moving average
• Determining the best forecasting method