Externally indexed torrent

If you are the original uploader, contact staff to have it moved to your account

Textbook in PDF format

This book shows you how to analyze data sets systematically and to use Excel to extract information from data almost effortlessly. Both are (not) an art!
The statistical methods are presented and discussed using a single data set. This makes it clear how the methods build on each other and gradually more and more information can be extracted from the data. The Excel functions used are explained in detail - the procedure can be easily transferred to other data sets.
Various didactic elements facilitate orientation and working with the book: At the checkpoints, the most important aspects from each chapter are briefly summarized. In the freak knowledge section, more advanced aspects are addressed to whet the appetite for more. All examples are calculated with hand and Excel. Numerous applications and solutions as well as further data sets are available on the author's internet platform.
Statistics is fun and interesting. Interesting because we use statistics to discover relationships and understand how people and also other things, such as companies, behave. Fun, simply because it is fun to discover things. At the same time, statistics is important. If we can observe and evaluate how people, companies, or other objects behave, then we simply understand many things better.
The examples are calculated both by hand (for a manageable number of observations) and with Excel (on a full data set). This makes it easier to understand the ideas and concepts of statistical methods, and at the same time we learn how to apply them to a larger data set using Excel. Excel can also be used to check tasks calculated by hand.
Basic Knowledge and Tools to Apply Statistics
Statistics Is Fun
Excel: A Brief Introduction to the Statistical Tools
Describe, Nothing but Describe
Average Values: How People and Objects Behave in General
Variation: The Deviation from Average Behavior
Charts: The Possibility to Display Data Visually
Correlation: From Relationships
Ratios and Indices: The Opportunity to Generate New Knowledge from Old Ones
From Few to All
Of Data and Truth
Hypotheses: Only a Specification of the Question?
Normal Distribution and Other Test Distributions
Hypothesis Test: What Holds?
Hypothesis Tests
The Test for a Group Mean or One-Sample t-Test
The Test for a Difference Between Group Means or Independent Samples t-Test
The Test for a Difference Between Means with Dependent Samples or Dependent Samples t-Test
The Analysis of Variance to Test for Group Differences When There Are More Than Two Groups
The Test for Correlation with Metric, Ordinal, and Nominal Data
More Tests for Nominal Variables
Overview of Test Procedures
Regression Analysis
The Simple Linear Regression
Multiple Regression Analysis
What Happens Next?
How to Present Results
Advanced Statistical Methods
Interesting and Advanced Statistical Textbooks
Another Data Set to Practice
A Solutions to the Applications
B The Standard Normal Distribution N (0,1)
C The t-Distribution
D The χ2-Distribution
E The F-Distribution