Back to Examples
Back to Lab Intro

Example: Formula

Problem 5

A
B
C
D
E
1
Date
t
Euler
dQ/dt
Q-Formula
2
1/1/13
0
9500.00
-30.00
9500.00
3
2/1/13
1
9470.00
-29.10
9470.45
4
3/1/13
2
9440.90
-28.23
9441.76
5
4/1/13
3
9412.67
-27.38
9413.93
6
5/1/13
4
9385.29
-26.56
9386.92
7
6/1/13
5
9358.73
-25.76
9360.71

(All answers above have been rounded to two decimal places.)

The entries in column E are simply the formula given in the lab: Q = 8500+ 1000e-.03 t, which we enter in E2 as
=8500+1000*EXP(-.03*B2)
. The rest of the column can just be copied down.

Columns A, B, C and D were created for problem 1.

Back to Examples
Back to Lab Intro