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

By Cheng-Few Lee, Tzu Tai, Jow-Ran Chang, and more

2016

First Published

1061

Number of Pages

32H25M

Audio Length

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.

Authors

Librarian Note: There are multiple authors in the Goodreads database with this name. John Lee*, Mystery & Thrillers, Journalist John Lee, 1850-1922 John Lee, Fiction, wrote "Unicorn Saga" John Lee, b.1946, History John Lee, British actor, voice actor, professional narrator, and playwright John Lee, Allergist John Lee, Travel writer John Lee, "the Wealth Dragon", Entrepreneur and property investor John Lee, Gay Love & Erotica John Lee*, Fantasy John Lee*, author and illustrator, "Joy Sun Bear" John Lee, 1779-1859 John Lee, "the Dealionaire", real estate investor John Lee, Baron, British MP John Lee, wrote "MonsterFungus" series John Lee, petroleum engineering John Lee, English, early modern studies John Lee, economics, South East Asia An asterisk (*) indicates that this is a Goodreads Author