【统计与金融分析，2016】 Essentials of Excel, Excel VBA, SAS and Minitab for Sta

相似文件 换一批

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

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

Authors: Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai



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

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.

Table of contents (32 chapters)

Front Matter

Statistical Analysis
• Front Matter
• Introduction
• Data Collection, Presentation, and Yahoo Finance
• Histograms and the Rate of Returns of JPM and JNJ
• Numerical Summary Measures on Rate of Returns of Amazon, Walmart, and the S&P 500
• Probability Concepts and Their Analysis
• Discrete Random Variables and Probability Distributions
• The Normal and Lognormal Distributions
• Sampling Distributions and Central Limit Theorem
• Other Continuous Distributions
• Estimation
• Hypothesis Testing
• Analysis of Variance and Chi-Square Tests
• Simple Linear Regression and the Correlation Coefficient
• Simple Linear Regression and Correlation: Analyses and Applications
• Multiple Linear Regression
• Residual and Regression Assumption Analysis
• Nonparametric Statistics
• Time Series: Analysis, Model, and Forecasting
• Index Numbers and Stock Market Indexes
• Sampling Surveys: Methods and Applications
• Statistical Decision Theory

Advanced Applications of Microsoft Excel Programs in Financial Analysis
• Front Matter
• Introduction to Excel Programming
• Introduction to VBA Programming
• Professional Techniques Used in Excel and Excel VBA Techniques
• Binomial Option Pricing Model Decision Tree Approach
• Microsoft Excel Approach to Estimating Alternative Option Pricing Models
• Alternative Methods to Estimate Implied Variance
• Greek Letters and Portfolio Insurance
• Portfolio Analysis and Option Strategies
• Simulation and Its Application

Applications of SAS Programs to Financial Analysis
• Front Matter
• Application of Simultaneous Equation in Finance Research: Methods and Empirical Results
• Hedge Ratios: Theory and Applications

Back Matter

共 1041 页

原版 PDF + EPUB:

本帖隐藏的内容

原版 PDF:
Essentials of Excel, Excel VBA, SAS and Minitab for Statistical and Financial Analyses.pdf (89.27 MB, 需要: 25 个论坛币)

2016-12-9 17:38:32 上传

需要: 25 个论坛币  [购买]

PDF 压缩包：
Essentials (pdf).zip (69.43 MB, 需要: 25 个论坛币) 本附件包括：

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

2016-12-9 17:37:01 上传

需要: 25 个论坛币  [购买]

EPUB:
Essentials of Excel, Excel VBA, SAS and Minitab for Statistical and Financial An.epub (51.59 MB, 需要: 25 个论坛币)

2016-12-9 17:39:15 上传

需要: 25 个论坛币  [购买]

EPUB 压缩包：
Essentials (epub).zip (51.41 MB, 需要: 25 个论坛币) 本附件包括：

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

2016-12-9 17:36:04 上传

需要: 25 个论坛币  [购买]

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏21 回帖

关键词：Essentials Essential MiniTab EXCEL Essen published includes business concepts Excel

谢谢分享楼主威武楼主万岁

感谢分享~！

哈哈，先收着。

。。。。。。。。。。。。。。。。

thanks for sharing

thanks a lot

hjjjjjjjjjjjjj

Essentials of Excel, Excel VBA, SAS