week10a_exam1_feedback

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
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
Background image of page 3

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

View Full DocumentRight Arrow Icon
Problem 8c. Problem 8c.
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

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 Right Arrow Icon
Ask a homework question - tutors are online