Use Excel to make a graph and fit an exponential trend line to the data (see bel

Question

Use Excel to make a graph and fit an exponential trend line to the data (see below);

Write down the equation that Excel has fit to the data

y = 13.739e^-0.203x
R² = 0.99654

.The equation will be of the form y=Ae^-Bx where numerical values for A and B are given by Excel. The x stands for the times that you gave Excel and y stands for the voltages that you specified so that the equation fit by Excel really means V=Ae^-Bt. The equation BV=Ae^-Bt can’t depend on the units that you used. (After all, Excel didn’t use information about units in the curve-fit.) What are the units of A? What are the units of B? (Hint: begin by thinking about the units that B must have if time is measured in seconds.) [3]

Explanation / Answer

The equation that Excel fits to the data : y = 13.93503983 e-2.070052973·10-1 x

or

V= 13.93503983 e-2.070052973·10-1 t

Unit of A = Volts

Unit of B = sec-1

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.