Some help on Excel please people :)

erm... not quite, i think im doing it wrong.

Basically the calculation is to do with the electromagnetic spectrum.

Its 0.5 x 10 to the power of 6

With the above value you must then divide by 299792458
 
i have the HC calculation to do to work out photon energy.

(6.626 x 10^-34)(2.998 x 10^8) = 19.86 x 10^-26 plancks constant x speed of light.

But it all needs to be calculated in excel.

Because what i need to do is divide this number by the wavelength.

1. 1000
2. 0.01
3. 0.00001
4. 0.5 x 10-6
5. 0.00000001
6. 1E-10
7. 1E-12

Each one of them.

EDIT: Worked them out.

Does this look right:

1. 1.98644521 × 10^-28
2. 1.98644521 × 10^-23
3. 1.98644521 × 10^-20
4. 3.97289042 × 10^-31
5. 1.98644521 × 10^-17
6. 1.98644521 × 10^-15
7. 1E-12 = 1.98644521 × 10^-13
 
Last edited:
Region
Radio/TV Waves
Microwaves
Infrared
Visible
UltraViolet
X-Ray
Gamma Ray


Wavelength
10^3 = 1000
10^-2 = 0.01
10^-5 = 0.00001
0.5 x 10^-6
10^-8 = 0.00000001
1E-10
1E-12


Frequency (299792458 / Wavelength)
299792.458
29979245800
2.99792E+13
599.584916
2.99792E+16
2.99792E+18
2.99792E+20


Photon Energy (1.98644521 × 10^-25 / Wavelength)
1.98645E-28
1.98645E-23
1.98645E-20
3.97289E-31
1.98645E-17
1.98645E-15
1.98645E-13
 
You must log in or register to reply here.
Back
Top Bottom