Applied Calculus with Microsoft Excel - Softcover

Piascik, Chester

 
9780534370589: Applied Calculus with Microsoft Excel

Synopsis

This supplementary text illustrates key topics in Applied Calculus, 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.

"synopsis" may belong to another edition of this title.

Review

0. 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 = ax2 + bx versus y = ax2 + 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 Function; Inventory Cost 4. DERIVATIVES Limits / Instantaneous Rate of Change: Numerical Approximation / Differentiability: A Numerical Perspective 5. EXPONENTIAL AND LOGARITHMIC FUNCTIONS Exponential Growth and Decay / Simple Versus Compound Interest / The Constant e and Continuous Compounding / Logarithmic Functions 6. Y', Y", ACCELERATION, AND GRAPHICAL ANALYSIS Tables of y'- and y"-Values; Acceleration / Graphs of y, y', and y"; Concavity and Acceleration / Optimization 7. DEFINITE INTEGRALS Rate of Change Step Functions / Riemann Sums 8. OPTIMIZATION: FUNCTIONS OF TWO VARIABLES Optimization / Method of Least Squares / Constrained Optimization: Lagrange Multipliers / ANSWERS TO SELECTED EXERCISES

"About this title" may belong to another edition of this title.