Excel For Statistical Data Analysis Training Course

Book Public Course Now!Get closed/on-site Course Quote!Get distance Course Quote!
ID:
2706
Duration: 
16 hours
Tags: Excel, Statistics

Overview

Audience

Analysts, researchers, scientists, graduates and students and anyone who is interested in learning how to facilitate statistical analysis in Microsoft Excel.

Course Objectives

This course will help improving your familiarity with Excel and statistics and as a result increase the effectiveness and efficiency of your work or research.

This course describes how to use the Analysis ToolPack in Microsoft Excel, statistical functions and how to perform basic statistical procedures. It will explain what Excel limitation are and how to overcome them.

 

Requirements

The should be familiar with the basics of Excel and Statistics.

Courses You May Take Before The Course

Training 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, Polynominal, 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

Introduction to Forecasting

 

Training Course Dates

No public course dates have been created for this course. Please contact us and we will arrange one for you.