Excel For Statistical Data Analysis Training Course

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