Add the first six terms of the sequence using Excel. Enter these values and calculations in your spr
Question: Add the first six terms of the sequence using Excel. Enter these values and calculations in your spreadsheet like this:
| x | Sum of 6 terms | f0(x) | f1(x) |
| -3.5 | = Sum(C2:H2) | 1 | = -(A2^2)/FACT(2) |
| -3.0 | = Sum(C3:H3) | 1 | = -(A3^2)/FACT(2) |
| -2.5 | = Sum(C4:H:4) | 1 | = -(A4^2)/FACT(2) |
Row 1 consists of titles which are entered literally. Don’t worry about the subscripts.
Column A consists of the values of x. Use the range from -3.5 to +3.5 in increments of one half. Enter these literally or by using the calculation in cell A3, “= A2 + 1/2” and doing a Fill > Down.
After entering the calculations in Row 2, select Rows 2 to 16 and Columns B to H and do a Fill > Down. This can be done with the key combination Ctrl and d.
Repeat this process starting in Row 20 for gn(x) for six terms and values of x from -3.5 to +3.5.
Price: $2.99
See Solution: The solution file consists of 2 pages
Type of Deliverable: Word Document
Type of Deliverable: Word Document
