Mathematics for Business, Science, and Technology - With MATLAB and Excel Computations.pdf - 20 Microsoft Excel Books Collection - BoxBooki

for Business, Science, and Technology

Mathematics

with MATLAB ® and Excel ® Computations

Third Edition

Steven T. Karris

14,000

12 ,00 0

I ncludes a

Comprehensive

Profit

10,000

Treatment of Probability

Revenue

and Statistics Illustrated

8,0 00

6,000

Cost

with Numerous

Examples

4,0 00

Break-Even Point

2,0 00

10 0 20 0 30 0 400 500

Unit s Sold

Orchard Publications

www.orchardpublications.com

Mathematics for Business, Science, and Technology with MATLAB® and Excel® Computations, Third Edition

publication may be reproduced or distributed in any form or by any means, or stored in a data base or retrieval

system, without the prior written permission of the publisher.

Direct all inquiries to Orchard Publications, 39510 Paseo Padre Parkway, Fremont, California 94538, U.S.A.

URL: http://www.orchardpublications.com, e-mail:info@orchardpublications.com.

Product and corporate names are trademarks or registered trademarks of the MathWorks™, Inc., and Microsoft™

Corporation. They are used only for identification and explanation, without intent to infringe.

Library of Congress Cataloging-in-Publication Data

Library of Congress Control Number: 2007922089

ISBN-13: 978-1-934404-01-0

ISBN-10: 1-934404-01-2

Disclaimer

The publisher has used his best effort to prepare this text. However, the publisher and author makes no warranty of any

kind, expressed or implied with regard to the accuracy, completeness, and computer codes contained in this book, and

shall not be liable in any event for incidental or consequential damages in connection with, or arising out of, the

performance or use of these programs.

Table of Contents

1 Elementary Algebra 1 − 1

1.1 Introduction.................................................................................................. 1 − 1

1.2 Algebraic Equations...................................................................................... 1 − 2

1.3 Laws of Exponents ........................................................................................ 1 − 5

1.4 Laws of Logarithms ..................................................................................... 1 − 10

1.5 Quadratic Equations................................................................................... 1 − 13

1.6 Cubic and Higher Degree Equations.......................................................... 1 − 15

1.7 Measures of Central Tendency................................................................... 1 − 15

1.8 Interpolation and Extrapolation................................................................. 1 − 20

1.9 Infinite Sequences and Series ..................................................................... 1 − 23

1.10 Arithmetic Series ........................................................................................ 1 − 23

1.11 Geometric Series......................................................................................... 1 − 24

1.12 Harmonic Series ......................................................................................... 1 − 26

1.13 Proportions ................................................................................................. 1 − 27

1.14 Summary ..................................................................................................... 1 − 29

1.15 Exercises ..................................................................................................... 1 − 33

1.16 Solutions to End − of − Chapter Exercises ..................................................... 1 − 35

Excel Computations: Pages 1 − 7, 1 − 11, 1 − 16, 1 − 17, 1 − 33, 1 − 36

MATLAB Computations: Pages 1 − 7, 1 − 11

2 Intermediate Algebra

2 − 1

2.1 Systems of Two Equations ........................................................................................ 2 − 1

2.2 Systems of Three Equations...................................................................................... 2 − 6

2.3 Matrices and Simultaneous Solution of Equations................................................... 2 − 7

2.4 Summary ................................................................................................................. 2 − 26

2.5 Exercises.................................................................................................................. 2 − 30

2.6 Solutions to End − of − Chapter Exercises ..................................................................2 − 32

Excel Computations: Pages 2 − 23, 2 − 24, 2 − 30, 2 − 31

MATLAB Computations: Pages 2 − 15, 2 − 16, 2 − 24, 2 − 25, 2 − 32, 2 − 36

3 Fundamentals of Geometry

3 − 1

3.1 Introduction...............................................................................................................3 − 1

3.2 Plane Geometry Figures.............................................................................................3 − 1

3.3 Solid Geometry Figures............................................................................................3 − 16

3.4 Using Spreadsheets to Find Areas of Irregular Polygons.........................................3 − 20

3.5 Summary ..................................................................................................................3 − 23

Mathematics for Business, Science, and Technology, Third Edition

3.6 Exercises .................................................................................................................. 3 − 27

3.7 Solutions to End − of − Chapter Exercises.................................................................. 3 − 29

Excel Computations: Pages 3 − 20, 3 − 30

4 Fundamentals of Plane Geometry

4 − 1

4.1 Introduction............................................................................................................. 4 − 1

4.2 Trigonometric Functions ......................................................................................... 4 − 2

4.3 Trigonometric Functions of an Acute Angle .......................................................... 4 − 2

4.4 Trigonometric Functions of an Any Angle ............................................................. 4 − 3

4.5 Fundamental Relations and Identities .................................................................... 4 − 6

4.6 Triangle Formulas.................................................................................................. 4 − 12

4.7 Inverse Trigonometric Functions .......................................................................... 4 − 13

4.8 Area of Polygons in Terms of Trigonometric Functions ....................................... 4 − 14

4.9 Summary ................................................................................................................ 4 − 16

4.10 Exercises ................................................................................................................ 4 − 18

4.11 Solutions to End − of − Chapter Exercises ................................................................ 4 − 19

Excel Computations: Pages 4 − 9 through 4 − 11, 4 − 13, 4 − 19 through 4 − 21

MATLAB Computations: Page 4 − 15

5 Fundamentals of Calculus

5 − 1

5.1 Introduction ............................................................................................................ 5 − 1

5.2 Differential Calculus ............................................................................................... 5 − 1

5.3 The Derivative of a Function ................................................................................. 5 − 3

5.4 Maxima and Minima............................................................................................. 5 − 11

5.5 Integral Calculus ................................................................................................... 5 − 15

5.6 Indefinite Integrals................................................................................................ 5 − 16

5.7 Definite Integrals .................................................................................................. 5 − 16

5.8 Summary ............................................................................................................... 5 − 21

5.9 Exercises................................................................................................................ 5 − 23

5.10 Solutions to End − of − Chapter Exercises ............................................................... 5 − 24

Excel Computations: Pages 5 − 8, 5 − 11, 5 − 18

MATLAB Computations: Pages 5 − 24 through 5 − 26

6 Mathematics of Finance and Economics

6 − 1

6.1 Common Terms........................................................................................................ 6 − 1

6.1.1 Bond............................................................................................................... 6 − 1

6.1.2 Corporate Bond ............................................................................................. 6 − 1

6.1.3 Municipal Bond ............................................................................................. 6 − 1

Mathematics for Business, Science, and Technology, Third Edition

6.1.4 Treasury Bond ............................................................................................... 6 − 1

6.1.5 Perpetuity ...................................................................................................... 6 − 1

6.1.6 Perpetual Bond.............................................................................................. 6 − 1

6.1.7 Convertible Bond .......................................................................................... 6 − 2

6.1.8 Treasury Note ............................................................................................... 6 − 2

6.1.9 Treasury Bill .................................................................................................. 6 − 2

6.1.10 Face Value ................................................................................................... 6 − 2

6.1.11 Par Value...................................................................................................... 6 − 2

6.1.12 Book Value................................................................................................... 6 − 3

6.1.13 Coupon Bond ............................................................................................... 6 − 3

6.1.14 Zero Coupon Bond ...................................................................................... 6 − 3

6.1.15 Junk Bond.................................................................................................... 6 − 3

6.1.16 Bond Rating Systems ................................................................................... 6 − 3

6.1.17 Promissory Note .......................................................................................... 6 − 4

6.1.18 Discount Rate.............................................................................................. 6 − 4

6.1.19 Prime Rate ................................................................................................... 6 − 4

6.1.20 Mortgage Loan ............................................................................................ 6 − 4

6.1.21 Predatory Lending Practices........................................................................ 6 − 5

6.1.22 Annuity ....................................................................................................... 6 − 5

6.1.23 Ordinary Annuity........................................................................................ 6 − 5

6.1.24 Sinking Fund ............................................................................................... 6 − 6

6.2 Interest .................................................................................................................... 6 − 6

6.2.1 Simple Interest............................................................................................. 6 − 6

6.2.2 Compound Interest...................................................................................... 6 − 8

6.2.3 Effective Interest Rate ............................................................................... 6 − 22

6.3 Sinking Funds........................................................................................................ 6 − 24

6.4 Annuities............................................................................................................... 6 − 29

6.5 Amortization ......................................................................................................... 6 − 34

6.6 Perpetuities............................................................................................................ 6 − 36

6.7 Valuation of Bonds................................................................................................ 6 − 39

6.7.1 Calculating the Purchase Price of a Bond................................................... 6 − 40

6.7.2 Total Periodic Bond Disbursement............................................................. 6 − 42

6.7.3 Calculation of Interest Rate of Bond .......................................................... 6 − 44

6.8 Spreadsheet Financial Functions ......................................................................... 6 − 45

6.8.1 PV Function .............................................................................................. 6 − 46

6.8.2 FV Function .............................................................................................. 6 − 48

6.8.3 PMT Function........................................................................................... 6 − 49

6.8.4 RATE Function......................................................................................... 6 − 50

6.8.5 NPER Function.......................................................................................... 6 − 51

6.8.6 NPV Function ........................................................................................... 6 − 52

6.8.7 IIR Function .............................................................................................. 6 − 54

Mathematics for Business, Science, and Technology, Third Edition

iii

Mathematics for Business, Science, and Technology - With MATLAB and Excel Computations.pdf

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: