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?

Human Anatomy & Physiology (11th Edition)
11th Edition
ISBN:9780134580999
Author:Elaine N. Marieb, Katja N. Hoehn
Publisher:Elaine N. Marieb, Katja N. Hoehn
Chapter1: The Human Body: An Orientation
Section: Chapter Questions
Problem 1RQ: The correct sequence of levels forming the structural hierarchy is A. (a) organ, organ system,...
icon
Related questions
Question
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.3
72.9
80.5
440
80
27.6
31.9
6.3
460
78.3
71.9
27.2
13.4
480
500
80.2
82.8
80.5
74.3
25.1
89.7
94.1
89.9
91.8
48.6
520
96.7
97.4
90.1
91.5
56.4
540
98.1
97.7
89.3
88.9
57.5
560
98
95.2
88.2
87.6
59.3
580
98.2
97.4
81.2
83.6
56.3
600
98
97.6
81.1
81.5
57.9
620
97.9
95.3
74.1
80.1
54.7
640
97.4
97.6
77.6
61.5
52.6
97.2
97.4
97.4
97.3
660
95.7
28.8
48.1
24.2
680
98.2
78.4
89.8
60.7
96.2
97.7
700
99
97.8
78,1
720
99.1
98.2
80
Transcribed Image Text: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.3 72.9 80.5 440 80 27.6 31.9 6.3 460 78.3 71.9 27.2 13.4 480 500 80.2 82.8 80.5 74.3 25.1 89.7 94.1 89.9 91.8 48.6 520 96.7 97.4 90.1 91.5 56.4 540 98.1 97.7 89.3 88.9 57.5 560 98 95.2 88.2 87.6 59.3 580 98.2 97.4 81.2 83.6 56.3 600 98 97.6 81.1 81.5 57.9 620 97.9 95.3 74.1 80.1 54.7 640 97.4 97.6 77.6 61.5 52.6 97.2 97.4 97.4 97.3 660 95.7 28.8 48.1 24.2 680 98.2 78.4 89.8 60.7 96.2 97.7 700 99 97.8 78,1 720 99.1 98.2 80
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Photosynthesis & Respiration
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, biology and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Human Anatomy & Physiology (11th Edition)
Human Anatomy & Physiology (11th Edition)
Biology
ISBN:
9780134580999
Author:
Elaine N. Marieb, Katja N. Hoehn
Publisher:
PEARSON
Biology 2e
Biology 2e
Biology
ISBN:
9781947172517
Author:
Matthew Douglas, Jung Choi, Mary Ann Clark
Publisher:
OpenStax
Anatomy & Physiology
Anatomy & Physiology
Biology
ISBN:
9781259398629
Author:
McKinley, Michael P., O'loughlin, Valerie Dean, Bidle, Theresa Stouter
Publisher:
Mcgraw Hill Education,
Molecular Biology of the Cell (Sixth Edition)
Molecular Biology of the Cell (Sixth Edition)
Biology
ISBN:
9780815344322
Author:
Bruce Alberts, Alexander D. Johnson, Julian Lewis, David Morgan, Martin Raff, Keith Roberts, Peter Walter
Publisher:
W. W. Norton & Company
Laboratory Manual For Human Anatomy & Physiology
Laboratory Manual For Human Anatomy & Physiology
Biology
ISBN:
9781260159363
Author:
Martin, Terry R., Prentice-craver, Cynthia
Publisher:
McGraw-Hill Publishing Co.
Inquiry Into Life (16th Edition)
Inquiry Into Life (16th Edition)
Biology
ISBN:
9781260231700
Author:
Sylvia S. Mader, Michael Windelspecht
Publisher:
McGraw Hill Education