Kronthaler F. Statistics Applied With Excel: Data Analysis Is (Not) an Art

Springer, 2023. — 343 p. — ISBN: 978-3-662-64318-1.This book shows you how to analyze data sets systematically and 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.Solutions to the Applications.
The Standard Normal Distribution N (0,1).
The t-Distribution.
The χ2-Distribution.
E The F-Distribution.