Purdue University
School of Civil Engineering
CE 512 The Comprehensive Urban Planning Process
Mon. 27 January 2020
Class 1 of 2 on Trend Projection Methods
Class Objectives:
By the end of class, the student will be able to ...
-
Determine when Trend Projection methods are appropriate.
-
List the types of Trend Projections methods available to us in CE512.
-
Identify what common difficulties to watch out for,
and explain how to cope with them.
Preparation for Class:
Know how to use "Add Trendline" in Microsoft Excel,
or its equivalent in other spreadsheets.
Reference:
SNotes 2
Theme Music:
No Trend, Koopa, 20xx, 3:19.
Up, Up, and Away,
Fifth Dimension, 1973, 2:29.
Time is on My Side,
Rolling Stones, 1964, 3:03.
Outline of Likely Topics
-
Forecasting changes in ________ over time
-
Examples
-
What will Mythaca County's population be 15 years from now?
-
Employment in 15 years?
-
How many jail cells will we need?
-
How many school-age children will live in each neighborhood in year ____?
births
-
Linear Extrapolation
-
Using Excel features
-
Linear Regression
-
Exponential
-
Logarithmic
-
Power Function
-
Polynomial, 2nd and 3rd order
