week10a_exam1_feedback

# week10a_exam1_feedback - Exam 1 Highlights Exam 250 200 150...

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

Exam 1 Highlights Exam 1 Highlights 0 50 100 150 200 250 up to 40 40 - 45 45 - 50 50 - 55 55 - 60 60 - 65 65 - 70 70 - 75 75 - 80 80 - 85 85 - 90 90 - 95 95 - 100 Number of students in each range Exam 1 Grade, ENGR 195, Fall 2009

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

View Full Document
Problem 6. Problem 6. Excel Cell Addressing & Excel Cell Addressing & Formulas Formulas T = (T i – T w ) e -t/α + T w Write formula in cell B6 to be copied to C6:D11 = (B\$5-\$B\$1)*EXP(-\$A6/\$B\$2)+\$B\$1 A B C D E 1 Temperature of water (Tw, C): 25 2 Time constant (α, sec): 50 3 4 Initial Ball Temperature (C) 5 Time (t, sec) 250 600 700 6 0 250.0 7 1 245.5 8 2 241.2 9 3 236.9 10 4 232.7 11 5 228.6
Problem 8a. Problem 8a. Excel – Establishing a Trend Excel – Establishing a Trend Provide instructions for extending the trend in column X to cell A15 KEY IDEA : Need to highlight 2 or more cells (say A5:A6) to establish trend and then drag highlight to A15 A B C D E 1 alpha = 10 20 30 10 2 beta = -20 2 5 8 3 4 X Y R S T 5 0.1 2.5 =\$B\$2*\$A5+D\$1+B7 6 0.2 7 7 0.3 1 8 0.4 22 9 0.5 15 10 0.6 8

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

View Full Document
Problem 8c. Problem 8c.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 10

week10a_exam1_feedback - Exam 1 Highlights Exam 250 200 150...

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

View Full Document
Ask a homework question - tutors are online