Excel For Statistical Data Analysis Training Course

Primary tabs

Course Language

This course is delivered in Polish or English.

Course Code

excelstatsda

Duration Duration

14 hours (usually 2 days including breaks)

Requirements Requirements

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

Overview 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 improve 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.

Course Outline 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

Guaranteed to run even with a single delegate!
Public Classroom Public Classroom
Participants from multiple organisations. Topics usually cannot be customised
From 1730PLN
(76)
Private Classroom Private Classroom
Participants are from one organisation only. No external participants are allowed. Usually customised to a specific group, course topics are agreed between the client and the trainer.
From 1730PLN
Request quote
Private Remote Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet
From 3990PLN
Request quote
SelfStudy SelfStudy
Self-study courses allow you to learn at your own pace on your own time. There is no live instructor involved. The participants use recorded video, quizzes and reading at their own convenience.
Price not set yet
Register Interest

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Public Classroom Private Classroom Private Remote
1 1730PLN 1730PLN 3990PLN
2 1365PLN 1265PLN 2395PLN
3 1243PLN 1110PLN 1863PLN
4 1183PLN 1033PLN 1598PLN
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories


Course Discounts

Course Venue Course Date Course Price [Remote/Classroom]
Visual Basic for Applications (VBA) for Analysts Poznan, Garbary Mon, 2016-07-04 09:00 1912PLN / 1278PLN
Debian Administration Poznan, Garbary Mon, 2016-07-04 09:00 3157PLN / 2083PLN
Agile Project Management with Scrum Szczecin Wed, 2016-07-06 09:00 1746PLN / 1361PLN
A Practical Guide to Successful Pricing Strategies Poznan, Garbary Wed, 2016-07-06 09:00 1427PLN / 1093PLN
SQL language in MSSQL Poznan, Garbary Thu, 2016-07-07 09:00 1568PLN / 1142PLN
Excel and VBA Programming for Audit and Finance Professionals Warszawa, ul. Złota 3/11 Mon, 2016-07-11 09:00 1913PLN / 1441PLN
Introduction to Selenium Wrocław, ul.Ludwika Rydygiera 2a/22 Thu, 2016-07-14 09:00 768PLN / 539PLN
Forecasting with R Poznan, Garbary Thu, 2016-07-14 09:00 2188PLN / 1527PLN
Machine Learning Fundamentals with R Warszawa, ul. Złota 3/11 Mon, 2016-07-18 09:00 2523PLN / 1828PLN
Administracja bazą danych Microsoft SQL Server 2012 Toruń, ul. Żeglarska 10/14 Mon, 2016-07-18 09:00 2509PLN / 1653PLN
Apache Tomcat Administration Kraków Mon, 2016-07-18 09:00 1713PLN / 1438PLN
Effective working with spreadsheet in Excel Gdańsk Tue, 2016-07-19 09:00 768PLN / 652PLN
ITIL®: Intermediate Lifecycle Stream: Service Strategy (SS) Kraków Tue, 2016-07-19 09:00 4338PLN / 3116PLN
Microsoft Access - download the data Poznan, Garbary Wed, 2016-07-20 09:00 1117PLN / 856PLN
Debian Administration Olsztyn, ul. Kajki 3/1 Mon, 2016-07-25 09:00 3157PLN / 2167PLN
Python Programming Warszawa, ul. Złota 3/11 Mon, 2016-08-01 09:00 5790PLN / 3753PLN
Data Analysis with Oracle 11g - workshop Warszawa, ul. Złota 3/11 Mon, 2016-08-01 09:00 4350PLN / 3012PLN
Web Application Development in PHP Warszawa, ul. Złota 3/11 Wed, 2016-08-03 09:00 2688PLN / 2022PLN
Zapewnienie jakości oprogramowania – przegląd metodyk Warszawa, ul. Złota 3/11 Tue, 2016-08-09 09:00 2735PLN / 1863PLN
Oracle 11g - Programming with PL / SQL II Wrocław, ul.Ludwika Rydygiera 2a/22 Wed, 2016-08-10 09:00 2363PLN / 1785PLN
Stress management Warszawa, ul. Złota 3/11 Thu, 2016-08-18 09:00 2112PLN / 1212PLN
Java Spring Kraków Mon, 2016-08-29 09:00 7039PLN / 5245PLN
Java Spring Szczecin Mon, 2016-09-05 09:00 7039PLN / 5044PLN
Programming in WPF 4.5 Warszawa, ul. Złota 3/11 Mon, 2016-09-05 09:00 2359PLN / 1355PLN
Building Web Apps using the MEAN stack Szczecin Mon, 2016-09-12 09:00 4788PLN / 3124PLN
Java Spring Gdańsk Mon, 2016-09-12 09:00 7039PLN / 5153PLN
Java Spring Poznan, Garbary Mon, 2016-09-12 09:00 7039PLN / 4961PLN
Java Spring Wrocław, ul.Ludwika Rydygiera 2a/22 Mon, 2016-09-19 09:00 7039PLN / 4961PLN
Java Spring Warszawa, ul. Złota 3/11 Mon, 2016-09-19 09:00 7039PLN / 4961PLN
BPMN 2.0 for Business Analysts Wrocław, ul.Ludwika Rydygiera 2a/22 Tue, 2016-09-27 09:00 3110PLN / 2337PLN
Visual Basic for Applications (VBA) in Excel - Advanced Białystok, ul. Malmeda 1 Mon, 2016-11-14 09:00 1689PLN / 1413PLN

Upcoming Courses

VenueCourse DateCourse Price [Remote/Classroom]
KrakówMon, 2016-07-18 09:001598PLN / 1199PLN
Zielona Góra, ul. Reja 6Wed, 2016-07-20 09:001598PLN / 1095PLN
Olsztyn, ul. Kajki 3/1Thu, 2016-07-21 09:001598PLN / 1112PLN
KielceWed, 2016-07-27 09:001598PLN / 1170PLN
Poznan, GarbaryThu, 2016-07-28 09:001598PLN / 1066PLN

Some of our clients