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 · English 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

Introduction to the case study

02 Open

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.

01

Statistics with Excel: 1.1 What to expect

2 min Open
02

Statistics with Excel: 1.2 Introduction Case Study Collection

7 min Open

Case Study Portfolio Management

10 Videos · 109 minutes
03 Open

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

Portfolio management case study

04 Open

Statistics with Excel: 2.2 Mean value analysis in Excel

Performing a mean value calculation in Excel

05 Open

Statistics with Excel: 2.3 Scatter analysis in Excel

Carrying out a spread ratio analysis in Excel

06 Open

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

Calculation of Pearson's correlation coefficient in Excel Part 1

07 Open

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

Calculation of Pearson's correlation coefficient in Excel Part 2

08 Open

Statistics with Excel: 2.6 Rank correlation analysis in Excel

Calculation of the rank correlation according to Spearman in Excel

09 Open

Statistics with Excel: 2.7 Boxplot analysis in Excel

Graphical visualization of a box chart in Excel

10 Open

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

Classification of data and quantification of frequencies in interval limits

11 Open

Statistics with Excel: 2.9 Regression analysis in Excel

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

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

03

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

6 min Open
04

Statistics with Excel: 2.2 Mean value analysis in Excel

8 min Open
05

Statistics with Excel: 2.3 Scatter analysis in Excel

11 min Open
06

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

8 min Open
07

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

5 min Open
08

Statistics with Excel: 2.6 Rank correlation analysis in Excel

11 min Open
09

Statistics with Excel: 2.7 Boxplot analysis in Excel

9 min Open
10

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

12 min Open
11

Statistics with Excel: 2.9 Regression analysis in Excel

19 min Open
12

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

20 min Open

Case study automotive supplier

6 Videos · 68 minutes
13 Open

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

Automotive supplier case study

14 Open

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

Graphical visualization of a time series in Excel

15 Open

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

Trend estimates based on forecasts

16 Open

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

Trend estimation using the exponential smoothing method in Excel

17 Open

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

Use of time series analysis methods

18 Open

Statistics with Excel: 3.6 Contingency analysis in Excel

Calculation of correlations in Excel using two-dimensional frequencies

13

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

5 min Open
14

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

5 min Open
15

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

12 min Open
16

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

11 min Open
17

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

11 min Open
18

Statistics with Excel: 3.6 Contingency analysis in Excel

24 min Open

Case study biotechnology

8 Videos · 89 minutes
19 Open

Statistics with Excel: 4.1 Introduction to the biotechnology case study

Biotechnology case study

20 Open

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

21 Open

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

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

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

1-SP test for the variance in Excel

24 Open

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

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

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

Two-sample F-test in Excel

19

Statistics with Excel: 4.1 Introduction to the biotechnology case study

8 min Open
20

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

16 min Open
21

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

13 min Open
22

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

10 min Open
23

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

10 min Open
24

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

13 min Open
25

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

9 min Open
26

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

10 min Open

Outro

1 Videos · 2 minutes
27 Open

Statistics with Excel: 5 Outro

Summary

27

Statistics with Excel: 5 Outro

2 min Open
Comments (0)

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