Skip to main content
Business Calculus with Excel
Mike May, S.J., Anneke Bart
Contents
Search Book
close
Search Results:
No results.
Calc
dark_mode
Dark Mode
Prev
Up
Next
Scratch ActiveCode
Profile
Course Home
Assignments
Practice
Peer Instruction (Instructor)
Peer Instruction (Student)
Change Course
Instructor's Page
Progress Page
Edit Profile
Change Password
Log Out
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
Reading Check
1.1.3
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
Reading Check
1.2.9
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
Reading Check
1.3.7
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
Reading Check
1.4.8
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
Reading Check
1.5.5
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
Reading Check
1.6.7
Finding Numerical Solutions with Goal Seek
Business Calculus with Excel
Mike May, S.J.
Department of Mathematics and Statistics
Saint Louis University
maymk@slu.edu
Anneke Bart
Department of Mathematics and Statistics
Saint Louis University
barta@slu.edu
June 7, 2025
Colophon
Acknowledgements
Preface
Notes for Instructors
Notes for Students