{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

EGR_102_Exam_1_Review_Problems-1

# EGR_102_Exam_1_Review_Problems-1 - EGR 102 Introduction to...

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

EGR 102 Introduction to Engineering Modeling Exam 1 Review Problems These will not be collected or graded, but will help you prepare for the exam. EXCEL Problem 1. For an equation of the form: y = Ax 2 + Bx + C For the following coefficients A, B, C A = 1 B = 10 C = 10 Using both relative and absolute references, calculate the value of y for a range of x from -20 to 20, with a step size of 2. Plot y versus x for that range. Use Goal Seek to calculate one of the values of x when y = 0. Show your answer to 3 decimal places. EXCEL Problem 2. For the same problem as above: The value of the coefficient B changes for different x values - 20 ≤ x < -5 B = 15 - 5 ≤ x < 5 B = 10 5 ≤ x ≤ 20 B = 5 Using at least one IF statement, calculate the value of y for a range of x from -20 to 20, with a step size of 2. Plot y versus x for that range. Use Goal Seek to calculate one of the values of x when y = 0. Show your answer to 3 decimal places.

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

View Full Document