Designed as a supplement to any combined Finite Mathematics/Applied Calculus text when the instructor wants to use Excel in the course, Piascik's useful manual illustrates key topics, through the use of Microsoft Excel. Explanations of Excel instructions and formulas reinforce the underlying mathematical concepts. The author encourages students to be active learners, asking them to verbalize and verify the mathematical concepts behind spreadsheet results.
Rezensionen / Stimmen
SPREADSHEET BASICS 1. LINEAR FUNCTIONS Slope-Intercept Form / Break Even Analysis / Using Excel's Goal Seek to: (A) Solve for x, given y; (B) Solve for y, given x / Inserting a Trendline 2. POWER FUNCTIONS AND QUADRATIC FUNCTIONS Power Functions / Graphing Concepts: Shifts and Reflections / Quadratic Functions: Graphs of y- ax^2 + bx + c / Revenue Functions and Break-even Analysis 3. SELECTED RATIONAL FUNCTIONS Odd and Even Powers of y = a/xn; Sums of Functions / Average Cost Functions; Inventory Cost 4. MATRICES AND LINEAR SYSTEMS Matrix Operations / Solving Linear Systems by Matrix Inverses / Leontief's Input-Output Model 5. LINEAR PROGRAMMING 6. MATHEMATICS OF FINANCE Simple vs. Compound Interest / International Investing / Future Value of an Annuity / Present Value of an Annuity / Amortization / Automobile Leases 7. PROBABILITY DISTRIBUTIONS Probability Distributions and Expected Value / Variance and Standard Deviation / The Binomial Distribution / The Normal Distribution 8. DERIVATIVES Limits / Instantaneous Rate of Change: Numerical Approximation / Differentiability: A Numerical Perspective 9. EXPONENTIAL AND LOGARITHMIC FUNCTIONS Exponential Growth and Decay / The Constant e and Continuous Compounding / Logarithmic Functions 10. Y', Y", ACCELERATION, AND GRAPHICAL ANALYSIS Tables of y' - and y" - Values: Acceleration / Graphs of y, y' and y"; Concavity and Acceleration / Optimization 11. DEFINITE INTEGRALS Rate of Change Step Functions / Riemann Sums 12. OPTIMIZATION: FUNCTIONS OF TWO VARIABLES Optimization / Method of Least Squares / Constrained Optimization: LaGrange Multipliers ANSWERS TO SELECTED EXERCISES
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für höhere Schule und Studium
Für Beruf und Forschung
Maße
Höhe: 234 mm
Breite: 187 mm
Dicke: 15 mm
Gewicht
ISBN-13
978-0-534-37059-6 (9780534370596)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
SPREADSHEET BASICS 1. LINEAR FUNCTIONS Slope-Intercept Form / Break Even Analysis / Using Excel"s Goal Seek to: (A) Solve for x, given y; (B) Solve for y, given x / Inserting a Trendline 2. POWER FUNCTIONS AND QUADRATIC FUNCTIONS Power Functions / Graphing Concepts: Shifts and Reflections / Quadratic Functions: Graphs of y- ax^2 + bx + c / Revenue Functions and Break-even Analysis 3. SELECTED RATIONAL FUNCTIONS Odd and Even Powers of y = a/xn; Sums of Functions / Average Cost Functions; Inventory Cost 4. MATRICES AND LINEAR SYSTEMS Matrix Operations / Solving Linear Systems by Matrix Inverses / Leontief"s Input-Output Model 5. LINEAR PROGRAMMING 6. MATHEMATICS OF FINANCE Simple vs. Compound Interest / International Investing / Future Value of an Annuity / Present Value of an Annuity / Amortization / Automobile Leases 7. PROBABILITY DISTRIBUTIONS Probability Distributions and Expected Value / Variance and Standard Deviation / The Binomial Distribution / The Normal Distribution 8. DERIVATIVES Limits / Instantaneous Rate of Change: Numerical Approximation / Differentiability: A Numerical Perspective 9. EXPONENTIAL AND LOGARITHMIC FUNCTIONS Exponential Growth and Decay / The Constant e and Continuous Compounding / Logarithmic Functions 10. Y", Y", ACCELERATION, AND GRAPHICAL ANALYSIS Tables of y" - and y" - Values: Acceleration / Graphs of y, y" and y"; Concavity and Acceleration / Optimization 11. DEFINITE INTEGRALS Rate of Change Step Functions / Riemann Sums 12. OPTIMIZATION: FUNCTIONS OF TWO VARIABLES Optimization / Method of Least Squares / Constrained Optimization: LaGrange Multipliers ANSWERS TO SELECTED EXERCISES
