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

Essentials of Excel, Excel VBA, SAS and Minitab for Statistical and Financial Analyses by Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai.

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 s...

Full description

Saved in:
Bibliographic Details
Main Authors: Lee, Cheng-Few (Author), Lee, John (Author), Chang, Jow-Ran (Author), Tai, Tzu (Author)
Corporate Author: SpringerLink (Online service)
Format: eBook
Language:English
Published: Cham : Springer International Publishing : Imprint: Springer, 2016.
Edition:1st ed. 2016.
Series:Springer eBook Collection.
Subjects:
Statistics .
Macroeconomics.
Electronic resources (E-books)
Online Access:Click to view e-book
Holy Cross Note:Loaded electronically.
Electronic access restricted to members of the Holy Cross Community.
Table of Contents:
  • 1 Introduction
  • 2 Data Collection and Presentation
  • 3 Histograms and the Rate of Returns of Johnson & Johnson
  • 4 Numerical Summary Measures on Rate of Returns of Amazon, Walmart and the S&P 500
  • 5 Probability Concepts and Their Analysis
  • 6 Discrete Random Variables and Probability Distributions
  • 7 The Normal and Lognormal Distributions
  • 8 Sampling Distributions and Central Limit Theorem
  • 9 Other Continuous Distributions
  • 10 Estimation
  • 11 Hypothesis Testing
  • 12 Analysis Of Variance and Chi-Square Tests
  • 13 Simple Linear Regression and The Correlation Coefficient
  • 14 Simple Linear Regression and Correlation: Analyses and Applications
  • 15 Multiple Linear Regression
  • 16 Residual and Regression Assumption Analysis
  • 17 Nonparametric Statistics
  • 18 Time-Series: Analysis, Model, and Forecasting
  • 19 Index Numbers and Stock Market Indexes
  • 20 Sampling Surveys: Methods and Applications
  • 21 Statistical Decision Theory: Methods and Applications
  • 22 Introduction to EXCEL Programming
  • 23 Introduction to VBA Programming
  • 24 Professional Techniques Used in EXCEL and EXCEL VBA Techniques. - 25 Binomial Option Pricing Model Decision Tree Approach
  • 26 using Microsoft Excel to Estimate Alternative Option Pricing Models
  • 27 Alternative Methods to Estimate Implied Variance
  • 28 Greek Letters and Portfolio Insurance
  • 29 Portfolio Analysis and Option Strategies
  • 30 Simulation and its Application
  • 31 Application of Simultaneous Equation in Finance Research: Methods and Empirical Results
  • 32 Hedge Ratios: Theory and Applications.

Similar Items