Overview
Excel 2013, Minitab17, and SAS are integrated into the study and use of statistical analysis
Programming includes advanced applications of Excel (VBA, Visual Basic for Application)
All Excel macros published for users to study
Pedagogy from a business perspective—implementation of statistical concepts via case-study approach
Each chapter uses data from individual stocks, stock indices, options, and futures
A practical case-study based textbook for courses in business statistics, investment analysis, options, and futures
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (32 chapters)
-
Front Matter
-
Statistical Analysis
-
Front Matter
-
Keywords
About this book
This introductory textbook for business statistics teaches statistical analysis and research methods via business case studies and financial data using Excel, Minitab, and SAS. Every chapter in this textbook engages the reader with data of individual stock, stock indices, options, and futures.
One studies and uses statistics to learn how to study, analyze, and understand a data set of particular interest. Some of the more popular statistical programs that have been developed to use statistical and computational methods to analyze data sets are SAS, SPSS, and Minitab.
Of those, we look at Minitab and SAS in this textbook. One of the main reasons to use Minitab is that it is the easiest to use among the popular statistical programs. We look at SAS because it is the leading statistical package used in industry. We also utilize the much less costly and ubiquitous Microsoft Excel to do statistical analysis, as the benefits of Excel have become widely recognized in the academic world and its analytical capabilities extend to about 90 percent of statistical analysis done in the business world. We demonstrate much of our statistical analysis using Excel and double check the analysis and outcomes using Minitab and SAS—also helpful in some analytical methods not possible or practical to do in Excel.
Reviews
Authors and Affiliations
About the authors
Rutgers University
John Lee
Center for PBBEF Research
Jow-Ran Chang
National Tsing Hua University
Tzu Tai
Rutgers University
Bibliographic Information
Book Title: Essentials of Excel, Excel VBA, SAS and Minitab for Statistical and Financial Analyses
Authors: Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
DOI: https://doi.org/10.1007/978-3-319-38867-0
Publisher: Springer Cham
eBook Packages: Mathematics and Statistics, Mathematics and Statistics (R0)
Copyright Information: Springer International Publishing Switzerland 2016
Softcover ISBN: 978-3-319-38865-6Published: 27 December 2016
eBook ISBN: 978-3-319-38867-0Published: 24 November 2016
Edition Number: 1
Number of Pages: XX, 1041
Number of Illustrations: 125 b/w illustrations, 781 illustrations in colour
Topics: Statistics for Business, Management, Economics, Finance, Insurance, Statistics and Computing/Statistics Programs, Macroeconomics/Monetary Economics//Financial Economics