Statistics Applied With Excel: Data Analysis Is (Not) an Art
- Length: 367 pages
- Edition: 1
- Language: English
- Publisher: Springer
- Publication Date: 2022-11-18
- ISBN-10: 3662643189
- ISBN-13: 9783662643181
- Sales Rank: #12036072 (See Top 100 Books)
This book shows you how to analyze data sets systematically and to use Excel 2019 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.
This book is a translation of the original German 2nd edition Statistik angewandt mit Excel by Franz Kronthaler, published by Springer-Verlag GmbH Germany, part of Springer Nature in 2021. The translation was done with the help of artificial intelligence (machine translation by the service DeepL.com). A subsequent human revision was done primarily in terms of content, so that the book will read stylistically differently from a conventional translation. Springer Nature works continuously to further the development of tools for the production of books and on the related technologies to support the authors.
Cover Front Matter Part I. Basic Knowledge and Tools to Apply Statistics 1. Statistics Is Fun 2. Excel: A Brief Introduction to the Statistical Tools Part II. Describe, Nothing but Describe 3. Average Values: How People and Objects Behave in General 4. Variation: The Deviation from Average Behavior 5. Charts: The Possibility to Display Data Visually 6. Correlation: From Relationships 7. Ratios and Indices: The Opportunity to Generate New Knowledge from Old Ones Part III. From Few to All 8. Of Data and Truth 9. Hypotheses: Only a Specification of the Question? 10. Normal Distribution and Other Test Distributions 11. Hypothesis Test: What Holds? Part IV. Hypothesis Tests 12. The Test for a Group Mean or One-Sample t-Test 13. The Test for a Difference Between Group Means or Independent Samples t-Test 14. The Test for a Difference Between Means with Dependent Samples or Dependent Samples t-Test 15. The Analysis of Variance to Test for Group Differences When There Are More Than Two Groups 16. The Test for Correlation with Metric, Ordinal, and Nominal Data 17. More Tests for Nominal Variables 18. Summary Part IV: Overview of Test Procedures Part V. Regression Analysis 19. The Simple Linear Regression 20. Multiple Regression Analysis Part VI. What Happens Next? 21. How to Present Results 22. Advanced Statistical Methods 23. Interesting and Advanced Statistical Textbooks 24. Another Data Set to Practice Back Matter
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.