- #1

- 7

- 0

I want to plot a graph of the right hand side of the equation VS the energy, E, in eV for a periodic array of square wells each of depth 300eV, width 0.05nm, and period 0.1nm using SI units and

**MICROSOFT EXCEL**spreadsheet to determine the allowed energy bands and band gaps:

cos(kp)=F=cos(α(p-w))cosh(βw)+((β squared - α squared)/2αβ))sin(α(p-w))sinh(βw)

α = (1/h bar)* square root(2mE)

β = (1/h bar)* square root(2m(V-E))

w = width of barrier separating two adjacent potential wells

p = period

m = mass of an electron

V = well depth

Solutions are only obtained if F is between -1 and 1.

I have no idea how to do this so any help would be much appreciated.

Thanks in advance.