Math 110 Fall 2008

When you are making the linear scale graph for the CO₂ dataset, it does not make a difference whether you leave in the data points with the missing y-values.

However, when you are making the log-transformed Y (=log y) vs x semi-log graph for the CO₂ dataset, Excel will be attempting to take the LOG of nonexistent values and will report a #NUM! error in those cells. Simply delete these erroneous Y values - there are seven of them, at (rescaled yrs since 1958) x-values of 0, 0.08, 0.42, 0.75, 6.08, 6.17, and 6.25 - to make the plot correct; your resulting R² should then be very high and close to that of the linear plot.

Homework for Fri 21.Nov:

Do 7.7 #1-3 + 5-17all

Fit power functions to the following pairs of points:

a) (1,1) & (5,125) – we did this one in class: y = x³

b) (2, ¼) & (4, 1/16)

c) (2,8) & (5,50)

34. Class Session Mon 17.Nov:

Covered homework 7.5-7.6

~~Introduced 7.7~~ I’ll introduce 7.7 and give out the handouts on Wednesday after the Quiz

I’ll leave the links up in case you want to peek ahead:

Log-Log handout | Excel file

Reminder:

Quiz #6 over 7.1-7.4 on Wed. 19.Nov

Project #1 (50 pts) due Mon 24.Nov

Announcement: Exam #3 over Chapters 6 & 7 likely on Wed. 03.Dec

Homework for Wed 19.Nov:

Study for Quiz

Homework for Fri 21.Nov:

Do 7.7 #1-3 + 5-17all

Fit power function (weight as function of height) to NBA athletes (Excel file)

Fit power functions to the following pairs of points:

a) (1,1) & (5,125)

b) (2, ¼) & (4, 1/16)

c) (2,8) & (5,50)

33. Classs Session Fri 14.Nov:

Returned Quiz #5

Covered homework 7.3-7.4

Introduced 7.5-7.6

Announcement: Quiz #6 over 7.1-7.4 on Wed. 19.Nov

Reminder: Project #1 (50 pts) due Mon 24.Nov

Homework for Mon 17.Nov:

7.5 #2-10evens + 14-20evens + 9,11,13

7.6 #4,6,7,8,14

32. Class Session Wed 12.Nov:

Covered homework 7.1-7.2

Introduced 7.3-7.4

Handed out Project #1 – Project #1 handout | Project #1 Excel file (download by right-clicking and “Save Target As...”)

50 points – due Mon 24.Nov

Announcement: Office hours tomorrow (Thu 13.Nov) shifted to 9:00-10:50

Homework for Fri 14.Nov:

7.3 #1-12all

7.4 #2-12even + 9

31. Class Session Mon 10.Nov:

Gave Quiz #5 | KEY

Covered homework 6.6 | key to #13

Introduced 7.1-7.2

Homework for Wed 12.Nov:

7.1 #2 + 6-12evens

7.2 #2-14evens + 19,20,22

30. Class Session Fri 07.Nov:

Covered additional questions 6.1-6.5

Reminder: Quiz#5 over 6.1-6.5 on Mon 10.Nov

Introduced 6.6 see also Handout over Semi-log plots | accompanying Excel file with graphs

example problem (from 6.5 #18) shown in class

Summary of Exponential Functions

Homework for Mon 10.Nov:

study for Quiz

6.6 #1-13all [ Excel file for #13 ]

29. Class Session Wed 05.Nov:

Covered homework 6.5

Announcement: we’ll have the quiz over 6.1-6.5 on Mon 10.Nov

Homework for Fri 07.Nov:

Read 6.6 + Handout over Semi-log plots | accompanying Excel file with graphs

28. Class Session Mon 03.Nov:

Returned Exam #2

Covered homework 6.3-6.4

Reminder: Quiz #5 over 6.1-6.5 (+ possibly 6.6) likely on Fri 7.Nov or Mon 10.Nov

Homework for Wed 05.Nov:

prepare lingering questions over 6.1-6.4; we will look at 6.5

Read 6.6 + Handout over Semi-log plots | accompanying Excel file with graphs

27. Class Session Fri 31.Oct:

Covered homework 6.2

Introduced 6.3-6.5

Announcement: Quiz #5 over 6.1-6.5 (+ possibly 6.6) likely on Fri 7.Nov or Mon 10.Nov

Homework for Mon 03.Nov:

6.3 #8-24evens

6.4 #7-9,11-13 (read section for hints for 11-13)

6.5 #1,2,4-8,10,14,16,18

26. Class Session Wed 29.Oct:

Gave Exam #2 | KEY

Homework for Fri 31.Oct:

Read 6.3-6.5

6.2 #1-6 + 8-13 + 15-18

25. Class Session Mon 27.Oct:

Reviewed for Exam

Reminder: Exam #2 over Chapters 4 & 5 on Wed 29.Oct – see old exams #2 (all years)

Homework for Fri 31.Oct:

Read 6.3-6.5

6.2 #1-6 + 8-13 + 15-18

24. Class Session Fri 24.Oct:

Returned Quiz #4

Covered homework 6.1

Introduced 6.2 – example for 6.2

Reminder: Exam #2 over Chapters 4 & 5 on Wed 29.Oct – see old exams #2 (all years)

Homework for Mon 27.Oct:

6.2 #1-6 + 8-13 + 15-18

work through practice exams, be prepared to ask questions in preparation for Wednesday’s exam

23. Class Wed 22.Oct:

Gave Quiz #4 | KEY

Covered 5.7 | Answers to 5.7 #1 + 5.7 #5

Introduced 6.1

Reminder: Exam #2 over Chapters 4 & 5 on Wed 29.Oct – see old exams #2 (all years)

Homework for Fri 24.Oct:

Read 6.1-6.2

6.1 #14,16,18,20,24,25,26,30,32

22. Class Session Mon 20.Oct:

Reviewed for quiz on Wed.

Introduced 5.7 – semi-log examples

Reminder:

Quiz #4 over 4.6-4.7 + 5.1-5.6 on Wed 22.Oct – see old quizzes #4 (all years) and quiz #5 (F06)

Exam #2 over Chapters 4 & 5 on Wed 29.Oct – see old exams #2 (all years)

Homework for Wed 22.Oct:

study for quiz

Do 5.7 #1-5 + 7 ( Excel file for 5.7 #1 + CelCount.xls & EColi.xls files for 5.7 #5 )

21. Class Session Fri 17.Oct:

Continued with 5.5 & 5.6

Returned Small Excel Assignments #1 & 2

Reminder:

Quiz #4 over 4.6-4.7 + 5.1-5.6 on Wed 22.Oct – see old quizzes #4 (all years) and quiz #5 (F06)

Exam #2 over Chapters 4 & 5 likely on Wed 29.Oct – see old exams #2 (all years)

Homework for Mon 20.Oct:

Do 5.6 #23,24,26,27

20. Class Session Wed 15.Oct:

Covered homework 5.3 & 5.4

answers to problems from Christain Science Monitor article (t = years since 1990)

(your answers may vary slightly depending on how you interpreted the endpoints on the graph):

Public Tuition: Pub(t) = 2000 ∙ 1.0698^t

If tuition had followed inflation: Inf(t) = 2000 ∙ 1.0274^t

Private Tuition: Pri(t) = 10000 ∙ 1.0507^t

If tuition had followed inflation: Inf(t) = 10000 ∙ 1.0257^t

Note that the inflation growth factor is essentially the same

Introduced 5.5 & 5.6

Important: My treatment of 5.5 differs from the book. I use the single equation a = 1 + r for the relationship between per-unit growth/decay factor (a) and per-unit growth/decay rate (r), and r is positive or negative to indicate growth or decay.

Announcement: likely schedule for upcoming weeks:

Quiz #4 over ~~5.1-5.6~~ 4.6-5.6 likely on Wed 22.Oct – see old quizzes #4 (all years) and quiz #5 (F06)

Exam #2 over Chapters 4 & 5 likely on Wed 29.Oct – see old exams #2 (all years)

Homework for Fri 17.Oct:

5.5 #1-6all + 12,12,18,22,23

5.6 #2,4,6,8,12-15all,22

*FALL BREAK*

19. Class Session Fri 10.Oct:

Covered homework 4.6-4.7,5.2

Introduced 5.3-5.4

Homework for Wed 15.Oct:

Read remainder of Chapter 5

Do 5.3 #2-18evens

5.4 #2,4-8all,12,14

Tuition costs problem from article: CSM article about higher education costs

use endpoints

calculate actual costs and “if followed inflation” costs for both private and public shools

18. Class Session Wed 08.Oct :

Returned Quiz #3

Small Excel Assignments due / my version of the graphs

Covered homework for 5.1

Introduced 5.2

Slides about logistics growth / human population growth

Homework for Fri 10.Oct:

Read 5.3-5.4

Do 5.2 #1-10 (skip 3cd) + 13-15

17. Class Session Mon 06.Oct:

Gave Quiz #3 / KEY

Answered questions about Excel assignments (Reminder: due at beginning of class on Wed. 08.Oct)

Did not cover homework 4.6-4.7 – be prepared to discuss these on Wed.

Introduced 5.1

Homework for Wed 08.Oct:

Read 5.1-5.4

Do 5.1 #1 + 2-14evens

16. Class Session Fri 03.Oct:

Covered homework 4.1-4.5

Introduced 4.6-4.7

Reminder: Quiz #3 over 4.1-4.5 will be on Mon 06.Oct

see Quiz #3 for S08,F07,F06 and question #3 on Quiz #4 (F07)

also look at similar problems on Exam #2’s

Reminder: Small Excel Assignments are due Wed 08.Oct (see Class Session #15)

Homework for Mon 06.Oct:

4.6 #1,4,8,12,13,14,17

4.7 #1,4,8,10,12,14,16,19,20

15. Class Session Wed 01.Oct:

Returned Exam #1

~~Covered homework 4.1-4.3~~ (we’ll look at these on Fri)

Announcement: Quiz #3 over 4.1-4.5 will be on Mon 06.Oct

see Quiz #3 for S08,F07,F06 and question #3 on Quiz #4 (F07)

also look at similar problems on Exam #2’s

Small Excel Assignments #1 & 2 (10 points each - due Wed 08.Oct):

Small Assignment Task Handout | Small Assignment Excel File

Introduced 4.4-4.5

Homework for Fri 03.Oct:

Read 4.6-4.7

Do 4.4 #2,6,10,14,18, 23, 24

4.5 #2, 6-11all, 14-18all

14. Class Session Mon 29.Sep:

My versions of Extended Exploration graphs: CaloriesKEY.xls | MotorKEY.xls | UnionKEY.xls

Introduced 4.1-4.3

Homework for Wed 01.Oct:

4.1 #1-9all + 11-14all

4.2 #2-14evens + 20

4.3 #2-8evens + 12,16,22

13. Class Session Fri 26.Sep:

Gave Exam #1 / KEY

Homework for Mon 29.Sep:

Extended Exploration pp. 162-164 #12 (CALORIES.XLS), 17 (MOTOR.XLS), 18 (UNION.XLS)

remember to Save & Open by right-clicking and doing “Save Target As...” or “Save Link”)

Read 4.1-4.3

12. Class Session Wed 24.Sep:

Returned Quiz #2

Excel handout KEY

Reminder:

Exam #1 over Chapters 1-2 will be on Fri 26.Sep

Homework for Fri 26.Sep:

no homework - study for Exam #1

Homework for Mon 29.Sep:

Extended Exploration pp. 162-164 #12 (CALORIES.XLS), 17 (MOTOR.XLS), 18 (UNION.XLS)

remember to Save & Open by right-clicking and doing “Save Target As...” or “Save Link”)

Read 4.1-4.3

11. Class Session Mon 22.Sep:

Gave Quiz #2 / KEY

Excel exercise handout

BicycleRides file

Download in Explorer by right-clicking on the link and then choosing “Save Target As...”

Download in Firefox by right-clicking on the link and then choosing “Save Link As...”

Link to Math 110 Guide to Using Excel

Reminder:

Exam #1 over Chapters 1-2 on Fri 26.Sep

Homework for Wed 24.Sep:

Read Extended Exploration pp.~~133-147~~ 145-157

Produce the graphs indicated in the handout ;

be prepared to ask questions about any problems you encounter

10. Class Session Fri 19.Sep:

Covered homework 2.9

Did not introduce any new material

Reminder:

Quiz #2 over 2.1-2.9 on Mon 22.Sep

Exam #1 over Chapters 1-2 on Fri 26.Sep

Homework for Mon 22.Sep:

Study for Quiz

Read Extended Exploration pp. 145-157

9. Class Session Wed 17.Sep:

Covered homework 2.8

Introduced 2.9

Announcements:

Quiz #2 over 2.1-2.9 likely on Mon 22.Sep

Exam #1 over Chapters 1-2 likely on Fri 26.Sep

Homework for Fri 19.Sep:

Read Extended Exploration pp. 145-157

Do 2.9 #2,4,6,8,12,14

8. Class Session Mon 15.Sep:

Covered homework 2.6-2.7

Introduced 2.8

Homework for Wed 17.Sep:

2.8 #2-20evens + 24,27,28,29,32

7. Class Session Fri 12.Sep:

Returned Quiz #1

Covered homework 2.4.-2.5

Introduced 2.6-2.7

Homework for Mon 15.Sep:

Read 2.8-2.9

Do 2.6 #4-12 evens

2.7 #4,8,...24 (every other evens)

6. Class Session Wed 10.Sep:

Gave Quiz #1 / KEY

Covered homework 2.1-2.3

Introduced 2.4-2.5

Homework for Fri 12.Sep:

Read 2.6-2.7

Do 2.4 #2,4,6,14

2.5 #4,8,...24 (every other even) + 6,10,17

5. Class Session Mon 08.Sep:

Covered homework 1.5

Introduced 2.1-2.3

Reminder: Quiz #1 over 1.1-1.5 will be on Wed 10.Sep

Homework for Wed 10.Sep:

Study for Quiz #1 (see old quizzes, also look at chapter review in book)

Read 2.4-2.5

Do 2.1 #4,8,12,16

2.2 #4,8,10

2.3 #6,10,12,14,16,19

4. Class Session Fri 05.Sep:

Reviewed more homework from earlier sections

Introduced 1.5

Reminder: Quiz #1 over 1.1-1.5 will likely be next Wed 10.Sep or Fri 12.Sep

Homework for Mon 08.Sep:

Read 2.1-2.3

Do 1.5 #4-10all + 14-16all

3. Class Session Wed 03.Sep:

Covered homework 1.3-1.4

Announcement: Quiz #1 over 1.1-1.5 will likely be next Wed 10.Sep or Fri 12.Sep

Homework for Fri 05.Sep:

2. Class Session Mon 01.Sep:

Introduced 1.2

Covered homework 1.1-1.2

Introduced 1.3-1.4

Homework for Wed 03.Sep:

Read 1.3-1.5

Do 1.3 #1,2,4,6,8,10,11,13

Do 1.4 #4,12,16,18

1. Class Session Fri 29.Aug:

Introduction to course - syllabus

Introduced 1.1

Problems with the concept of ‘average’

Homework for Mon 01.Sep (yes, there are classes on Labor Day!):

Read through the Math 110 Guide to Using Excel (link above)

Read 1.1-1.3

Do 1.1 #1-11odd + 15,16,18,19,28

correction: also do 1.2 #3-17odd