skip to content
Essentials of Excel, Excel VBA, SAS and Minitab for statistical and financial analyses Preview this item
ClosePreview this item
Checking...

Essentials of Excel, Excel VBA, SAS and Minitab for statistical and financial analyses

Author: Cheng F Lee; John C Lee; Jow-Ran Chang; Tzu Tai
Publisher: Cham, Switzerland : Springer, 2016.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Summary:
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  Read more...
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Essentials of Excel, Excel VBA, SAS and Minitab for statistical and financial analyses.
Cham, Switzerland : Springer, 2016
(OCoLC)946907946
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Cheng F Lee; John C Lee; Jow-Ran Chang; Tzu Tai
ISBN: 9783319388670 3319388673
OCLC Number: 965146315
Description: 1 online resource
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.
Responsibility: Cheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai.

Abstract:

This introductory textbook for business statistics teaches statistical analysis and research methods via business case studies and financial data using Excel, Minitab, and SAS.  Read more...

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.

Similar Items

Related Subjects:(1)

User lists with this item (1)

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/965146315> # Essentials of Excel, Excel VBA, SAS and Minitab for statistical and financial analyses
    a schema:MediaObject, schema:Book, schema:CreativeWork ;
    library:oclcnum "965146315" ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/3982177143#Place/cham_switzerland> ; # Cham, Switzerland
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/sz> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/3982177143#Topic/commercial_statistics_data_processing> ; # Commercial statistics--Data processing
    schema:about <http://dewey.info/class/330.015195/e23/> ;
    schema:bookFormat schema:EBook ;
    schema:contributor <http://experiment.worldcat.org/entity/work/data/3982177143#Person/chang_jow_ran> ; # Jow-Ran Chang
    schema:contributor <http://experiment.worldcat.org/entity/work/data/3982177143#Person/lee_john_c> ; # John C. Lee
    schema:contributor <http://experiment.worldcat.org/entity/work/data/3982177143#Person/lee_cheng_f> ; # Cheng F. Lee
    schema:contributor <http://experiment.worldcat.org/entity/work/data/3982177143#Person/tai_tzu> ; # Tzu Tai
    schema:datePublished "2016" ;
    schema:description "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."@en ;
    schema:description "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."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/3982177143> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/946907946> ;
    schema:name "Essentials of Excel, Excel VBA, SAS and Minitab for statistical and financial analyses"@en ;
    schema:productID "965146315" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/965146315#PublicationEvent/cham_switzerland_springer_2016> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/3982177143#Agent/springer> ; # Springer
    schema:url <https://login.libproxy.uregina.ca:8443/login?url=https://link.springer.com/openurl?genre=book&isbn=978-3-319-38865-6> ;
    schema:url <https://0-link-springer-com.pugwash.lib.warwick.ac.uk/book/10.1007/978-3-319-38867-0> ;
    schema:url <https://link.springer.com/openurl?genre=book&isbn=978-3-319-38865-6> ;
    schema:url <http://link.springer.com/10.1007/978-3-319-38867-0> ;
    schema:url <http://dx.doi.org/10.1007/978-3-319-38867-0> ;
    schema:url <http://uproxy.library.dc-uoit.ca/login?url=http://dx.doi.org/10.1007/978-3-319-38867-0> ;
    schema:url <https://link.springer.com/10.1007/978-3-319-38867-0> ;
    schema:url <http://proxy.ohiolink.edu:9099/login?url=http://link.springer.com/10.1007/978-3-319-38867-0> ;
    schema:url <http://link.springer.com/openurl?genre=book&isbn=978-3-319-38865-6> ;
    schema:url <https://grinnell.idm.oclc.org/login?url=http://link.springer.com/10.1007/978-3-319-38867-0> ;
    schema:url <http://uproxy.library.dc-uoit.ca/login?url=http://link.springer.com/10.1007/978-3-319-38867-0> ;
    schema:url <http://rave.ohiolink.edu/ebooks/ebc/9783319388670> ;
    schema:url <http://sfx.carli.illinois.edu/sfxwhe/sfx_local?genre=book&sid=Voyager:WHE&sfx.ignore_date_threshold=1&svc.fulltext=yes&rft.isbn=978-3-319-38867-0> ;
    schema:url <https://login.libproxy.uregina.ca:8443/login?url=http://link.springer.com/openurl?genre=book&isbn=978-3-319-38865-6> ;
    schema:workExample <http://worldcat.org/isbn/9783319388670> ;
    schema:workExample <http://dx.doi.org/10.1007/978-3-319-38867-0> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/965146315> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/3982177143#Person/chang_jow_ran> # Jow-Ran Chang
    a schema:Person ;
    schema:familyName "Chang" ;
    schema:givenName "Jow-Ran" ;
    schema:name "Jow-Ran Chang" ;
    .

<http://experiment.worldcat.org/entity/work/data/3982177143#Person/lee_cheng_f> # Cheng F. Lee
    a schema:Person ;
    schema:familyName "Lee" ;
    schema:givenName "Cheng F." ;
    schema:name "Cheng F. Lee" ;
    .

<http://experiment.worldcat.org/entity/work/data/3982177143#Person/lee_john_c> # John C. Lee
    a schema:Person ;
    schema:familyName "Lee" ;
    schema:givenName "John C." ;
    schema:name "John C. Lee" ;
    .

<http://experiment.worldcat.org/entity/work/data/3982177143#Place/cham_switzerland> # Cham, Switzerland
    a schema:Place ;
    schema:name "Cham, Switzerland" ;
    .

<http://experiment.worldcat.org/entity/work/data/3982177143#Topic/commercial_statistics_data_processing> # Commercial statistics--Data processing
    a schema:Intangible ;
    schema:name "Commercial statistics--Data processing"@en ;
    .

<http://rave.ohiolink.edu/ebooks/ebc/9783319388670>
    rdfs:comment "Connect to resource" ;
    .

<http://uproxy.library.dc-uoit.ca/login?url=http://dx.doi.org/10.1007/978-3-319-38867-0>
    rdfs:comment "eBook available for UOIT via SpringerLink. Click link to access" ;
    .

<http://uproxy.library.dc-uoit.ca/login?url=http://link.springer.com/10.1007/978-3-319-38867-0>
    rdfs:comment "eBook available for UOIT via SpringerLink. Click link to access" ;
    .

<http://worldcat.org/isbn/9783319388670>
    a schema:ProductModel ;
    schema:isbn "3319388673" ;
    schema:isbn "9783319388670" ;
    .

<http://www.worldcat.org/oclc/946907946>
    a schema:CreativeWork ;
    rdfs:label "Essentials of Excel, Excel VBA, SAS and Minitab for statistical and financial analyses." ;
    schema:description "Print version:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/965146315> ; # Essentials of Excel, Excel VBA, SAS and Minitab for statistical and financial analyses
    .

<http://www.worldcat.org/title/-/oclc/965146315>
    a genont:InformationResource, genont:ContentTypeGenericResource ;
    schema:about <http://www.worldcat.org/oclc/965146315> ; # Essentials of Excel, Excel VBA, SAS and Minitab for statistical and financial analyses
    schema:dateModified "2018-08-11" ;
    void:inDataset <http://purl.oclc.org/dataset/WorldCat> ;
    .

<https://login.libproxy.uregina.ca:8443/login?url=http://link.springer.com/openurl?genre=book&isbn=978-3-319-38865-6>
    rdfs:comment "Full text available from SpringerLINK ebooks - Mathematics and Statistics (2016)" ;
    .

<https://login.libproxy.uregina.ca:8443/login?url=https://link.springer.com/openurl?genre=book&isbn=978-3-319-38865-6>
    rdfs:comment "Full text available from SpringerLINK ebooks - Mathematics and Statistics (2016)" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.