Answer this question in two or more Excel Worksheets \textendash{} one Worksheet
containing the table and the other Worksheet containing all the plots. Alternatively, you may
choose to provide each plot in a separate Worksheet.
Demonstrate how the spectral emissive power inside a blackbody cavity changes with respect to the
following parameters:
a) Temperature and wavelength, hence, find $E_\lambda(\lambda, T)$, by:
(i) Creating a table with the $(\lambda, T)$ values as follows:
1. Wavelengths, $\lambda$, from 0.1 $\mu$m to 100 $\mu$m, on the first (left\textendash{}most) column. Use increments
of:
$\to$ 0.1 $\mu$m from 0.1 $\mu$m to 1.0 $\mu$m;
$\to$ 0.5 $\mu$m from 1.0 $\mu$m to 10 $\mu$m;
$\to$ 1.0 $\mu$m from 10 $\mu$m to 100 $\mu$m;
2. Temperatures, $T$, values of: 273.15 K; 773.15 K; 1273.15 K; 1773.15 K; 2273.15 K; 5000
K; and, 10000 K.
3. Calculate $E_\lambda(\lambda, T)$ using units of W/m$^2$ $\mu$m and assume the constants $C_1 = 374210000$
and $C_2 = 14388$.
Set up your table with each separate column corresponding to each given value of $T$.
Ensure that you clearly label each column in your table and include the relevant units.
[Hint: There should be seven separate columns in your table for the $E_\lambda(\lambda, T)$ calculations
and eight columns in your table altogether with the inclusion of the left\textendash{}most column
consisting of the $\lambda$ values.
The recommendation is that you fill in each separate column in your table using a
different background colour in order to facilitate the examination of the different $T$
calculations and to assist in identifying the corresponding plots.]
