Statistics with Excel: learn & practice

Language: German

Statistics with Excel - learn and practice in practice

The goal is to reach 100 points! Will you accept the challenge? Start this four-hour Excel course by Fabio Basler. Learn important methods of descriptive and inductive statistics using three practical case studies. And: test yourself with the help of the included work materials! What you learn now, you can apply directly in your studies and job tomorrow.

Statistics with Excel using three practical case studies
Practical learning and practicing: point system for learning control, collection of formulas, raw data and solutions
Descriptive and inductive statistical methods examined in detail in over 4.5 hours by Fabio Basler
Among other things: Time series, forecasts, distribution tests, mean and dispersion, normal distribution test

Data sets with dozens of parameters and hundreds of values? With this training, you can manage them and draw valuable insights from them ... get started right away.

Details

Usable with:
content: 5 h Video training
Licence: private and commercial Rights of use
Bonus: including working material

Introduction

free of charge

Statistics with Excel: 1.1 What to expect

Introduction to the case study

download project file

Statistics with Excel: 1.2 Introduction Case Study Collection

This collection of case studies serves as an exercise and consolidation of the main areas of descriptive and inductive statistics. The collection consists of the three individual case studies (1) portfolio management, (2) automotive suppliers and (3) biotechnology. The statistics modules in the case studies can be deepened in a targeted manner using practical data.

Case study portfolio management

Statistics with Excel: 2.1 Introduction to the portfolio management case study

Portfolio management case study

download project file

Statistics with Excel: 2.2 Mean value analysis in Excel

Performing a mean value calculation in Excel

download project file

Statistics with Excel: 2.3 Scatter analysis in Excel

Carrying out a spread ratio analysis in Excel

download project file

Statistics with Excel: 2.4 Correlation analysis in Excel (Part 1)

Calculation of Pearson's correlation coefficient in Excel Part 1

download project file

Statistics with Excel: 2.5 Correlation analysis in Excel (Part 2)

Calculation of Pearson's correlation coefficient in Excel Part 2

download project file

Statistics with Excel: 2.6 Rank correlation analysis in Excel

Calculation of the rank correlation according to Spearman in Excel

download project file

Statistics with Excel: 2.7 Boxplot analysis in Excel

Graphical visualization of a box chart in Excel

download project file

Statistics with Excel: 2.8 Data classification and frequency analysis in Excel

Classification of data and quantification of frequencies in interval limits

download project file

Statistics with Excel: 2.9 Regression analysis in Excel

Implementation of a linear functional relationship using multiple regression

download project file

Statistics with Excel: 2.10 Chi-square fit test for normal distribution in Excel

Test for normal distribution using the chi-square goodness-of-fit test

download project file

Case study automotive supplier

Statistics with Excel: 3.1 Introduction to the automotive supplier case study

Automotive supplier case study

download project file

Statistics with Excel: 3.2 Visualization of the time series in Excel

Graphical visualization of a time series in Excel

download project file

Statistics with Excel: 3.3 Determining the trend function and forecast estimation in Excel

Trend estimates based on forecasts

download project file

Statistics with Excel: 3.4 Determining trends after exponential smoothing in Excel

Trend estimation using the exponential smoothing method in Excel

download project file

Statistics with Excel: 3.5 Error analysis and quality estimation in Excel

Use of time series analysis methods

download project file

Statistics with Excel: 3.6 Contingency analysis in Excel

Calculation of correlations in Excel using two-dimensional frequencies

download project file

Case study biotechnology

Statistics with Excel: 4.1 Introduction to the biotechnology case study

Biotechnology case study

download project file

Statistics with Excel: 4.2 1-SP test for the expected value with known variance in Excel

1-SP test for the expected value with known variance in Excel

download project file

Statistics with Excel: 4.3 1-SP test for the proportion value in Excel

1-SP test for the proportional value in Excel

download project file

Statistics with Excel: 4.4 1-SP test for the expected value with unknown variance in Excel

1-SP test for the expected value with unknown variance in Excel

download project file

Statistics with Excel: 4.5 1-SP test for variance in Excel

1-SP test for the variance in Excel

download project file

Statistics with Excel: 4.6 Two-sample t-test in Excel

Two-sample t-test in Excel

download project file

Statistics with Excel: 4.7 2-SP test for the difference between two proportion values in Excel

2-SP test for the difference between two proportion values in Excel

download project file

Statistics with Excel: 4.8 Two-sample F-test in Excel

Two-sample F-test in Excel

download project file

Outro

Statistics with Excel: 5 Outro

Summary

Details of the content

Perfect for your studies and job: Statistics with Excel using three case studies
Do your university exams require knowledge of statistics? Would you like to uncover even more optimization potential for your company in your job? Then you've come to the right place! Firstly, you will learn how to apply important statistical techniques . And secondly, you'll get hands-on practice from the very first tutorial. Start this Excel course now !

Learn and practise with practical exercises

The case studies in the Excel statistics training course are consistently geared towards practice. For example, you will delve deep into the portfolio of a hardware company to analyze sales figures from 500 stores. At an automotive supplier, you will look at the production figures of various teams over several years. Finally, you will take a detailed look at the key figures for active ingredients at a biotechnology company.

Whether it's product range analysis, sales success or process optimization - work through the case studies step by step and apply what you've learned directly for your own purposes. To make this quick and easy for you, you will receive a summary of the topics, a collection of formulas, the exercises and all raw data as well as the solutions to the exercises to accompany the course. On top of this, a points system serves as a personal learning success control.

Descriptive and inductive statistics with Excel

In the area of descriptive statistics , you will encounter mean value and scattering figures, among other things, during the training. You will focus on regression analysis, establish correlations and look at correlation measures. In the field of inductive statistics , you will carry out time series analyses as well as hypothesis and distribution tests. You will also evaluate the quality of error estimates and determine trends, for example.

Use the video course to get started in statistics with Excel , to deepen your existing knowledge or to refresh it. This will prepare you efficiently for statistics exams and teach you how to read your company's data correctly in order to optimize processes and evaluate the portfolio.

Tip: If you would like to delve deeper into the subject, take a look at our Excel training courses on data analysis and evaluating questionnaires.