Applied Mathematics with Microsoft Excel

Chester Piascik (Autor)

Buch | Softcover

150 Seiten

2000
Brooks/Cole (Verlag)
978-0-534-37059-6 (ISBN)

Titel ist leider vergriffen;
keine Neuauflage

Artikel merken

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.

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

Erscheint lt. Verlag	6.12.2000
Verlagsort	CA
Sprache	englisch
Maße	187 x 234 mm
Gewicht	472 g
Themenwelt	Informatik ► Office Programme ► Excel
Themenwelt	Mathematik / Informatik ► Mathematik ► Angewandte Mathematik
ISBN-10	0-534-37059-4 / 0534370594
ISBN-13	978-0-534-37059-6 / 9780534370596
Zustand	Neuware