Overview
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.
Full Product Details
Author: Chester Piascik
Publisher: Cengage Learning, Inc
Imprint: Brooks/Cole
Dimensions:
Width: 18.70cm
, Height: 1.50cm
, Length: 23.40cm
Weight: 0.472kg
ISBN: 9780534370596
ISBN 10: 0534370594
Pages: 150
Publication Date: 06 November 2000
Audience:
College/higher education
,
Professional and scholarly
,
Undergraduate
,
Postgraduate, Research & Scholarly
Format: Paperback
Publisher's Status: Out of Print
Availability: In Print
Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock.
Reviews
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
