Statistics Solutions

(Step-by-Step) 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 f

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 f 0 (x) f 1 (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 g n (x) for six terms and values of x from -3.5 to +3.5.

Price: $2.99
Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document


∴ Other downloads you may be interested in ∴

log in to your account

Forgot password?
Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in