Skip to main content
Business Calculus with Excel
Mike May, S.J., Anneke Bart
x
Search Results:
No results.
☰
Contents
Calc
You!
Choose avatar
▻
✔️
You!
😺
👤
👽
🐶
🐼
🌈
Font family
▻
✔️
Open Sans
AaBbCc 123 PreTeXt
Roboto Serif
AaBbCc 123 PreTeXt
Adjust font
▻
Size
12
Smaller
Larger
Width
100
narrower
wider
Weight
400
thinner
heavier
Letter spacing
0
/200
closer
f a r t h e r
Word spacing
0
/50
smaller gap
larger gap
Line Spacing
135
/100
closer
together
further
apart
Light/dark mode
▻
✔️
default
pastel
twilight
dark
midnight
Reading ruler
▻
✔️
none
underline
L-underline
grey bar
light box
sunrise
sunrise underline
Motion by:
✔️
follow the mouse
up/down arrows - not yet
eye tracking - not yet
<
Prev
^
Up
Next
>
🔍
\(\newcommand{\Volume}{\mathrm{Volume}} \newcommand{\xLow}{\mathrm{xLow}} \newcommand{\xHigh}{\mathrm{xHigh}} \newcommand{\Mcost}{\operatorname{Marginal Cost}} \newcommand{\cost}{\operatorname{Cost}} \newcommand{\Mrev}{\operatorname{Marginal Revenue}} \newcommand{\revenue}{\operatorname{Revenue}} \newcommand{\profit}{\operatorname{Profit}} \newcommand{\Mprofit}{\operatorname{Marginal Profit}} \newcommand{\Pprofit}{\operatorname{Predicted Profit}} \newcommand{\price}{\operatorname{Price}} \newcommand{\Dprice}{\operatorname{Demand Price}} \newcommand{\Pprice}{\operatorname{Purchase Price}} \newcommand{\Sprice}{\operatorname{Supply Price}} \newcommand{\marginal}{\operatorname{Marginal}\,} \newcommand{\linear}{\operatorname{Linear}\,} \newcommand{\abs}[1]{\left\lvert #1\right\rvert} \newcommand{\quantity}{\mathrm{Quantity}} \newcommand{\AnnualCost}{\operatorname{Annual Cost}} \newcommand{\AnnualExpense}{\operatorname{Annual Expense}} \newcommand{\RepairFactor}{\mathrm{Repair Factor}} \newcommand{\Sales}{\operatorname{Sales}} \newcommand{\prediction}{\operatorname{prediction}} \newcommand{\FutureValue}{\operatorname{Future Value}} \newcommand{\demand}{\operatorname{Demand}} \newcommand{\val}{\operatorname{Value}} \newcommand{\raw}{\mathrm{raw}} \newcommand{\gizmos}{\operatorname{gizmos}} \newcommand{\intermediate}{\mathrm{intermediate}} \newcommand{\tax}{\operatorname{tax}} \newcommand{\FaceValue}{\operatorname{Face Value}} \newcommand{\rate}{\mathrm{rate}} \newcommand{\years}{\mathrm{years}} \newcommand{\expense}{\operatorname{expense}} \newcommand{\FutureAmount}{\operatorname{FutureAmount}} \newcommand{\InitialDeposit}{\mathrm{InitialDeposit}} \newcommand{\ppy}{\mathrm{ppy}} \newcommand{\PresentAmount}{\operatorname{PresentAmount}} \newcommand{\PriceGizmo}{\mathrm{PriceGizmos}} \newcommand{\QuantityGizmo}{\mathrm{QuantityGizmos}} \newcommand{\QuantityGadget}{\mathrm{QuantityGadgets}} \newcommand{\QuantityWidget}{\mathrm{QuantityWidgets}} \newcommand{\PriceWidget}{\mathrm{PriceWidgets}} \newcommand{\PriceGadget}{\mathrm{PriceGadgets}} \newcommand{\QW}{\mathrm{QW}} \newcommand{\QG}{\mathrm{QG}} \newcommand{\PW}{\mathrm{PW}} \newcommand{\PG}{\mathrm{PG}} \newcommand{\Production}{\operatorname{Production}} \newcommand{\Labor}{\mathrm{Labor}} \newcommand{\Capital}{\mathrm{Capital}} \newcommand{\Linear}{\operatorname{Linear}\,} \newcommand{\PriceX}{\mathrm{PriceX}} \newcommand{\PriceY}{\mathrm{PriceY}} \newcommand{\predicted}{\operatorname{predicted}} \newcommand{\Time}{\mathrm{time}} \newcommand{\TotalAmount}{\operatorname{TotalAmount}} \newcommand{\TotalValue}{\operatorname{TotalValue}} \newcommand{\CashAmount}{\mathrm{CashAmount}} \newcommand{\DepositAmount}{\mathrm{DepositAmount}} \newcommand{\AvailableTrees}{\operatorname{AvailableTrees}} \newcommand{\Capacity}{\mathrm{Capacity}} \newcommand{\Amount}{\operatorname{Amount}} \newcommand{\InitialAmount}{\mathrm{InitialAmount}} \newcommand{\InvestmentAmount}{\mathrm{InvestmentAmount}} \newcommand{\Return}{\operatorname{Return}} \newcommand{\SD}{\mathrm{SD}} \newcommand{\Antideriv}{\operatorname{Antideriv}} \newcommand{\MC}{\operatorname{MC}} \newcommand{\MP}{\operatorname{MP}} \newcommand{\MR}{\operatorname{MR}} \newcommand{\CDFf}{\operatorname{CDFf}} \newcommand{\Principal}{\operatorname{Principal}} \newcommand{\ProducerSurplus}{\mathrm{ProducerSurplus}} \newcommand{\ConsumerSurplus}{\mathrm{ConsumerSurplus}} \newcommand{\TotalSocialGain}{\mathrm{TotalSocialGain}} \newcommand{\Elasticity}{\operatorname{Elasticity}} \newcommand{\lt}{<} \newcommand{\gt}{>} \newcommand{\amp}{&} \definecolor{fillinmathshade}{gray}{0.9} \newcommand{\fillinmath}[1]{\mathchoice{\colorbox{fillinmathshade}{$\displaystyle \phantom{\,#1\,}$}}{\colorbox{fillinmathshade}{$\textstyle \phantom{\,#1\,}$}}{\colorbox{fillinmathshade}{$\scriptstyle \phantom{\,#1\,}$}}{\colorbox{fillinmathshade}{$\scriptscriptstyle\phantom{\,#1\,}$}}} \)
Frontmatter
Colophon
Acknowledgements
Preface
Notes for Instructors
Notes for Students
1
Functions Graphs and Excel
1.1
Linear Functions and models
1.1.1
Equations of a line
1.1.2
Exercises 1.1 Linear Functions and models
1.2
Functions in the Business setting
1.2.1
Quadratic Functions
1.2.2
Exponential functions
1.2.3
Logistic Functions
1.2.4
Sinusoidal Functions
1.2.5
Normal Distribution Functions
1.2.6
Inversely Proportional Functions
1.2.7
Logarithmic Functions
1.2.8
Exercises Functions in the Business Setting
1.3
Introduction to Excel Spreadsheets
1.3.1
Basic Arithmetic, show formulas and quick fill.
1.3.2
Absolute and Relative Cell References
1.3.3
Named Cell References
1.3.4
Getting Help
1.3.5
Other Details
1.3.6
Exercises Introduction to Excel Spreadsheets
1.4
Graphing functions with Excel
1.4.1
A basic graph
1.4.2
A graph with parameters
1.4.3
Controlling the viewing window
1.4.4
Graphing more than one function
1.4.5
Formatting a chart
1.4.6
Online graphing tools: Wolfram Alpha
1.4.7
Exercises 1.4 Graphing functions with Excel
1.5
Using Excel to find best-fit curves
1.5.1
Using Excel to find a best-fit line
1.5.1.1
Find the line
1.5.1.2
Produce the equation of the line
1.5.1.3
Bring the equation of the line back to the chart
1.5.2
Checking and improving our equations
1.5.3
Fitting the Consumer Price Index (
CPI
) to a best fitting curve; an extended example
1.5.3.1
Number of significant digits for equation constants
1.5.3.2
Setting the base point of a variable
1.5.3.3
Selecting data for one model
1.5.4
Exercises: Using Excel to find best fit curves
1.6
Finding Numerical Solutions with Goal Seek
1.6.1
A linear example
1.6.2
A quadratic example and concern with precision
1.6.3
More realistic examples: finding the intersection of two curves
1.6.4
Using Goal Seek for financial computations
1.6.5
Looking under the hood and understanding Goal Seek’s limitations
1.6.6
Finding Numerical Solutions with Goal Seek
2
Business Applications
2.1
Market Equilibrium Problems
2.1.1
Supply and Demand and Market Equilibrium
2.1.2
Exercises 2.1 Equilibrium Problems
2.2
Modeling Revenue, Costs, and Profit
2.2.1
Revenue and a review of demand price
2.2.2
Cost
2.2.3
Profit
2.2.4
Break-Even Point
2.2.5
Technical note
2.2.6
Exercises: Modeling Revenue, Costs, and Profit
2.3
Nonlinear Functions
2.3.1
Algebraic Functions
2.3.2
Discontinuous Functions
2.3.3
Exercises 2.3 Nonlinear functions
3
Rate of Change and Derivatives
3.1
Marginal Functions and Difference Quotients
3.1.1
Marginal Functions
3.1.2
Difference Quotients and Average Rate of Change
3.1.3
An Excel Trick for Difference Quotients
3.1.4
Exercises: Marginal Functions and Difference Quotients Problems
3.2
Numeric Derivatives and Limits
3.2
Exercises: Numeric Derivatives and Limits
3.3
Local Linearity
3.3
Exercises: Local Linearity
3.4
Optimization
3.4
Exercises: Optimization
3.5
An Introduction to Solver
3.5
Exercises: An Introduction to Solver
4
Symbolic Differentiation
4.1
Elementary Derivatives
4.1.1
Definition and Notation
4.1.2
Derivatives of monomials
4.1.3
Derivatives of Exponential Functions
4.1.4
Derivatives of Logarithmic Functions
4.1.5
Exercises: Elementary Derivatives Problems
4.2
Derivative Rules for Combinations of Functions
4.2.1
Derivatives of scalar products
4.2.2
Derivatives of sums and differences
4.2.3
Derivatives of products
4.2.4
Derivatives of quotients
4.2.5
Exercises: Derivative Rules for Combinations of Functions Problems
4.3
The Chain Rule
4.3
Exercises: The Chain Rule
4.4
Differentiation Using Computer Algebra
4.4
Exercises: Differentiation Using Computer Algebra Problems
4.5
The Second Derivative and Concavity
4.5
Exercises: The Second Derivative and Concavity Problems
5
Differentiation Techniques and Applications
5.1
Implicit Differentiation
5.1
Exercises: Implicit Differentiation Problems
5.2
Related Rates
5.2
Exercises: Related Rates Problems
5.3
Elasticity
5.3.1
Point Elasticity
5.3.2
Arc Elasticity
5.3.3
Exercises: Elasticity Problems
6
Functions of Several Variables
6.1
Evaluating and Graphing Functions of Several Variables
6.1
Exercises: Evaluating and Graphing Functions of Several Variables Problems
6.2
Wire Frames, Partial Derivatives, and Tangent Planes
6.2.1
Wire frames
6.2.2
Partial Derivatives
6.2.3
Tangent Planes and Linear Approximation
6.2.4
Exercises: Wire Frames, Partial Derivatives, and Tangent Planes Problems
6.3
Critical Points and Extrema
6.3.1
Critical Points
6.3.2
Second Partial Derivatives
6.3.3
Using the Discriminant to Test Critical Points
6.3.4
Exercises: Critical Points and Extrema Problems
6.4
Optimization and Best Fitting Curves
6.4
Exercises: Optimization and Best Fitting Curves Problems
7
Integration
7.1
Approximating Definite Integrals as Sums
7.1
Exercises: Approximating Definite Integrals as Sums Problems
7.2
The Fundamental Theorem of Calculus
7.2
Exercises: The Fundamental Theorem of Calculus Problems
7.3
Basic Antidifferentiation
7.3
Exercises: Basic Antidifferentiation Problems
7.4
Integration by Change of Variables or Substitution
7.4.1
Change of variables for indefinite integrals
7.4.2
Change of variables for definite integrals
7.4.3
Exercises: Integration by Change of Variables or Substitution Problems
7.5
Integration using Computer Algebra
7.5.1
Definite integrals
7.5.2
Initial value problems
7.5.3
Riemann Sums
7.5.4
Exercises: Integration using Computer Algebra Problems
7.6
The Normal Distribution: An extended numeric example
7.6.1
Background from probability
7.6.2
Examples
7.6.3
Exercises: Normal Distribution Problems
7.7
Applications of the integral: Investment and depreciation
7.7.1
Basic Accumulation
7.7.2
Boundary value problems
7.7.3
Depreciation
7.7.4
Exercises: Applications of the integral: Investment and depreciation Problems
7.8
Economics Applications of the Integral
7.8.1
Consumer and Producer Surplus
7.8.2
Lorenz Curves and the Gini Index
7.8.3
Exercises Business Applications of the Integral Problems
Back Matter
A
Spreadsheet Skills introduced in chapter 1
A.1
From Section 1-3 - Entering and Copying Formulas
A.2
From Section 1.4 Graphing Functions in a Spreadsheet
A.3
From Section 1.5 Adding and Using Best Fit Curves (Trendlines)
A.4
From Section 1.6 Using Goal Seek
A.5
Google Sheets Notes for Chapter 1 skills
B
Spreadsheet Skills Introduced in Chapter 2
C
Spreadsheet Skills introduced in chapter 3
C.1
From Section 3.1- Comparing Functions and Related Marginal Functions
C.1.1
Marginal Functions with
\(q\)
increasing by 1
C.1.2
Marginal Functions using Columns
C.1.3
Marginal Functions using Quick Fill
C.2
From Section 3.2- Comparing Functions and Numeric Derivatives
C.2.1
Derivatives from the Intuitive Approach
C.2.2
Derivatives from Numerical Limits
C.2.3
Graphing a Function with its Numeric Derivative
C.2.4
Using Trendline to find Derivative Formulas
C.3
From Section 3.3- Building Linear Approximations
C.4
From Section 3.5 - An introduction to Solver 3.5
C.5
Google Sheets Notes for Chapter 3 Skills
D
Spreadsheet Skills introduced in chapter 6
D.1
From Section 6.1 - Evaluating and graphing functions of several varaibles
D.1.1
Evaluating a function of several variables
D.1.2
Making a table for a function of 2 variable
D.1.3
Turning a table of a function of 2 variables into a surface graph
D.2
From Section 6.3 - Critical points and extrema
D.3
Google Sheets Notes for Chapter 6 Skills
E
Spreadsheet Skills introduced in chapter 7
Section
D.3
Google Sheets Notes for Chapter 6 Skills
Sheets does not seem to hae a reasonable way of producing 3-D graphs. For the other spreadsheet skills in this chapter, Excel and Sheets behave the same way.