INTRODUCTORY BIOLOGY
(BS 130)
CASE STUDY 3                                          Name_________________

 

Here are the results of an investigation into the rate of photosynthesis in the pond weed Elodea. The number of bubbles given off in one minute was counted under different light intensities, and each measurement was repeated 5 times. Use Excel to calculate the means and 95% confidence limits of these results, then plot a graph of the mean results with error bars and a line of best fit.

light intensity

(Lux)

repeat 1

repeat 2

repeat 3

Repeat 4

repeat 5

0

5

2

0

2

1

500

12

4

5

8

7

1000

7

20

18

14

24

2000

42

25

31

14

38

3500

45

40

36

50

28

5000

65

54

72

58

36