Advertisement

Essentials of Excel, Excel VBA, SAS and Minitab for Statistical and Financial Analyses

  • Cheng-Few Lee
  • John Lee
  • Jow-Ran Chang
  • Tzu Tai

Table of contents

  1. Front Matter
    Pages i-xx
  2. Statistical Analysis

    1. Front Matter
      Pages 1-1
    2. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 3-12
    3. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 13-45
    4. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 47-73
    5. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 75-117
    6. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 119-144
    7. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 145-191
    8. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 193-240
    9. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 241-302
    10. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 303-352
    11. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 353-384
    12. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 385-417
    13. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 419-445
    14. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 447-479
    15. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 481-512
    16. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 513-531
    17. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 533-568
    18. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 569-587
    19. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 589-644
    20. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 645-671
    21. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 673-684
    22. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 685-698
  3. Advanced Applications of Microsoft Excel Programs in Financial Analysis

    1. Front Matter
      Pages 699-699
    2. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 701-720
    3. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 721-762
    4. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 763-800
    5. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 801-834
    6. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 835-860
    7. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 861-900
    8. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 901-917
    9. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 919-946
    10. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 947-966
  4. Applications of SAS Programs to Financial Analysis

    1. Front Matter
      Pages 967-967
    2. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 969-991
    3. Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai
      Pages 993-1029
  5. Back Matter
    Pages 1031-1041

About this book

Introduction

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.

  • 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
  • An in-depth reference for statistical analysis using multiple software packages for financial industry professionals

Keywords

Business Statistics with Excel, MINITAB & SAS Finance with Excel & SAS Statistical Analysis with Excel Statistical Finance with Excel Statistical Inference Statistics for Investment Analysis

Authors and affiliations

  • Cheng-Few Lee
    • 1
  • John Lee
    • 2
  • Jow-Ran Chang
    • 3
  • Tzu Tai
    • 4
  1. 1.Department of FinanceRutgers UniversityPiscataway TownshipUSA
  2. 2.Center for PBBEF ResearchMorris PlainsUSA
  3. 3.Department of Quantitative FinanceNational Tsing Hua UniversityHsinchuTaiwan
  4. 4.Mezocliq, LLCNew YorkUSA

Bibliographic information