東華大學圖書館 |

Statistics applied with Excel = data analysis is (not) an art /

紀錄類型:	書目-電子資源 : Monograph/item
正題名/作者:	Statistics applied with Excel/ by Franz Kronthaler.
其他題名:	data analysis is (not) an art /
作者:	Kronthaler, Franz.
出版者:	Berlin, Heidelberg :Springer Berlin Heidelberg : : 2023.,
面頁冊數:	xxiv, 343 p. :ill., digital ;24 cm.
內容註:	Part 1 - Basic knowledge and tools to apply statistics -- Statistics is fun -- Excel: A brief introduction and the statistical possibilities -- Part 2 - Describe, nothing but describe -- Mean values: How people and objects behave on average -- Scatter: The deviation from average behavior -- Graphs: The possibility to represent data visually -- Correlation: Of the correlation -- Ratio and index numbers: The chance to generate new things from old knowledge -- Part 3 - From Few to All -- Of Data and the Truth -- Hypotheses: Just a specification of the question -- Normal distribution and other test distributions -- Hypothesis testing: What is Valid? -- Part 4 - Procedures for Testing Hypotheses -- The Mean Test -- The Test for Difference of Means in Independent Samples -- The Test for Difference of Means in Dependent Samples -- The Analysis of Variance for Testing for Group Differences in More than Two Groups -- The Test for Correlation in Metric, Ordinal, and Nominal Data -- Further Test Procedures for Nominal Variables -- Summary Part IV - Overview of testing procedures -- Part 5 - Regression analysis -- The linear single regression -- The multiple regression analysis -- Part 6 - What's next -- Brief report on a research question -- Further statistical procedures -- Interesting and further statistics books -- Another data set to practice on - Intern of a company -- Appendix.
Contained By:	Springer Nature eBook
標題:	Statistics - Data processing. -
電子資源:	https://doi.org/10.1007/978-3-662-64319-8
ISBN:	9783662643198

Statistics applied with Excel = data analysis is (not) an art /
Kronthaler, Franz.

Statistics applied with Exceldata analysis is (not) an art /[electronic resource] :by Franz Kronthaler. - Berlin, Heidelberg :Springer Berlin Heidelberg :2023. - xxiv, 343 p. :ill., digital ;24 cm.

Part 1 - Basic knowledge and tools to apply statistics -- Statistics is fun -- Excel: A brief introduction and the statistical possibilities -- Part 2 - Describe, nothing but describe -- Mean values: How people and objects behave on average -- Scatter: The deviation from average behavior -- Graphs: The possibility to represent data visually -- Correlation: Of the correlation -- Ratio and index numbers: The chance to generate new things from old knowledge -- Part 3 - From Few to All -- Of Data and the Truth -- Hypotheses: Just a specification of the question -- Normal distribution and other test distributions -- Hypothesis testing: What is Valid? -- Part 4 - Procedures for Testing Hypotheses -- The Mean Test -- The Test for Difference of Means in Independent Samples -- The Test for Difference of Means in Dependent Samples -- The Analysis of Variance for Testing for Group Differences in More than Two Groups -- The Test for Correlation in Metric, Ordinal, and Nominal Data -- Further Test Procedures for Nominal Variables -- Summary Part IV - Overview of testing procedures -- Part 5 - Regression analysis -- The linear single regression -- The multiple regression analysis -- Part 6 - What's next -- Brief report on a research question -- Further statistical procedures -- Interesting and further statistics books -- Another data set to practice on - Intern of a company -- Appendix.

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 therefore 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. The Author Prof. Dr. Franz Kronthaler is professor of economics and statistics at the University of Applied Sciences Graubünden FHGR. He has been working as an empirical economic researcher for more than 20 years, has conducted numerous research projects and published papers. For many years, he has been teaching students of various disciplines in applied statistics and the advanced methods of data analysis at Bachelor and Master level.

ISBN: 9783662643198

Standard No.: 10.1007/978-3-662-64319-8doiSubjects--Uniform Titles:

Microsoft Excel (Computer file)
Subjects--Topical Terms:

535534
Statistics
--Data processing.

LC Class. No.: QA276.4

Dewey Class. No.: 519.50285

Statistics applied with Excel = data analysis is (not) an art /
LDR:04424nmm a2200337 a 4500 001 2315049
003 DE-He213
005 20221117143736.0
006 m d
007 cr nn 008maaau
008 230902s2023 gw s 0 eng d
020 $a 9783662643198 $q (electronic bk.)
020 $a 9783662643181 $q (paper)
024 7 $a 10.1007/978-3-662-64319-8 $2 doi
035 $a 978-3-662-64319-8
040 $a GP $c GP $e rda
041 1 $a eng $h ger
050 4 $a QA276.4
072 7 $a UFM $2 bicssc
072 7 $a COM077000 $2 bisacsh
072 7 $a UFM $2 thema
082 0 4 $a 519.50285 $2 23
090 $a QA276.4 $b .K93 2023
100 1 $a Kronthaler, Franz. $3 3627126
240 1 0 $a Statistik angewandt mit Excel. $l English
245 1 0 $a Statistics applied with Excel $h [electronic resource] : $b data analysis is (not) an art / $c by Franz Kronthaler.
260 $a Berlin, Heidelberg : $b Springer Berlin Heidelberg : $b Imprint: Springer, $c 2023.
300 $a xxiv, 343 p. : $b ill., digital ; $c 24 cm.
505 0 $a Part 1 - Basic knowledge and tools to apply statistics -- Statistics is fun -- Excel: A brief introduction and the statistical possibilities -- Part 2 - Describe, nothing but describe -- Mean values: How people and objects behave on average -- Scatter: The deviation from average behavior -- Graphs: The possibility to represent data visually -- Correlation: Of the correlation -- Ratio and index numbers: The chance to generate new things from old knowledge -- Part 3 - From Few to All -- Of Data and the Truth -- Hypotheses: Just a specification of the question -- Normal distribution and other test distributions -- Hypothesis testing: What is Valid? -- Part 4 - Procedures for Testing Hypotheses -- The Mean Test -- The Test for Difference of Means in Independent Samples -- The Test for Difference of Means in Dependent Samples -- The Analysis of Variance for Testing for Group Differences in More than Two Groups -- The Test for Correlation in Metric, Ordinal, and Nominal Data -- Further Test Procedures for Nominal Variables -- Summary Part IV - Overview of testing procedures -- Part 5 - Regression analysis -- The linear single regression -- The multiple regression analysis -- Part 6 - What's next -- Brief report on a research question -- Further statistical procedures -- Interesting and further statistics books -- Another data set to practice on - Intern of a company -- Appendix.
520 $a 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 therefore 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. The Author Prof. Dr. Franz Kronthaler is professor of economics and statistics at the University of Applied Sciences Graubünden FHGR. He has been working as an empirical economic researcher for more than 20 years, has conducted numerous research projects and published papers. For many years, he has been teaching students of various disciplines in applied statistics and the advanced methods of data analysis at Bachelor and Master level.
630 0 0 $a Microsoft Excel (Computer file) $3 543656 $3 543656
650 0 $a Statistics $x Data processing. $3 535534
650 0 $a Electronic spreadsheets. $3 533209
650 1 4 $a Statistical Software. $3 3596845
650 2 4 $a Applied Statistics. $3 3300946
650 2 4 $a Data Analysis and Big Data. $3 3538537
710 2 $a SpringerLink (Online service) $3 836513
773 0 $t Springer Nature eBook
856 4 0 $u https://doi.org/10.1007/978-3-662-64319-8
950 $a Mathematics and Statistics (SpringerNature-11649)