[WW HOME] [TEACHING] [MATH] [SEARCH] [FEEDBACK]


Illustrating the Fundamental Theorem

of Calculus Using Spreadsheets

Daniel Lotesto and Susan Thurmond

Introduction

The Fundamental Theorem of Calculus, which states

Undisplayed Graphic,

is one of the most difficult concepts for a student to grasp. Students do not always see the relationship between the area bounded by y = f(x), the x-axis, x=a, and x=b, and the difference between the antiderivative values F(b) and F(a). This spreadsheet activity illustrates the theorem by using Euler's Method to approximate the value for F(b) - F(a) and Riemann Sums to approximate the definite integral. The graphs offer a visual representation of the theorem.

Preliminary Discussion of Euler's Method

Given a function F(x), and its derivative = F'(x) = f(x) , we can approximate function values for F assuming that we know initial values (x0, y0) where y0 = F(x0). Choosing a value for x, we can generate values of x and y using the following recursive equations:

xn = xn-1 + x

F(xn) yn = yn-1 + f(xn-1) x

An example is shown in Figure 1 using two iterations.

Where P0 = (x0 ,F(x0)), P1 = (x1, y0 + f(x0) x), P2 = (x2, y1 + f(x1) x).

As x 0, the yn values more closely approximate F(xn).

A particularly useful function to use for the derivative is F'(x) = f(x) = since, in most courses, F(x) = ln x has not yet been defined as

.

Therefore, not only are students unburdened by preconceptions of the graph of y = F(x) while building the spreadsheet, they actually construct the graph of y = ln x in the process.

Activity

Working in pairs or small groups, have the students prepare spreadsheets to generate y values using Euler's Method and to find the areas of the corresponding rectangles using the left endpoint rule. The amount of instructor input will depend upon the ability level of the class. Sample spreadsheets using Microsoft Excel are shown in this article as well as a brief description of how to generate them. They are offered as a guide. The instructor is encouraged to work with her/his students to create their own version.

Spreadsheet #1 uses Euler's Method to find the approximate y values for y = F(x). The initial values for x0 and y0 are entered in cells [A12] and [D12], respectively. The value for x is entered in [C5]. The following formulas are used to complete the spreadsheet:

[A13] =A12+$C$5, fill down

[B13] =1/A12, fill down

[C13] =B13*$C$5, fill down

[D13] =D12+C13, fill down

[E12] =D12 - $D$12, fill down

Spreadsheet #2 is a continuation of spreadsheet #1. It uses the left endpoint rule to compute areas of rectangles. The formulas are as follows:

[F7] =A12

[F8] =F7+$C$5, fill down

[G7] =1/F7, fill down

[H7] =G7*$C$5, fill down

[I7] =H7

[I8] =I7+H8, fill down

[K6] =E12, fill down

SPREADSHEET #1


A

B

C

D

E

1


Constructing the Graph of F(x) Using Euler's Method


2






3


Given: f(x) = slope function (the derivative of some function F(x))

4


Given: f(x) = 1/x; F(a)=F(1)=0



5


Given x =

0.1



6






7






8




F(x)


9

x

f(prev x)

f(prev x)* x

y = prev y +

F(x)-F(a)

10




f(prev x)* x


11






12

1



0

0

13

1.1

1

0.1

0.1

0.1

14

1.2

0.90909091

0.090909091

0.190909091

0.19090909

15

1.3

0.83333333

0.083333333

0.274242424

0.27424242

16

1.4

0.76923077

0.076923077

0.351165501

0.3511655

17

1.5

0.71428571

0.071428571

0.422594073

0.42259407

18

1.6

0.66666667

0.066666667

0.489260739

0.48926074

19

1.7

0.625

0.0625

0.551760739

0.55176074

20

1.8

0.58823529

0.058823529

0.610584269

0.61058427

21

1.9

0.55555556

0.055555556

0.666139824

0.66613982

22

2

0.52631579

0.052631579

0.718771403

0.7187714

23

2.1

0.5

0.05

0.768771403

0.7687714

24

2.2

0.47619048

0.047619048

0.816390451

0.81639045

25

2.3

0.45454545

0.045454545

0.861844996

0.861845

26

2.4

0.43478261

0.043478261

0.905323257

0.90532326

27

2.5

0.41666667

0.041666667

0.946989924

0.94698992

28

2.6

0.4

0.04

0.986989924

0.98698992

29

2.7

0.38461538

0.038461538

1.025451462

1.02545146

30

2.8

0.37037037

0.037037037

1.062488499

1.0624885

31

2.9

0.35714286

0.035714286

1.098202785

1.09820278

32

3

0.34482759

0.034482759

1.132685544

1.13268554

Figure 2

SPREADSHEET #2

F

G

H

I

J

K

Approximating Area Bounded by f(x), the x-axis, x = a and x = b


Using Riemann Sums and the Left-Endpoint Rule















Left endpoint

Height (H)

A=H* x

Areas


F(x)-F(a)






0

1

1

0.1

0.1


0.1

1.1

0.90909091

0.09090909

0.19090909


0.19090909

1.2

0.83333333

0.08333333

0.27424242


0.27424242

1.3

0.76923077

0.07692308

0.3511655


0.3511655

1.4

0.71428571

0.07142857

0.42259407


0.42259407

1.5

0.66666667

0.06666667

0.48926074


0.48926074

1.6

0.625

0.0625

0.55176074


0.55176074

1.7

0.58823529

0.05882353

0.61058427


0.61058427

1.8

0.55555556

0.05555556

0.66613982


0.66613982

1.9

0.52631579

0.05263158

0.7187714


0.7187714

2

0.5

0.05

0.7687714


0.7687714

2.1

0.47619048

0.04761905

0.81639045


0.81639045

2.2

0.45454545

0.04545455

0.861845


0.861845

2.3

0.43478261

0.04347826

0.90532326


0.90532326

2.4

0.41666667

0.04166667

0.94698992


0.94698992

2.5

0.4

0.04

0.98698992


0.98698992

2.6

0.38461538

0.03846154

1.02545146


1.02545146

2.7

0.37037037

0.03703704

1.0624885


1.0624885

2.8

0.35714286

0.03571429

1.09820278


1.09820278

2.9

0.34482759

0.03448276

1.13268554


1.13268554

Figure 3

Sample Questions to Explore:

1. How do the values in the columns labeled SArea and Approx F(x) - F(a) compare? What does this suggest to you?

2. Let a = 1.6. Without changing your spreadsheet, what is the sum of the areas from a to xn = b = 2.7? [Hint: the left-endpoint of the last interval is 2.6, not 2.7]. What is the value of F(b) - F(a)? Show on your graphs what these two numbers represent.

3. Change Dx to 0.05. [C5]. Does SAreas = Approx F(x) - F(a)?

4. Change Dx to 0.01. [C5]. Result?

5. Change Dx back to 0.1. Change the interval from [1,3] to [0.5, 2.5] by making the following changes: x0 = 0.5 [A12] ; y0 = -.6931 [D12]. These two values must be given. How do the values in the last two columns compare? Write out what these two values represent. [Note: a rectangle lying under the x-axis indicates a "negative area."]

6. Extend your spreadsheet to include 40 intervals so that the domain of x is [0.5, 4.5]. What is the equation for y = F(x)? Using your calculator, test your "guess".

7. Explore the function f(x) = -cos x from x0 = a = 0.5 to xn = b = 2.5. Change row 4 to read f(x) = -cos x ; F(a) = F(0.5) = -.4794. Change the following cells: [C5] to 0.1; [A12] to 0.5; [D12] to -.4794; [B13] to = -cos(A12), fill down; and [G7] to = -cos(F7), fill down. What is the approximate value of F(2.5) - F(0.5)? What is the value of Areas? Look at your graphs. Are they what you expect? Is the graph of F(x) the graph of the antiderivative of f(x) = -cosx?

Note to the instructor: Below is an analytical verification of what the comparison of the two spreadsheets illustrates. [Kevin Bartkovich, NCSSM]

f(x) is the derivative of some function F(x). The y values refer to points on the graph of the curve that approximates F(x) using Euler's Method. The point (x0,y0) is the initial point.

y1 = yo + f(xo) x

y2 = y1 + f(x1) x

yn = yn-1 + f(xn-1) x

y1 + y2 + ... + yn = (yo + f(xo) x) + (y1 + f(x1) x) + ... + (yn-1 + f(xn-1) x)

yn = yo + [f(xo) + f(x1) + ... +f(xn-1)] x

yn = yo +

The net change in y using Euler's Method is

yn - yo =

If xo = a and xn = b, then the net change in y as is

F(b) - F(a) =

This limit is the definite integral and we have F(b) - F(a) =

[WW HOME] [TEACHING] [MATH] [SEARCH] [FEEDBACK]


Woodrow Wilson Leadership Program in Mathematics * lpt@www.woodrow.org
The Woodrow Wilson National Fellowship Foundation * webmaster@woodrow.org
CN 5281, Princeton NJ 08543-5281 * Tel:(609)452-7007 * Fax:(609)452-0066