How to calculate the Band gap energy from UV Vis Absorbance data of a material | nanoparticles.

In this video I will show you that how can you calculate the band gap energy from UV-Vis absorbance data of your sample.
For this you will have to put the Wavelength and absorbance data of your sample in the respective columns and the your will have to put the following formulae in the columns in that order which I have given as a screenshot in the end of this video or given here.
Wavelength Absorbance Absorption coefficient Energy (αhv)2 (αhv)1/2
nm a.u. cm\+(-1) eV (eVcm\+(-1))\+(2) (eVcm\+(-1))\+(1/2)
λ A α E
2.302*B 1240/A (C*D)^2 (C*D)^(1/2)