Statistics of Optical absorption and electron energy loss spectra of carbon and boron nitride nanotubes: a first-principles approach