Class06 - CO2 Emmissions for the US, 1989 - 2000 1550 1500...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Class meeting #6 Monday, Sept 13 th Spreadsheet Problem Solving b array formulas h vector-matrix calculations b fitting models to data h straight-line regression Homework #3 due Wednesday y = 21.32x - 41090.17 1300 1350 1400 1450 1500 1550 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 CO 2 Emissions (MMT Carbon) Year CO 2 Emmissions for the US, 1989 - 2000 GEEN 1300 Introduction to Engineering Computing
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Reminder • Office hours: – Dr. Nuttelman: Mondays, 4:30-6:00 ECCH 124 – Dr. Clough: Tuesdays, 4:30-6:00 (right next door) • TA Office hours – schedule posted on CULearn 2
Background image of page 2
3 Clicker Question Which of the following scenarios cannot be handled with Excel’s Solver tool? A) adjusting one cell to achieve a maximum in a target cell B) adjusting one cell to achieve target values in two cells subject to one constraint C) adjusting two cells to achieve a minimum in a target cell D) adjusting four cells to achieve a maximum in a target cell subject to two constraints E) adjusting one cell to achieve a target value in a target cell
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
4 Vector-Matrix Calculations in Excel called Array Formulas Set up example for case study of f(x) vs x ( ) ( ) x f x 1 ln x = - Case study by copying formula range B2:B11 named x Copy down using relative addressing
Background image of page 4
5 Alternate approach using array formula Select C2:C11 as destination for array formula (not just C2) Type formula in terms of array x (not just B2) Finish with Ctrl-Shift-Enter (not just the Enter key) Notice that Excel surrounds the array formula with braces { } Excel does this automatically Here, one formula alone controls the calculation -- in the formula copy example, 10 formulas
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Use of array formulas for vector-matrix calculations Vector addition Ctrl- Shift- Enter Matrix functions: MMULT matrix multiplication
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/07/2010 for the course CHEN 1300 at Colorado.

Page1 / 30

Class06 - CO2 Emmissions for the US, 1989 - 2000 1550 1500...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online