Evaluate surveys with Excel

Language: German

Excel: Evaluating questionnaires and surveys - statistics using a practical case study

Do you have the results of a survey or questionnaire in front of you? Now you want to evaluate the data in order to optimize processes, offers or services? Then learn how to derive specific recommendations for action from your tables using various statistical methods in this three-hour video training course. A practical Excel and statistics training course by Fabio Basler - including raw data, tasks and solutions as well as a helpful collection of formulas.

Statistics in Excel using the case study of a customer survey for a webshop (e-commerce)
Learn how to analyze and interpret your own data
Gain targeted insights from surveys and questionnaires
Almost three-hour video tutorial on the practical application of descriptive and inductive statistics
Among other things: Pivot tables, correlation matrix, outlier analysis and boxplot
Included: Excel raw data for practicing, exercises and solutions, collection of formulas

There are countless opportunities for improving your business lying dormant in your data. Uncover them now - with the help of this instructive Excel statistics training course!

Details

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

Intro to the video training

free of charge

This is what awaits you in the video training "Excel: Evaluating questionnaires and surveys - statistics using a practical case study"

You can expect training in practical learning for the evaluation of questionnaires and surveys

Introduction

free of charge

Statistics in Excel using the case study of a survey: 1.1 What to expect in the course

An overview of the contents of the course

download project file

Statistics in Excel using the case study of a survey: 1.2 Introduction to the case study

Introduction to the case study

Descriptive statistics

Statistics in Excel using the case study of a survey: 2.1 Mode

Calculation of the mode as a mean value key figure in Excel - manually and via pivot analysis

download project file

Statistics in Excel using the case study of a survey: 2.2 Multidimensional pivot data analysis (1)

Aggregation of key figures in two-dimensional overview, graphical visualization in column/bar chart in Excel

download project file

Statistics in Excel using the case study of a survey: 2.3 Multidimensional pivot data analysis (2)

Creation of key figure overview, interpretation

download project file

Statistics in Excel using the case study of a survey: 2.4 Rank correlation analysis

Calculation of rank correlation according to Spearman in Excel for ordinal scaled variables, interpretation

download project file

Statistics in Excel using the case study of a survey: 2.5 Correlation analysis

Correlation matrix via data analysis function, conditional formatting and content interpretation

download project file

Statistics in Excel using the case study of a survey: 2.6 Regression analysis

Modeling of linear functional relationship; interpretation of quality and statistical significance; calculation of regression function; quantitative evaluation of absolute/relative importance of regressors

download project file

Statistics in Excel using the case study of a survey: 2.7 Boxplot analysis & outlier detection

Creation of key figure overview and box chart in Excel, explanation of content, outlier detection, calculation of interval limits, identification of outlier values, interpretation

download project file

Inductive Statistics

Statistics in Excel using the case study of a survey: 3.1 Time series analysis

Visualization of time series, calculation of trend function, forecast estimation

download project file

Statistics in Excel using the case study of a survey: 3.2 Normal distribution function Probability theory

Calculation of probabilities based on normal distribution in Excel

download project file

Statistics in Excel using the case study of a survey: 3.3 2-sided confidence interval

Calculation of lower/upper limit of 97% confidence interval based on sample in Excel

download project file

Statistics in Excel using the case study of a survey: 3.4 1-SP test case for the proportion value

Execution of statistical parameter test, decision on validity/invalidity of the hypothesis

download project file

Statistics in Excel using the case study of a survey: 3.5 Poisson function Probability theory

Calculation of probabilities using Poisson distribution in Excel

download project file

Details of the content

Descriptive and inductive statistics in Excel: How to read your data correctly!
What is more important to your customers? Quality or customer service? How do they rate the prices of products or services? Which adjustments should you make to generate even more sales? Such questions about the optimization of business processes as well as offers and services can be answered with the help of questionnaires and surveys .
However, the value of the data obtained only becomes apparent when you analyze and interpret it correctly using suitable methods . In this three-hour training course, you will learn about important descriptive and inductive statistical elements. You will also learn how to implement these in Excel. Whether you want to evaluate the results of surveys and questionnaires or other data - with this training course, you will certainly know more after taking an analytical look at your tables!

Practical learning: Analyzing data from surveys and questionnaires

The practical scenario of the training: A survey was conducted for a web store. Your task: You evaluate the results of the survey using pivot tables, time series, regression and rank correlation, among other things.

You can follow each individual step yourself during the training using the raw data table provided in Excel . You will receive the corresponding solutions for each task. A PDF summary and a clear collection of formulas also support you in learning and later applying your knowledge in practice.

Excel practice: excellent for your studies - perfect for your job!

Is Excel your professional companion? In your job, do you constantly come across data that you need to analyze? Then make your work easier by acquiring knowledge in the areas of correlation, regression and stochastics . As a result, you will find important key statements for optimized processes in your company in your tables.

This course is also ideal for students. Develop a practical understanding of descriptive and inductive statistics - ideal for consolidating your learning content and preparing for exams, for example.

Start Excel, open the raw data and start analyzing directly

During the course, you will learn how to use descriptive and inductive statistical methods . Among other things, the following aspects will be covered: