I have developed ZnO thin film on glass substrate. I have measured Transmittance and absorbance from UV vissible spectrometer and attached the curve with excel data sheet here. Now I want to calculate refractive index and extinction coefficient and also draw refractive index vs wavelength and extinction coefficient vs wavelength curve from the transmittance or absorbance date. Please help me.