0
answers
0
watching
73
views
23 Nov 2019
You measure the potential difference across a capacitor atdifferent times while it's charging and record the followingresults:
Voltage (V) Time (s)
1.397 0.01655
2.731 0.03702
4.107 0.06658
5.525 0.11888
The final voltage the capacitor reaches after you go get somecoffee is 6.880 V.
(a) Use Excel to construct a spreadsheet that shows
(i) the above data as well as any and all calculations needed tocompute the resistance of the circuit component in question;
(ii) create a graph of -ln[(Vfinal-V)/Vfinal] vs. the time;
(iii) use Excel's trendline to plot a best-fit line through thedata and determine the slope from it.
(b) What is the slope of your graph?
Slope =
Time Constant (RC) =
You measure the potential difference across a capacitor atdifferent times while it's charging and record the followingresults:
Voltage (V) Time (s)
1.397 0.01655
2.731 0.03702
4.107 0.06658
5.525 0.11888
The final voltage the capacitor reaches after you go get somecoffee is 6.880 V.
(a) Use Excel to construct a spreadsheet that shows
(i) the above data as well as any and all calculations needed tocompute the resistance of the circuit component in question;
(ii) create a graph of -ln[(Vfinal-V)/Vfinal] vs. the time;
(iii) use Excel's trendline to plot a best-fit line through thedata and determine the slope from it.
(b) What is the slope of your graph?
Slope =
Time Constant (RC) =
