Use the data to create a graph in Excel. It should be a scatter plot with a line connecting each point. Looking at the graph:a/ Which wavelengths absorbed most by spinach and likely used for photosynthesis? b/ Which wavelengths are absorbed least? **Bio 1081 Lab****Photosynthesis Lab – Results of Experiment 2: Making Absorption Spectra Using Spectrophotometry**### % Transmittance| Wavelength (nm) | Beta-carotene | Xanthophyll | Chlorophyll a | Chlorophyll b | Total Pigment ||-----------------|---------------|-------------|---------------|---------------|---------------|| 400 | 89.5 | 65.9 | 33 | 49.2 | 10.1 || 420 | 84.5 | 67.4 | 23 | 34.7 | 7.7 || 440 | 80 | 72.9 | 27.6 | 31.9 | 6.3 || 460 | 78.3 | 80.5 | 39.3 | 34.7 | 7.9 || 480 | 80 | 82.8 | 80.5 | 74.3 | 25.1 || 500 | 92.7 | 86.8 | 90.3 | 91.6 | 39.4 || 520 | 96.7 | 97.4 | 90.1 | 91.8 | 56.4 || 540 | 98.7 | 97.1 | 88.9 | 90.5 | 57.5 || 560 | 98.5 | 95.2 | 88.2 | 87.6 | 53.9 || 580 | 98.2 | 97 | 87.6 | 88.2 | 54.3 || 600 | 98.9 | 97.6 | 81.1 | 81.5 | 57.9 || 620 | 98.2 | 97.4 | 86.6 | 83.4 | 52.7 || 640 | 98.9 | 97.

During propagation, light behaves as a wave and as it interacts with any matter it behaves as a stream of discrete packets of energy known as photons. The amount of energy stored in the photons is referred to as quantum. The photosynthetic pigments are responsible for the absorption of this energy. Also, the amount of energy is dependent on the wavelength of light. The longer the wavelength lesser will be the amount of energy and vice versa.The visible light spectrum ranges from 390 nm to 760nm. This portion of the electromagnetic spectrum is often referred to as PAR (photosynthetically active radiation). The maximum absorption by the photosynthetic pigments of the sunlight occurs in the red (760 nm) and blue (390 nm) region. Very little absorption takes place in the yellow and orange region as well but the green light is completely reflected back (transmitted) and hence the leaves appear green in color. It is because the complementary colors are diametrically opposite to each other. (a) In the given data, transmittance % and wavelength are given. Transmittance is referred to as the wavelength of the light that passes through the sample and is not absorbed or used in photosynthesis. in the graph, we can observe the downward peaks in the red and blue regions which show that the minimum amount is transmitted in these regions. Thus, we can conclude that the highest rate of photosynthesis is achieved in the red and blue regions of the spectrum. Where in the red region it is even more than that of the blue region. (b) The wavelength that is absorbed the least is the one that shows most transmission. Here, the green light is completely transmitted because the green part of the light spectrum is not absorbed by the pigments.