Introduction to quantitative methods in business: with applications using Microsoft Office Excel
Gespeichert in:
| Hauptverfasser: | , , |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Hoboken, New Jersey
Wiley
[2017]
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | Includes index |
| Beschreibung: | xvii, 295 Seiten Diagramme 26 cm |
| ISBN: | 9781119220978 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV044330229 | ||
| 003 | DE-604 | ||
| 005 | 20170612 | ||
| 007 | t | ||
| 008 | 170530s2017 xxu|||| |||| 00||| eng d | ||
| 010 | |a 016017312 | ||
| 020 | |a 9781119220978 |9 978-1-119-22097-8 | ||
| 035 | |a (OCoLC)951744533 | ||
| 035 | |a (DE-599)BVBBV044330229 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 044 | |a xxu |c US | ||
| 049 | |a DE-739 | ||
| 050 | 0 | |a HF5691 | |
| 082 | 0 | |a 650.0285/54 |2 23 | |
| 084 | |a QH 233 |0 (DE-625)141548: |2 rvk | ||
| 100 | 1 | |a Kolluri, Bharat R. |e Verfasser |0 (DE-588)170062368 |4 aut | |
| 245 | 1 | 0 | |a Introduction to quantitative methods in business |b with applications using Microsoft Office Excel |c Bharat Kolluri, Michael J. Panik, Rao Singamsetti, Barney School of Business, University of Hartford |
| 264 | 1 | |a Hoboken, New Jersey |b Wiley |c [2017] | |
| 300 | |a xvii, 295 Seiten |b Diagramme |c 26 cm | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 500 | |a Includes index | ||
| 630 | 0 | 4 | |a Microsoft Excel (Computer file) |
| 650 | 4 | |a Mathematisches Modell | |
| 650 | 4 | |a Business mathematics | |
| 650 | 4 | |a Management |x Mathematical models | |
| 700 | 1 | |a Panik, Michael J. |d 1940- |e Verfasser |0 (DE-588)171025296 |4 aut | |
| 700 | 1 | |a Singamsetti, Rao N. |e Verfasser |0 (DE-588)170313956 |4 aut | |
| 776 | 0 | 8 | |i Erscheint auch als |n epub |z 978-1-119-22099-2 |
| 856 | 4 | 2 | |m Digitalisierung UB Passau - ADAM Catalogue Enrichment |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=029733507&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-029733507 | ||
Datensatz im Suchindex
| _version_ | 1804177554942197760 |
|---|---|
| adam_text | Table of Contents
Preface xiii
About the Companion Website xvii
1. The Mathematical Toolbox 1
1.1 Introduction 1
1.2 Linear Functions 2
1.3 Solving a Simple Linear Equation for One Unknown Variable 3
1.3.1 Solving Two Simultaneous Linear Equations for
Two Unknown Variables 4
1.4 Summation Notation 6
1.5 Sets 12
1.5.1 Subset, Empty Set, Universal Set, and Complement of A Set 13
1.5.2 Intersection and Union 14
1.6 Functions and Graphs 15
1.6.1 Vertical Line Test 16
1.7 Working with Functions 17
1.7.1 Evaluating Functions 17
1.7.2 Graphing Functions 18
1.8 Differentiation and Integration 22
1.8.1 Derivative 22
1.8.2 Derivatives of Logarithmic and Exponential Functions 26
1.8.3 Higher Order Derivatives 26
1.8.4 Integration 28
1.8.5 The Definite Integral 29
1.8.6 Some Rules of Integration 31
1.9 Excel Applications 34
Chapter 1 Review 40
Exercises 41
Excel Applications l 45
Appendix 1 .A: A Review of Basic Mathematics 45
1 .A. 1 Order of Arithmetic Operations 45
1.A.2 Exponents 46
• ·
Vll
viii Table of Contents
1.A.3 Logarithms 48
1.A.4 Prime Factorization 50
1.A.5 Factoring 51
1.A.6 Fractions: Ratios 52
1. A.6.1 Greatest Common Factor 52
1 .A.6.2 Least Common Multiple 52
1 .A.6.3 Addition and Subtraction of Fractions 53
1.A.6.4 Multiplication and Division of Fractions 54
l.A.6.5 Mixed Fractions 55
1.A.7 Decimals 56
1 .A.7.1 Operations with Decimals 56
1.A.8 Percent 57
1. A.8.1 Finding Percent (%) of a Number 58
l.A.8.2 Finding Percentage Increase (+) or Percentage
Decrease (—) 59
1.A.9 Conversions between Decimals (D), Fractions (F), and Percents (P) 60
1.A.9.1 Changing Decimals to Fractions (D —► F) 60
1. A.9.2 Changing Fraction to Decimals: (F D) 60
l.A.9.3 Changing Decimals to Percents (D — P) 60
1 .A.9.4 Changing Percents to Decimals (P D) 61
1 .A.9.5 Changing Fractions to Percents (F ֊֊ P) 61
1 .A.9.6 Changing Percents to Fractions (P F) 62
l.A. 10 Ratio and Proportion 62
Exercises 63
2. Applications of Linear and Nonlinear Functions 66
2.1 Introduction 66
2.2 Linear Demand and Supply Functions 66
2.3 Linear Total Cost and Total Revenue Functions 69
2.4 Market Equilibrium 7 1
2.5 Graphical Presentation of Equilibrium 72
2.6 Applications of Nonlinear Functions 73
2.7 Present Value of an Income Stream 78
2.8 Average Values 79
2.9 Marginal Values 80
2.10 Elasticity 81
2.11 Some Additional Business Applications 84
2.12 Excel Applications 84
Chapter 2 Review 86
Exercises 87
Excel Applications 90
Table of Contents ix
3. Optimization 91
3.1 Introduction 91
3.2 Unconstrained Optimization 91
3.2.1 Models of Profit and Revenue Maximization 91
3.2.2 Solution by Trial and Error (Approximate) Method 92
3.2.3 Solution Using the Calculus Approach 93
3.2.4 Solution by Trial and Error (Approximate) Method 96
3.2.5 Solution Using the Calculus Approach 97
3.3 Models of Cost Minimization: Inventory Cost Functions
and EOQ 99
3.3.1 Solution by Trial and Error Method 101
3.3.2 Solution Using the Calculus Approach 103
3.4 Constrained Optimization: Linear Programming 105
3.4.1 Linear Programming: Maximization 106
3.4.1.1 Solution by Graphical Method: First Approach 106
3.4.1.2 Solution by Graphical Method: Second Approach 109
3.4.2 Linear Programming: Minimization 114
3.5 Excel Applications 121
Chapter 3 Review 125
Chapter 3 Eercises 126
Excel Applications 130
4. What Is Business Statistics? 131
4.1 Introduction 131
4.2 Data Description 132
4.2.1 Some Important Concepts in Statistics 132
4.2.2 Scales of Data Measurement 132
4.3 Descriptive Statistics: Tabular and Graphical Techniques 134
4.4 Descriptive Statistics: Numerical Measures of Central Tendency
or Location of Data 144
4.4.1 Population Mean 144
4.4.2 Sample Mean 145
4.4.3 Weighted Mean 147
4.4.4 Mean of a Frequency Distribution: Grouped Data 148
4.4.5 Geometric Mean 149
4.4.6 Median 151
4.4.7 Quantiles, Quartiles, Deciles, and Percentiles 152
4.4.8 Mode 153
x Table of Contents
4.5 Descriptive Statistics: Measures of Dispersion—Variability or Spread 155
4.5.1 Range 155
4.5.2 Variance 155
4.5.3 Standard Deviation 158
4.5.4 Coefficient of Variation 160
4.5.5 Some Important Uses of the Standard Deviation 163
4.5.6 Empirical Rule 165
4.6 Measuring Skewness 166
4.7 Excel Applications 169
Chapter 4 Review 186
Exercises 188
Excel Applications 191
5. Probability and Applications 194
5.1 Introduction 194
5.2 Some Useful Definitions 195
5.3 Probability Sources 196
5.3.1 Objective Probability 196
5.3.2 Subjective Probability 196
5.4 Some Useful Definitions Involving Sets of Events in the
Sample Space 197
5.4.1 Complement of a Given Set A 199
5.4.2 Mutually Exclusive Events 200
5.5 Probability Laws 200
5.5.1 General Rule of Addition 200
5.5.2 Rule of Complements 202
5.5.3 Conditional Probability 202
5.5.4 General Rule of Multiplication (Product Rule) 203
5.5.5 Independent Events 204
5.5.6 Probability Tree Approach 204
5.6 Contingency Table 208
5.7 Excel Applications 213
Chapter 5 Review 214
Exercises 215
Excel Applications 218
6. Random Variables and Probability Distributions 219
6.1 Introduction
6.2 Probability Distribution of a Discrete Random Variable X
219
220
Table of Contents xi
6.3 Expected Value, Variance, and Standard Deviation of
a Discrete Random Variable X 222
6.3.1 Some Basic Rules of Expectation 224
6.3.2 Some Useful Properties of Variance of X 225
6.3.3 Applications of Expected Values 225
6.4 Continuous Random Variables and Their Probability Distributions 230
6.5 A Specific Discrete Probability Distribution: The Binomial Case 232
6.5.1 Binomial Probability Distribution 232
6.5.2 Mean and Standard Deviation of the Binomial Random Variable 237
6.5.3 Cumulative Binomial Probability Distribution 238
6.6 Excel Applications 241
Chapter 6 Review 245
Exercises 245
Appendix 6.A 252
Table 6.A.1 Binomial Probabilities (X is b(X; n, p)) 252
Table 6.A.2 Cumulative Distribution Function Values for the Binomial
Distribution (X is b{X n, p)) 258
Solutions to Odd-Numbered Exercises 263
Index 291
|
| any_adam_object | 1 |
| author | Kolluri, Bharat R. Panik, Michael J. 1940- Singamsetti, Rao N. |
| author_GND | (DE-588)170062368 (DE-588)171025296 (DE-588)170313956 |
| author_facet | Kolluri, Bharat R. Panik, Michael J. 1940- Singamsetti, Rao N. |
| author_role | aut aut aut |
| author_sort | Kolluri, Bharat R. |
| author_variant | b r k br brk m j p mj mjp r n s rn rns |
| building | Verbundindex |
| bvnumber | BV044330229 |
| callnumber-first | H - Social Science |
| callnumber-label | HF5691 |
| callnumber-raw | HF5691 |
| callnumber-search | HF5691 |
| callnumber-sort | HF 45691 |
| callnumber-subject | HF - Commerce |
| classification_rvk | QH 233 |
| ctrlnum | (OCoLC)951744533 (DE-599)BVBBV044330229 |
| dewey-full | 650.0285/54 |
| dewey-hundreds | 600 - Technology (Applied sciences) |
| dewey-ones | 650 - Management and auxiliary services |
| dewey-raw | 650.0285/54 |
| dewey-search | 650.0285/54 |
| dewey-sort | 3650.0285 254 |
| dewey-tens | 650 - Management and auxiliary services |
| discipline | Wirtschaftswissenschaften |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01732nam a2200421 c 4500</leader><controlfield tag="001">BV044330229</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20170612 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">170530s2017 xxu|||| |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">016017312</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781119220978</subfield><subfield code="9">978-1-119-22097-8</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)951744533</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV044330229</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">xxu</subfield><subfield code="c">US</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-739</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">HF5691</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">650.0285/54</subfield><subfield code="2">23</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QH 233</subfield><subfield code="0">(DE-625)141548:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Kolluri, Bharat R.</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)170062368</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Introduction to quantitative methods in business</subfield><subfield code="b">with applications using Microsoft Office Excel</subfield><subfield code="c">Bharat Kolluri, Michael J. Panik, Rao Singamsetti, Barney School of Business, University of Hartford</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Hoboken, New Jersey</subfield><subfield code="b">Wiley</subfield><subfield code="c">[2017]</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">xvii, 295 Seiten</subfield><subfield code="b">Diagramme</subfield><subfield code="c">26 cm</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Mathematisches Modell</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Business mathematics</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Management</subfield><subfield code="x">Mathematical models</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Panik, Michael J.</subfield><subfield code="d">1940-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)171025296</subfield><subfield code="4">aut</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Singamsetti, Rao N.</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)170313956</subfield><subfield code="4">aut</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">epub</subfield><subfield code="z">978-1-119-22099-2</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Passau - ADAM Catalogue Enrichment</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=029733507&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-029733507</subfield></datafield></record></collection> |
| id | DE-604.BV044330229 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T07:49:56Z |
| institution | BVB |
| isbn | 9781119220978 |
| language | English |
| lccn | 016017312 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-029733507 |
| oclc_num | 951744533 |
| open_access_boolean | |
| owner | DE-739 |
| owner_facet | DE-739 |
| physical | xvii, 295 Seiten Diagramme 26 cm |
| publishDate | 2017 |
| publishDateSearch | 2017 |
| publishDateSort | 2017 |
| publisher | Wiley |
| record_format | marc |
| spelling | Kolluri, Bharat R. Verfasser (DE-588)170062368 aut Introduction to quantitative methods in business with applications using Microsoft Office Excel Bharat Kolluri, Michael J. Panik, Rao Singamsetti, Barney School of Business, University of Hartford Hoboken, New Jersey Wiley [2017] xvii, 295 Seiten Diagramme 26 cm txt rdacontent n rdamedia nc rdacarrier Includes index Microsoft Excel (Computer file) Mathematisches Modell Business mathematics Management Mathematical models Panik, Michael J. 1940- Verfasser (DE-588)171025296 aut Singamsetti, Rao N. Verfasser (DE-588)170313956 aut Erscheint auch als epub 978-1-119-22099-2 Digitalisierung UB Passau - ADAM Catalogue Enrichment application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=029733507&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Kolluri, Bharat R. Panik, Michael J. 1940- Singamsetti, Rao N. Introduction to quantitative methods in business with applications using Microsoft Office Excel Microsoft Excel (Computer file) Mathematisches Modell Business mathematics Management Mathematical models |
| title | Introduction to quantitative methods in business with applications using Microsoft Office Excel |
| title_auth | Introduction to quantitative methods in business with applications using Microsoft Office Excel |
| title_exact_search | Introduction to quantitative methods in business with applications using Microsoft Office Excel |
| title_full | Introduction to quantitative methods in business with applications using Microsoft Office Excel Bharat Kolluri, Michael J. Panik, Rao Singamsetti, Barney School of Business, University of Hartford |
| title_fullStr | Introduction to quantitative methods in business with applications using Microsoft Office Excel Bharat Kolluri, Michael J. Panik, Rao Singamsetti, Barney School of Business, University of Hartford |
| title_full_unstemmed | Introduction to quantitative methods in business with applications using Microsoft Office Excel Bharat Kolluri, Michael J. Panik, Rao Singamsetti, Barney School of Business, University of Hartford |
| title_short | Introduction to quantitative methods in business |
| title_sort | introduction to quantitative methods in business with applications using microsoft office excel |
| title_sub | with applications using Microsoft Office Excel |
| topic | Microsoft Excel (Computer file) Mathematisches Modell Business mathematics Management Mathematical models |
| topic_facet | Microsoft Excel (Computer file) Mathematisches Modell Business mathematics Management Mathematical models |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=029733507&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT kolluribharatr introductiontoquantitativemethodsinbusinesswithapplicationsusingmicrosoftofficeexcel AT panikmichaelj introductiontoquantitativemethodsinbusinesswithapplicationsusingmicrosoftofficeexcel AT singamsettiraon introductiontoquantitativemethodsinbusinesswithapplicationsusingmicrosoftofficeexcel |