Statistics with Excel - learn and practice in practice Language: German

Statistics with Excel - learn and practice in practice

Office, Business, Marketing & Sales · 27 Videos · 4.6 h Video training · German Fabio Basler by Fabio Basler

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.

content

27 Videos, 276 minutes

Introduction

2 Videos · 9 minutes
01 Open free of charge

Statistics with Excel: 1.1 What to expect

2 min

Introduction to the case study

02 Open

Statistics with Excel: 1.2 Introduction Case Study Collection

7 min

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

10 Videos · 109 minutes
03 Open

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

6 min

Portfolio management case study

04 Open

Statistics with Excel: 2.2 Mean value analysis in Excel

8 min

Performing a mean value calculation in Excel

05 Open

Statistics with Excel: 2.3 Scatter analysis in Excel

11 min

Carrying out a spread ratio analysis in Excel

06 Open

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

8 min

Calculation of Pearson's correlation coefficient in Excel Part 1

07 Open

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

5 min

Calculation of Pearson's correlation coefficient in Excel Part 2

08 Open

Statistics with Excel: 2.6 Rank correlation analysis in Excel

11 min

Calculation of the rank correlation according to Spearman in Excel

09 Open

Statistics with Excel: 2.7 Boxplot analysis in Excel

9 min

Graphical visualization of a box chart in Excel

10 Open

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

12 min

Classification of data and quantification of frequencies in interval limits

11 Open

Statistics with Excel: 2.9 Regression analysis in Excel

19 min

Implementation of a linear functional relationship using multiple regression

12 Open

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

20 min

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

Case study automotive supplier

6 Videos · 68 minutes
13 Open

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

5 min

Automotive supplier case study

14 Open

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

5 min

Graphical visualization of a time series in Excel

15 Open

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

12 min

Trend estimates based on forecasts

16 Open

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

11 min

Trend estimation using the exponential smoothing method in Excel

17 Open

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

11 min

Use of time series analysis methods

18 Open

Statistics with Excel: 3.6 Contingency analysis in Excel

24 min

Calculation of correlations in Excel using two-dimensional frequencies

Case study biotechnology

8 Videos · 89 minutes
19 Open

Statistics with Excel: 4.1 Introduction to the biotechnology case study

8 min

Biotechnology case study

20 Open

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

16 min

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

21 Open

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

13 min

1-SP test for the proportional value in Excel

22 Open

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

10 min

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

23 Open

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

10 min

1-SP test for the variance in Excel

24 Open

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

13 min

Two-sample t-test in Excel

25 Open

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

9 min

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

26 Open

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

10 min

Two-sample F-test in Excel

Outro

1 Video · 2 minutes
Comments (0)

Comment now „Statistics with Excel - learn and practice in practice“