DE04 : DE and Excel

Implement difference equations model in Excel and graphically display outcome"]]

  1. Translate standard subscript notation into Excel formulas
  2. Use autofill to extend integer time periods and formula for quantity of interest
  3. Use other cells to contain parameters that are referred to in the difference equation formula
  4. Make appropriate use of relative and absolute cell references so that formulas autofill correctly
  5. Use a "spinner" to make a parameter variable; use a "divide by (a power of) ten" formula to make a spinner control parameters of arbitrary precision.
  6. Format text in Excel to show subscripts.
  7. Create XY scatterplot charts with legends and titles depending on data
Basic
Intermediate
Advanced