Applied Calculus with Microsoft Excel Book

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