Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Example L . 1 . 1 . Let's use Excel to build the sequence with first term a 0 = 4 and common difference d

Example L.1.1. Let's use Excel to build the sequence with first term a0=4 and common difference d=3.
(1) Be sure you have your Lab 1 Excel Template open to the "Example L.1.1.-2." tab.
(2) We will put our index in column A. After entering the first few indices (e.g.,0,1,2 in A2,3, and 4), highlight these cells then move your cursor to the bottom right corner of the highlighted boxes until your cursor becomes a black plus. Dragging down will cause Excel to autocomplete. Drag down until you reach an index of 20.
(3) Next, let's create our sequence in column B. We start by putting 4 in B2(i.e., the n=0 term). Since we get to the next term in the sequence by adding 3 to the previous, in B3, we put "=B2+3". The "=" indicates to Excel that you are writing a formula and our formula instructs Excel to add 3 to the entry in B2.
(4) To complete the sequence, highlight B3 and, as when filling in Column A, drag down from with the black plus until you get to term 20. If you've done things correctly, you should have an arithmetic sequence ending at 64 in cell B22.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions