Excel: Data-analyses, Simulations and Statistic functions

Prerequisites:

Experience with the topics in Excel, knowledge about functions and databases in Excel.

Purpose of the training:

This training covers key topics of Excel that are not covered in the training Excel Basic and Excel Advanced.
Important decisions are often made on the basis of the available data. Excel offers a range of highly sophisticated features to implement based on available data simulations, (statistical ) analysis and scenarios.
The techniques and functions may be used to unravel various types of complex business issues, and to find optimal solutions.

Content:

Goal seek:

  • Purpose and simulations with goal seek

Solver:

  • Purpose of solver
  • Examples solver

Scenario's:

  • Purpose of scenario’s
    Method

Basic statistical functions:

Overview of te basic statistical functions van the basisfuncties:

  • Average/ Averagea
  • Geomean
  • Median
  • Rank, Mode, Small, Large

frequency distribution
 

  • The function Frequency
  • The function frequency in a matrix
  • Frequency in the analyses add-in

Functions to compare data:

  • The function Var and VarA
  • The function Stdev and Stdeva
  • The function Covar (with and without data analyses)
  • The function Correl (with and without data analyses)

Forecasting and prognoses:

  • The function Forecast
  • Trends
  • The function Growth

Probability (optional)

  • Permutations
  • Probability in a normal distribution
  • Probability in a Binomial distribution
  • Rand function

Analysis Toolpak

  • Descriptive statistics in Analysis Toolpak
  • Moving average
  • Samples

 

Practical information

Date:

1 day: 3 Feb. 2020

Hours:

9h30 till 17h00

Location: 

Stadscampus - Building P - Room P.117

Teacher:

Bit by Bit

Language of the course:

English

Docop-points:

This course counts for 0,7 docop-points.

Registration:

via Sisa Selfservice. Log in with your student account.