{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Class06

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

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

1 Class meeting #6 Monday, Sept 13 th Spreadsheet Problem Solving boxshadowdwn array formulas head2right vector-matrix calculations boxshadowdwn fitting models to data head2right 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

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

View Full Document
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
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

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

View Full Document
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
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

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

View Full Document
6 Use of array formulas for vector-matrix calculations Vector addition Ctrl- Shift- Enter Matrix functions: MMULT matrix multiplication MINVERSE
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}