Introduction to Quantitative Methods in Business

With Applications Using Microsoft Office Excel

AvBharat Kolluri,Michael J. Panik

Inbunden, Engelska, 2016

1 498 kr

Beställningsvara. Skickas inom 5-8 vardagar. Fri frakt över 249 kr.

Fler format och utgåvor

Inbunden

1 721 kr

Beskrivning

A well-balanced and accessible introduction to the elementary quantitative methods and Microsoft® Office Excel® applications used to guide business decision makingFeaturing quantitative techniques essential for modeling modern business situations, Introduction to Quantitative Methods in Business: With Applications Using Microsoft® Office Excel® provides guidance to assessing real-world data sets using Excel. The book presents a balanced approach to the mathematical tools and techniques with applications used in the areas of business, finance, economics, marketing, and operations.The authors begin by establishing a solid foundation of basic mathematics and statistics before moving on to more advanced concepts. The first part of the book starts by developing basic quantitative techniques such as arithmetic operations, functions and graphs, and elementary differentiations (rates of change), and integration. After a review of these techniques, the second part details both linear and nonlinear models of business activity. Extensively classroom-tested, Introduction to Quantitative Methods in Business: With Applications Using Microsoft® Office Excel® also includes: Numerous examples and practice problems that emphasize real-world business quantitative techniques and applications Excel-based computer software routines that explore calculations for an assortment of tasks, including graphing, formula usage, solving equations, and data analysis End-of-chapter sections detailing the Excel applications and techniques used to address data and solutions using large data sets A companion website that includes chapter summaries, Excel data sets, sample exams and quizzes, lecture slides, and an Instructors’ Solutions ManualIntroduction to Quantitative Methods in Business: With Applications Using Microsoft® Office Excel® is an excellent textbook for undergraduate-level courses on quantitative methods in business, economics, finance, marketing, operations, and statistics. The book is also an ideal reference for readers with little or no quantitative background who require a better understanding of basic mathematical and statistical concepts used in economics and business.Bharat Kolluri, Ph.D., is Professor of Economics in the Department of Economics, Finance, and Insurance at the University of Hartford. A member of the American Economics Association, his research interests include econometrics, business statistics, quantitative decision making, applied macroeconomics, applied microeconomics, and corporate finance.Michael J. Panik, Ph.D., is Professor Emeritus in the Department of Economics, Finance, and Insurance at the University of Hartford. He has served as a consultant to the Connecticut Department of Motor Vehicles as well as to a variety of health care organizations. In addition, Dr. Panik is the author of numerous books, including Growth Curve Modeling: Theory and Applications and Statistical Inference: A Short Course, both published by Wiley.Rao N. Singamsetti, Ph.D., is Associate Professor in the Department of Economics, Finance, and Insurance at the University of Hartford. A member of the American Economics Association, his research interests include the status of war on poverty in the United States since the 1960s and forecasting foreign exchange rates using econometric methods.

Produktinformation

Utgivningsdatum:2016-09-30
Mått:178 x 257 x 20 mm
Vikt:748 g
Format:Inbunden
Språk:Engelska
Antal sidor:320
Förlag:John Wiley & Sons Inc
ISBN:9781119220978

Utforska kategorier

Mer om författaren

Bharat Kolluri, Ph.D., is Professor of Economics in the Department of Economics, Finance, and Insurance at the University of Hartford. A member of the American Economics Association, his research interests include econometrics, business statistics, quantitative decision making, applied macroeconomics, applied microeconomics, and corporate finance.Michael J. Panik, Ph.D., is Professor Emeritus in the Department of Economics, Finance, and Insurance at the University of Hartford. He has served as a consultant to the Connecticut Department of Motor Vehicles as well as to a variety of health care organizations. In addition, Dr. Panik is the author of numerous books, including Growth Curve Modeling: Theory and Applications and Statistical Inference: A Short Course, both published by Wiley.Rao N. Singamsetti, Ph.D., is Associate Professor in the Department of Economics, Finance, and Insurance at the University of Hartford. A member of the American Economics Association, his research interests include the status of war on poverty in the United States since the 1960s and forecasting foreign exchange rates using econometric methods.

Innehållsförteckning

Preface xiii1. The Mathematical Toolbox 11.1 Introduction 11.2 Linear Functions 21.3 Solving a Simple Linear Equation for one Unknown Variable 31.3.1 Solving Two Simultaneous Linear Equations for Two Unknown Variables 41.4 Summation Notation 61.5 Sets 121.5.1 Subset, Empty Set, Universal Set, and Complement of A Set 131.5.2 Intersection and Union 141.6 Functions and Graphs 151.6.1 Vertical Line Test 161.7 Working with Functions 171.7.1 Evaluating Functions 171.7.2 Graphing Functions 181.8 Differentiation and Integration 211.8.1 Derivative 221.8.2 Derivatives of Logarithmic and Exponential Functions 261.8.3 Higher Order Derivatives 261.8.4 Integration 281.8.5 The Definite Integral 291.8.6 Some Rules of Integration 311.9 Excel Applications 34Chapter 1 Review 40Eercises 41Appendix 1.A: A Review of Basic Mathematics 45Eercises 632. Applications of Linear and Nonlinear Functions 662.1 Introduction 662.2 Linear Demand and Supply Functions 662.3 Linear Total Cost and Total Revenue Functions 692.4 Market Equilibrium 712.5 Graphical Presentation of Equilibrium 722.6 Applications of Nonlinear Functions 732.7 Present Value of an Income Stream 782.8 Average Values 792.9 Marginal Values 802.10 Elasticity 812.11 Some Additional Business Applications 842.12 Excel Applications 84Chapter 2 Review 86Eercises 87Excel Applications 903. Optimization 913.1 Introduction 913.2 Unconstrained Optimization 913.2.1 Models of Profit and Revenue Maximization 913.2.2 Solution by Trial and Error (Approximate) Method 923.2.3 Solution Using the Calculus Approach 933.2.4 Solution by Trial and Error (Approximate) Method 963.2.5 Solution Using the Calculus Approach 973.3 Models of Cost Minimization: Inventory Cost Functions and Eoq 993.3.1 Solution by Trial and Error Method 1013.3.2 Solution Using the Calculus Approach 1033.4 Constrained Optimization: Linear Programming 1053.4.1 Linear Programming: Maximization 1063.4.1.1 Solution by Graphical Method: First Approach 1063.4.1.2 Solution by Graphical Method: Second Approach 1093.4.2 Linear Programming: Minimization 1143.5 Excel Applications 121Chapter 3 Review 125Chapter 3 Eercises 126Excel Applications 1304. What Is Business Statistics? 1314.1 Introduction 1314.2 Data Description 1324.2.1 Some Important Concepts in Statistics 1324.2.2 Scales of Data Measurement 1324.3 Descriptive Statistics: Tabular and Graphical Techniques 1344.4 Descriptive Statistics: Numerical Measures of Central Tendency or Location of Data 1444.4.1 Population Mean 1444.4.2 Sample Mean 1454.4.3 Weighted Mean 1474.4.4 Mean of a Frequency Distribution: Grouped Data 1484.4.5 Geometric Mean 1494.4.6 Median 1514.4.7 Quantiles, Quartiles,4.5 Descriptive Statistics: Measures of Dispersion—Variability or Spread 1554.5.1 Range 1554.5.2 Variance 1554.5.3 Standard Deviation 1584.5.4 Coefficient of Variation 1604.5.5 Some Important Uses of the Standard Deviation 1634.5.6 Empirical Rule 1654.6 Measuring Skewness 1664.7 Excel Applications 169Chapter 4 Review 186Eercises 188Excel Applications 1915. Probability and Applications 1945.1 Introduction 1945.2 Some Useful Definitions 1955.3 Probability Sources 1965.3.1 Objective Probability 1965.3.2 Subjective Probability 1965.4 Some Useful Definitions Involving Sets of Events in the Sample Space 197Complement of a Given Set A 199Mutually Exclusive Events 2005.5 Probability Laws 2005.5.1 General Rule of Addition 2005.5.2 Rule of Complements 2025.5.3 Conditional Probability 2025.5.4 General Rule of Multiplication (Product Rule) 2035.5.5 Independent Events 2045.5.6 Probability Tree Approach 2045.6 Contingency Table 2085.7 Excel Applications 213Chapter 5 Review 214Eercises 215Excel Applications 2186. Random Variables and Probability Distributions 2196.1 Introduction 2196.2 Probability Distribution of a Discrete Random Variable X 2206.3 Expected Value, Variance, and Standard Deviation of a Discrete Random Variable X 2226.3.1 Some Basic Rules of Expectation 2246.3.2 Some Useful Properties of Variance of X 2256.3.3 Applications of Expected Values 2256.4 Continuous Random Variables and Their Probability Distributions 2306.5 A Specific Discrete Probabilty Distribution: the Binomial Case 2326.5.1 Binomial Probability Distribution 2326.5.2 Mean and Standard Deviation of the Binomial Random Variable 2376.5.3 Cumulative Binomial Probability Distribution 2386.6 Excel Applications 241Chapter 6 Review 245Eercises 245Appendix 6.A 252About the Companion Website 263Index 265