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