Spreadsheet Basics
A.1 Introduction to Spreadsheets
A.2 Built-in Functions
A.3 Charts
Chapter 1: An Excel-lent Approach to Relationships
1.1 Functions
1.2 Analytic Representations: Equations
1.3 Numerical and Graphical Representations: Tables and Charts
1.4 Spotlight on Statistics
Chapter 2: Ratios and Proportions
2.1 Ratios and Proportions
2.2 Weighted Averages
2.3 Proportionality
2.4 Financial Literacy
2.5 Spotlight on Statistics
Chapter 3: Units, Conversions, Scales, and Rates
3.1 Units and Conversions
3.2 Scales
3.3 Rates
3.4 Dosages and Concentrations
3.5 Spotlight on Statistics
Chapter 4: Percentages
4.1 Percentages
4.2 Part-to-Whole Ratios
4.3 Percent Change and Difference
4.4 Data Tables with Percentages
4.5 Spotlight on Statistics
Chapter 5: Linear Functions
5.1 Proportionality
5.2 Slopes and y-intercepts
5.3 Linear Equations
5.4 Spotlight on Statistics
Chapter 6: Exponential Functions
6.1 Constant Percent Change
6.2 Exponential Functions
6.3 Average Percent Change
6.4 Spotlight on Statistics
Chapter 7: Logical Arithmetic
7.1 Logarithms
7.2 Doubling Times and Half-Lives
7.3 Annual Percentage Yield
7.4 Continuous Growth and Euler’s Number: e
7.5 Spotlight on Statistics
Chapter 8: Curve Fitting and Correlation
8.1 Correlation, Causation, and Confounding Factors
8.2 Best-Fit, Least-Squares, and Regression Lines
8.3 Correlation Coefficient and Coefficient of Linear Determination
8.4 Spotlight on Statistics
Chapter 9: Financial Health
9.1 Retirement
9.2 Securities: Cash, Stocks, Mutual Funds, and Bonds
9.3 401(k) Plans
9.4 Built-in Financial Functions
9.5 Loans
Chapter 10: Logically!
10.1 Logical Statements
10.2 Excel’s IF Function
10.3 VLOOKUP
10.4 Random Simulations
Chapter 11: Chance, Risk, and Likelihood
11.1 Risk and Decision Making
11.2 Probability and Counting
11.3 Conditional Probabilities
11.4 Unions and Complements
11.5 Spotlight on Statistics
NEW - Chapter 12: Statistically Speaking
12.1 Data Distributions: Frequency and Probability
12.2 Binomial and Normal Distributions
12.3 Sampling Distributions and Confidence Intervals
12.4 Hypothesis Testing
NEW - Chapter 13: Modeling the Real World
13.1 Modeling Basics
13.2 Rate (Population) Models
13.3 Stochastic (Random) Models
13.4 Linear Programming (Optimization) Models
13.5 Spotlight on Statistics