. Kevin D. Hoover, Applied Intermediate Macroeconomics. Cambridge University Press, ©2012 Using Excel The text assumes that students know the basics of Excel. If this is not true, there are number of resources for getting started:
.
Using Excel
Worked examples of Excel Hints from the text listed by Topic or by Point of Occurence in the Text Excel Hints by Topic These hints were created using Excel 2003; there may be small differences with later versions of Excel 1. Calculating Using Percent and Percentage Point 2. Calculating First Differences 3. Using the Excel IF( ) Function -- Especially to Identify Recessions 4. Using the Excel RATE( ) and PV( ) Functions 5. Smoothing Options for Charts 6. Graphing a Yield Curve 7. Inserting Trend or Regression Lines on Charts 8. Using the Excel IRR( ) and NPV( ) Functions 9. Inserting Charts 10. Calculating Measures of Central Tendency and Dispersion (mean, median, mode, geometric mean; variance, standard deviation) 11. Common and Natural Logarithms 12. Trends and Detrending 13. Correlation 14. Adding Recession (and Other Date) Shading to Charts Back to Top of Page Excel Hints by Point of Occurrence These hints were created using Excel 2003; there may be small differences with later versions of Excel Problem 2.1: Percentages and Percentage Points Problem 2.16: First Differences Problem 2.16: Excel IF( ) Function Problem 6.22: Excel RATE( ) and PV( ) Functions Chapter 7, footnote 12: Smoothing Options for Charts Problem 7.7: Graphing a Yield Curve Chapter 11, p. 419: Inserting Trend or Regression Lines on Charts Problem 14.9: Excel IRR( ) Function Problem 14.11: Excel NPV( ) Function Problem 14.12: Excel IRR( ) and NPV( ) Functions Guide, G.1.2, p. 731: Percentages and Percentage Points Guide, G.2.1, p. 733: Inserting a Chart Guide, G.4.2, p. 741: Calculating Means Guide, G.4.2, p. 743: Calculating Medians Guide, G.4.2, p. 743: Calculating Geometric Means Guide, G.4.3, p. 746: Calculating Variance Guide, G.4.3, p. 743: Calculating Standard Deviation Guide, G.10.1, p. 764: Percentages and Percentage Points Guide, G.11.1, p. 770: Common and Natural Logarithms Guide G.12, p. 779: Trends and Detrending Guide G.12, p. 781: Moving Average Trends Guide G.13.3, p. 787: Excel CORREL( ) Function Guide G.13.4, p. 787: Excel CORREL( ) Function Guide G.13.4, p. 799: Inserting Trend or Regression Lines on Charts Back to Top of Page
Worked examples of Excel Hints from the text listed by Topic or by Point of Occurence in the Text
Excel Hints by Topic
These hints were created using Excel 2003; there may be small differences with later versions of Excel
3. Using the Excel IF( ) Function -- Especially to Identify
Recessions
10. Calculating Measures of Central Tendency and
Dispersion (mean, median, mode, geometric mean;
variance, standard deviation)
Back to Top of Page
Excel Hints by Point of Occurrence
Problem 2.16: Excel IF( ) Function
Chapter 11, p. 419: Inserting Trend or Regression Lines
on Charts
Guide G.13.4, p. 787: Excel CORREL( ) Function
Guide G.13.4, p. 799: Inserting Trend or Regression Lines