00:01
So, given in the question, the current voltage characteristic curve for a semiconductor diode as a function of temperature t is given as i that is equal to i naught times e to the power e delta v by kvt minus 1, where the first symbol e represents the euler's number, the base of natural logarithms.
00:43
The second symbol, the second symbol e is the magnitude of electric charge that is 1e is equal to 1 .6 into 10 to the power minus 19 coulombs.
01:07
Kv is the boltzmann constant and it is 1 .38 into 10 to the power minus 23 joules per kelvin.
01:15
Capital t is the absolute temperature.
01:21
It has been asked to generate a spreadsheet.
01:30
I naught is given to be 1 .00 nano amperes.
01:34
Now it has been asked to generate a spreadsheet i to calculate i and r that is equal to the resistance r that is equal to delta v by i.
01:48
For delta v ranging between 0 .400 volts to 0 .600 volts in increments of 0 .005 volts.
02:02
And in part b, it has been asked to plot the resistance versus the potential difference delta v for the three temperatures t equal to 280 kelvin, 300 kelvin and 320 kelvin.
02:18
Now we can take help of any data processing software, for example, microsoft excel, microcal origin or any other data processing software to generate the spreadsheet.
02:42
Out of the various possible steps, one such steps to generate data for the above function using microsoft excel is as follows.
02:57
First, generate data of delta v within the range 0 .400 within the range 0 .400 volts to 0 .600 volts at an interval of 0 .005 volts in the first column...