Applied Mathematics with Microsoft Excel

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