.

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: 
  • In Excel itself click HELP on the main menu to find answers to specific questions.

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