Experiment 1 1) Which color of light do you predict will produce the most gas? 2

Question

Experiment 1 1) Which color of light do you predict will produce the most gas? 2) Which color of light do you predict will produce the least gas? Table 2: Class reduced data: Volume of in each test tube (mm.n- SE SE Red White Gireen What kind of gas was collected in the test tubes? 4) Based on the data in table 2, do photosynthetic organisms tend to use colors of light that are similar to, or different than, their own color? 5) Briefly explain why this is the case Experiment 2: Table 3: Chromatography Data. Depending on the plants used, you may see two bands with the same to record data for any such bands that a leaves color: use the blank lines Green leaves Re Values (eqmation 3) Distance moved (mm) R, Values (eqwation 3) Pigment color moved (mm) Red Yellow (closest band) Yellow (distant band 6) Based on the data in table 3 and the information in table 1 a) What color is Anthocyanin? b) What color is Chlorophyll A? c) What color is Chlorophyll B? d) What color is Xanthophyll? Share the Re values for the green pigments from the two plants measured on the board 7) The four pigments identified above are not the only pigments found in plants. Based on the classroom data, fill in table 4 below: based on this data, is the Yellow pigment in the two plants the same or different? from Class data). n- CL Table 4: Reduced data table for R,values of yellow s in the two Means 2 SE UCI. Green Leaves Assignment: Provide tables 2-4 with the data collected in class and answer questions 1-7 based on this data

Explanation / Answer

Here, I get right to your Excel Sheet, I think that way things can be better explained

Here mean is the average of the 3 values for a particular light. Eg for white light, means = (11+5+29.5)/3 = 15.2. Here you should use the in-built AVERAGE function in Excel.

s is the standard deviation, which is s = Sq root[{Summation(Xi -Xavg)2}/(n-1)]

In you white light case Xi are X1 = 11, X2 = 5, X3 = 29.5, and Xavg = 15.2 (from mean value), and n=3. Now by by putting the the values we get,

s = Sq root[{ (11-15.2)2+(5-15.2)2+(29.5-15.2)2}/(n-1)] = 12.8. Well good news is you don't have to to all these calculations just use in built function for standard deviation which is STDEV.

Now, se is the standard error which is calculated after calculating the mean and standard deviation.

se = s/sr root(n). For example in case of white light se = 12.8/sq root(3) = 7.4, simply use Excel to calculate it.

Now, I'm sure you know how to calculate 2*se. For white light it is 2*7.4 = 14.7

Now, LCL is actually 95% LCL i.e. lower confidence limit which is calculated as LCL = Xavg - 2*se. For example in case of white light LCL = 15.2 - 14.7 = 0.4.

UCL is upper confidence level and is given by UCL = Xavg + 2*se. In case of white light it is, UCL = 15.2+14.7 = 29.9.

Below you can find my calculations in Excel.

White Light Red Light Green Light 1 11 9 6 2 5 4 1 3 29.5 13 0 Mean 15.2 8.7 2.3 s 12.8 4.5 3.2 se 7.4 2.6 1.9 2*se 14.7 5.2 3.7 LCL 0.4 3.5 -1.4 UCL 29.9 13.9 6.0

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.