Course not currently available

Excel For Statistical Data Analysis

Nobleprog Limited

Course

In Glasgow ()

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Class hours

    14h

Suitable for: Participants should be familiar with the basics of Excel and Statistics.

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Confidence Training
  • Forecasting
  • Excel
  • Microsoft Excel
  • Spreadsheet
  • Data analysis
  • Statistics
  • MS Excel
  • Excel Sheet
  • Excel Formula

Course programme

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

See related categories

Excel For Statistical Data Analysis

Price on request

The best Excel courses

See all

See all