Online Public Access Catalogue (OPAC)
Library,Documentation and Information Science Division

“A research journal serves that narrow

borderland which separates the known from the unknown”

-P.C.Mahalanobis


Essentials of Excel, Excel VBA, SAS and Minitab for Statistical and Financial Analyses (Record no. 426453)

MARC details
000 -LEADER
fixed length control field 05833nam a22005295i 4500
020 ## - INTERNATIONAL STANDARD BOOKNUMBER
International Standard Book Number 9783319388670
-- 978-3-319-38867-0
024 7# -
-- 10.1007/978-3-319-38867-0
-- doi
040 ## -
-- ISI Library, Kolkata
050 #4 -
-- QA276-280
072 #7 -
-- PBT
-- bicssc
072 #7 -
-- BUS061000
-- bisacsh
072 #7 -
-- PBT
-- thema
072 #7 -
-- K
-- thema
082 04 - DEWEYDECIMAL CLASSIFICATION NUMBER
Classification number 330.015195
Edition number 23
100 1# - MAIN ENTRY--PERSONAL NAME
Personal name Lee, Cheng-Few.
Relator code aut
-- http://id.loc.gov/vocabulary/relators/aut
245 10 - TITLE STATEMENT
Title Essentials of Excel, Excel VBA, SAS and Minitab for Statistical and Financial Analyses
Medium [electronic resource] /
Statement of responsibility, etc by Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai.
942 ## - ADDED ENTRY ELEMENTS(KOHA)
Koha item type E-BOOKS
100 1# - MAIN ENTRY--PERSONAL NAME
-- author.
264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE STATEMENTS
Place of production, publication, distribution, manufacture Cham :
Name of producer, publisher, distributor, manufacturer Springer International Publishing :
-- Imprint: Springer,
Date of production, publication, distribution, manufacture 2016.
300 ## -
-- XX, 1041 p. 906 illus., 781 illus. in color.
-- online resource.
336 ## - CONTENT TYPE
Content Type Term text
Content Type Code txt
Source rdacontent
337 ## - MEDIA TYPE
Media Type Term computer
Media Type Code c
Source rdamedia
338 ## - CARRIER TYPE
Carrier Type Term online resource
Carrier Type Code cr
Source rdacarrier
347 ## -
-- text file
-- PDF
-- rda
505 0# -
-- 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.
520 ## -
-- 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.
650 #0 -
-- Statistics.
650 #0 -
-- Mathematical statistics.
650 #0 -
-- Macroeconomics.
650 14 -
-- Statistics for Business/Economics/Mathematical Finance/Insurance.
-- http://scigraph.springernature.com/things/product-market-codes/S17010
650 24 -
-- Statistics and Computing/Statistics Programs.
-- http://scigraph.springernature.com/things/product-market-codes/S12008
650 24 -
-- Macroeconomics/Monetary Economics//Financial Economics.
-- http://scigraph.springernature.com/things/product-market-codes/W32000
700 1# -
-- Lee, John.
-- author.
-- aut
-- http://id.loc.gov/vocabulary/relators/aut
700 1# -
-- Chang, Jow-Ran.
-- author.
-- aut
-- http://id.loc.gov/vocabulary/relators/aut
700 1# -
-- Tai, Tzu.
-- author.
-- aut
-- http://id.loc.gov/vocabulary/relators/aut
710 2# -
-- SpringerLink (Online service)
773 0# -
-- Springer eBooks
776 08 -
-- Printed edition:
-- 9783319388656
776 08 -
-- Printed edition:
-- 9783319388663
856 40 -
-- https://doi.org/10.1007/978-3-319-38867-0
912 ## -
-- ZDB-2-SMA
950 ## -
-- Mathematics and Statistics (Springer-11649)

No items available.

Library, Documentation and Information Science Division, Indian Statistical Institute, 203 B T Road, Kolkata 700108, INDIA
Phone no. 91-33-2575 2100, Fax no. 91-33-2578 1412, ksatpathy@isical.ac.in