where d is the distance in parsecs to have Excel calculate M for you.
2. Use interpolation from the following table to estimate the spectral type of each star. Enter type in column Spectral Type. (If you don't know what interpolation means, look it up!)
Spectral Type Temperature (K)
3. Use Excel to make an H-R Diagram. Or feel free to use some other computer software to make your plot.
4. Classify each star as main sequence (M), giant (G), or white dwarf (W) and enter that number in the column.
5. Use the fact that the Sun has an absolute magnitude of 4.5 and scaling from the Stefan-Boltzmann Law to calculate the radius of each star in Solar Radii.