Introduction to Data Modeling with Excel (Cont.)

 

We used as data the periods (X) of a pendulum versus its length (Y). We used the same spreadsheet created in the previous class to find quadratic and linear models for the same set of data.

 

Logbook

 

Just to remind that the logbook is a very important component of the course and will be evaluated, together with the final exam they count 20% of the course grade.

 

You should record the logbook on a daily basis, with pages numbered and dated, about two main topics:

            -Discussions and findings about projects, collectively or individually

            -Answers to questions posted here in the class notes and other learning conclusions you found by doing activities related to this course.

The next logbook due date is Feb 23, 2006.

 

Logbook questions:

 

1-      How did you modify your spreadsheet to produce a quadratic model, what was the s parameter and coefficients a,b,c for this model?

2-      How did you modify the spreadsheet to produce a linear model, what was the s parameter and coefficients b,c for this model?