Class #8 - Thursday 09/19/2013





Finish Chapter 4 - Exploring Data With Graphs

Introduce Microsoft Excel VBA macros to make a wide dataset long (from 19 to 95 records)...




  1. How to do LINE GRAPHS and ERROR LINE CHARTS for two independent variables.

  2. Countries data from week #1 SPSS simple linear regression for R exercise.

  3. Turtles data has 19 records (aka rows) and we need to make 5 separate records from each record. Using Excel VBA macros to prepare the data for SPSS or R or SAS.