Calculate Color Temperature from Spectrum

Cancelled

Job Description

In your response please tell me how much energy a single blue photon carries. Show your work.

Looking for someone with a physics / optics background that can assist with a simple analysis.

Given a spectrum of visible light broken down into relative intensities for 5nm bands, calculate the "Color temperature" of the light.

Job is to create or find an Excel spreadsheet that will accurately calculate the color temperature.