000771096 000__ 05290cam\a2200493M\\4500 000771096 001__ 771096 000771096 005__ 20230306142434.0 000771096 006__ m\\\\\o\\d\\\\\\\\ 000771096 007__ cr\un\nnnunnun 000771096 008__ 161202s2016\\\\sz\\\\\\ob\\\\001\0\eng\d 000771096 019__ $$a967710478$$a967717140 000771096 020__ $$a9783319388670$$q(electronic book) 000771096 020__ $$a3319388673$$q(electronic book) 000771096 020__ $$z9783319388656 000771096 020__ $$z3319388657 000771096 0247_ $$a10.1007/978-3-319-38867-0$$2doi 000771096 035__ $$aSP(OCoLC)ocn965146315 000771096 035__ $$aSP(OCoLC)965146315$$z(OCoLC)967710478$$z(OCoLC)967717140 000771096 040__ $$aYDX$$beng$$cYDX$$dOCLCQ$$dGW5XE$$dNJR$$dUPM$$dOCLCF 000771096 049__ $$aISEA 000771096 050_4 $$aHF1017 000771096 08204 $$a330.01/5195$$223 000771096 24500 $$aEssentials of Excel, Excel VBA, SAS and Minitab for statistical and financial analyses /$$cCheng-Few Lee, John Lee, Jow-Ran Chang, Tzu Tai. 000771096 260__ $$aCham, Switzerland :$$bSpringer,$$c2016. 000771096 300__ $$a1 online resource 000771096 336__ $$atext$$btxt$$2rdacontent 000771096 337__ $$acomputer$$bc$$2rdamedia 000771096 338__ $$aonline resource$$bcr$$2rdacarrier 000771096 347__ $$atext file$$bPDF$$2rda 000771096 504__ $$aIncludes bibliographical references and indexes. 000771096 5050_ $$a1 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. 000771096 506__ $$aAccess limited to authorized users. 000771096 520__ $$aThis 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. 000771096 588__ $$aDescription based on print version record. 000771096 650_0 $$aCommercial statistics$$xData processing. 000771096 7001_ $$aLee, Cheng F. 000771096 7001_ $$aLee, John C. 000771096 7001_ $$aChang, Jow-Ran. 000771096 7001_ $$aTai, Tzu. 000771096 77608 $$iPrint version:$$z9783319388656$$z3319388657$$w(OCoLC)946907946 000771096 852__ $$bebk 000771096 85640 $$3SpringerLink$$uhttps://univsouthin.idm.oclc.org/login?url=http://link.springer.com/10.1007/978-3-319-38867-0$$zOnline Access$$91397441.1 000771096 909CO $$ooai:library.usi.edu:771096$$pGLOBAL_SET 000771096 980__ $$aEBOOK 000771096 980__ $$aBIB 000771096 982__ $$aEbook 000771096 983__ $$aOnline 000771096 994__ $$a92$$bISE