~
CSC 152: FITTING A FUNCTION
~
The appropriate formula for this data is
v ( t ) = V ( 1 - e-t/T)
We enter the formula "=$B$1*(1-EXP(-A5/$B$2))" in cell C5.
Note we have replaced
- the parameter V with the cell reference $B$1, using
absolute addressing (the dollar signs)
- the variable t with the cell reference A5
- the parameter T with the cell reference $B$2, again
using absolute addressing
Also notice that the exponential function ex is
written out as EXP(x).
NEXT
BACK