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

Number of participants



Price per participant

Testimonials (7)

Related Courses

ArcGIS for Spatial Analysis

14 Hours

ArcMap in ArcGIS

14 Hours

ArcGIS Pro for Spatial Analysis

14 Hours

ArcGIS with Python Scripting

14 Hours

QGIS for Geographic Information System

21 Hours

Advanced Data Analysis with TIBCO Spotfire

14 Hours

Introduction to Spotfire

14 Hours

AI-Driven Data Analysis with TIBCO Spotfire X

14 Hours

Data Analysis with SQL, Python and Spotfire

14 Hours

Sensu: Beginner to Advanced

14 Hours

Monitoring Your Resources with Munin

7 Hours

Automated Monitoring with Zabbix

14 Hours

Fluentd for Log Data Unification

14 Hours

Nagios Certified Administrator Preparation

21 Hours

Advanced Nagios

21 Hours

Related Categories

1