Semiconductor diode (graph quesiton)

[darksyesider]

Homework Statement

The current-voltage characteristic curve of a semiconductor diode as a function of temperature T is given by the equation: ##I = I_0(e^{|e|\Delta V / k_BT}-1)##
where e is the base of the natural logarithm.
|e| is the charge of an electron
k_B is the boltzmann's constant
and T is the absolute temperature.

Set up a spreadsheet to calculate I and R = ΔV/I for V = 0.400V to 0.600V at 0.005 V increments. Assume I_0 = 1.00nA. Scatterplot R versus ΔV for T = 280K, 300K, 320 K. Plot the temperatures.

Homework Equations

see above

The Attempt at a Solution

I don't get how you can set up a spreadsheet to calculate I….aren't we missing the value of T?
And if "T" is suppose to be the absolute temperature, wouldn't it be 0 K making the fraction undefined?

 

[berkeman]

Homework Statement

The current-voltage characteristic curve of a semiconductor diode as a function of temperature T is given by the equation: ##I = I_0(e^{|e|\Delta V / k_BT}-1)##
where e is the base of the natural logarithm.
|e| is the charge of an electron
k_B is the boltzmann's constant
and T is the absolute temperature.

Set up a spreadsheet to calculate I and R = ΔV/I for V = 0.400V to 0.600V at 0.005 V increments. Assume I_0 = 1.00nA. Scatterplot R versus ΔV for T = 280K, 300K, 320 K. Plot the temperatures.

Homework Equations

see above

The Attempt at a Solution

I don't get how you can set up a spreadsheet to calculate I….aren't we missing the value of T?
And if "T" is suppose to be the absolute temperature, wouldn't it be 0 K making the fraction undefined?

It looks like they want results for the 3 temperatures given. Maybe make the first column the voltage, then calculate I in 3 more columns, one for each temperature.

I don't get the bolded part of the question, though. Is that copied exactly from your assignment?