Assume all cells not shown begin blank. A downwards arrow indicates the contents from the cell above will be copied down. X f(x) A B 1 0 ? 2 0.01 ↓ 3 0.02 4 0.03 ↓ ↓ ↓ 6 0.05 ↓ 5 0.04 678 7 0.06 +- ↓ ↓ ↓ a) A1 has 0 entered into it, and you want to generate the rest of the entries in column A. You will type something into A2, and copy it down to A3, A4, A5, and A6. What should you type into A2? Select the best answer.
Assume all cells not shown begin blank. A downwards arrow indicates the contents from the cell above will be copied down. X f(x) A B 1 0 ? 2 0.01 ↓ 3 0.02 4 0.03 ↓ ↓ ↓ 6 0.05 ↓ 5 0.04 678 7 0.06 +- ↓ ↓ ↓ a) A1 has 0 entered into it, and you want to generate the rest of the entries in column A. You will type something into A2, and copy it down to A3, A4, A5, and A6. What should you type into A2? Select the best answer.
Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
Related questions
Question
Transcribed Image Text:Assume all cells not shown begin blank. A downwards arrow indicates the contents from the cell above will be copied down.
f(x)
O=0+0.01
O=A2+0.01
O A2+0.01
O 0+0.01
O=0.01
X
A
1
0
2
0.01
3
0.02
4
0.03
5 0.04
6
0.05
7
0.06
8
A1+0.01
O A2=0.01
O A1=0.01
O=A1+0.01
O A2-A1+0.01
BC
?
↓
↓
↓
↓
↓
a) A1 has 0 entered into it, and you want to generate the rest of the entries in column A. You will type something into A2, and copy it
down to A3, A4, A5, and A6. What should you type into A2? Select the best answer.
↓
↓
![b) In collumn B, we want to generate values for f(x), what formula should be written in cell B1 and then be copied down to the cells
below?
=A2^3+2*A2^2-3 *A2+2
x^3+2x^2-3 x +2
O=B1^3+2*B1^2-3 *B1 +2
O=x^3+2x^2-3 x +2
A1^3+2*A1^2-3 *A1 +2
=A1^3+2*A1^2-3 *A1 +2
c) Use your spreadsheet to estimate the value of x in the interval [0, 1] for which f(x) assumes it's minimum value. Give your answer
correct to 2 decimal places.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F4ae89d13-3da3-4f42-8a30-4752fc9f6b5c%2F73240658-2b6e-4b3d-ae49-58fa6f398c0d%2Ftl69gqp_processed.jpeg&w=3840&q=75)
Transcribed Image Text:b) In collumn B, we want to generate values for f(x), what formula should be written in cell B1 and then be copied down to the cells
below?
=A2^3+2*A2^2-3 *A2+2
x^3+2x^2-3 x +2
O=B1^3+2*B1^2-3 *B1 +2
O=x^3+2x^2-3 x +2
A1^3+2*A1^2-3 *A1 +2
=A1^3+2*A1^2-3 *A1 +2
c) Use your spreadsheet to estimate the value of x in the interval [0, 1] for which f(x) assumes it's minimum value. Give your answer
correct to 2 decimal places.
Expert Solution
Step 1
The table given is as follows:
(a) We are asked to find a formula to generate numbers as given in column A.
Since the values are in form of a sequence and depend on the previous value, we will first find the common difference.
We see that the common difference is .
The value in the 4th row is which can be written as . This can also be written as .
We will include "=" in the beginning of the formula to indicate what we enter in the cell is a formula and not a value.
Hence, the formula that should be entered in the cell A2 is which is the last second option in the choices given.
The solution is as follows:
Step by step
Solved in 4 steps with 9 images
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
