Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Aggregating Data in Excel
- Statistical Functions
- Outlines
- Subtotals
- Pivot Tables
Data Relation Analysis
- Normal Distribution
- Descriptive Statistics
- Linear Correlation
- Regression Analysis
- Covariance
Analysing Data in Time
- Trends/Regression line
- Linear, Logarithmic, Polynomial, Power, Exponential, Moving Average Smoothing
- Seasonal fluctuations analysis
Comparing Populations
- Confidence Interval for the Mean
- Test of Hypothesis Concerning the Population Mean
- Difference Between Mean of Two Populations
- ANOVA: Analysis of Variances
- Goodness-of-Fit Test for Discrete Random Variables
- Test of Independence: Contingency Tables
- Test Hypothesis Concerning the Variance of Two Populations
Forecasting
- Extrapolation
Requirements
Participants should be familiar with the basics of Excel and Statistics.
14 Hours