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.
Introduction to the case study
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.
Portfolio management case study
Performing a mean value calculation in Excel
Carrying out a spread ratio analysis in Excel
Calculation of Pearson's correlation coefficient in Excel Part 1
Calculation of Pearson's correlation coefficient in Excel Part 2
Calculation of the rank correlation according to Spearman in Excel
Graphical visualization of a box chart in Excel
Classification of data and quantification of frequencies in interval limits
Implementation of a linear functional relationship using multiple regression
Test for normal distribution using the chi-square goodness-of-fit test
Automotive supplier case study
Graphical visualization of a time series in Excel
Trend estimates based on forecasts
Trend estimation using the exponential smoothing method in Excel
Use of time series analysis methods
Calculation of correlations in Excel using two-dimensional frequencies
Biotechnology case study
1-SP test for the expected value with known variance in Excel
1-SP test for the proportional value in Excel
1-SP test for the expected value with unknown variance in Excel
1-SP test for the variance in Excel
2-SP test for the difference between two proportion values in Excel
Comment now „Statistics with Excel - learn and practice in practice“