EXCEL ASSIGNMENT #3

Reading: Do this BEFORE class on Thursday:

Chapter 7, Solving Single Equations, Sections 7.1 thru 7.4

Chapter 8, Solving Simultaneous Equations

(First half is a review of what we've done in class)

Chapter 12, Sorting and Retrieving (only 7 pages!)

We will skip chapters 9, 10, and 11, though many of you in ME,CE, IE, or BSE may eventually want to use chapter 11 as a reference when you learn what a nonlinear optimization problem is!

Problems: Due Thursday, 2/25 (I will go over the techniques for some of these at the start of lab on Thursday, 2/18, and you will have the rest of lab to get started):


SUBMISSION:Paper copies only!
Electronic submission will not be necessary for these problems

7.4,7.9(Use Goal Seek AND Solver, if installed)

Both the above use the same equation, just different methods -- you may put all of them on the same spreadsheet.

7.11

8.9

8.15 (A and B only)

8.21

8.23

12.1

12.3