Question

how should i graph this? i have a macbook with excel and the directions my professor sent dont make sense

Problems 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 repest repeat repent repea repeat intensity 1 Lux 2 2 4 20 25 500 1000 2000 3500 5000 12 18 14 14 50 58 38 28 36 42 45 65 36 72 54

Answer 1

Q1. The mean, Standard deviation along with 95% confidence interval is given below in the table obtained from excel. The formula used to estimate the said statistics for each repetition are given below.

Mean formula is

$\bar{x}=\sum_{i=1}^{n} \frac{x_{i}}{n}$

Standard deviation formula is

$S=\sqrt{\frac{\sum_{i=1}^{n}( x_{i}-\bar{x})^{2}}{n-1}}$

and 95% Confidence interval are estimated using the following formula

ta S Vn
; where $t_{\frac{\alpha }{2}}$ = 2.571 is the critical value at 0.05 significance level with 5 df. n is sample size.

Intensity	Light
	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
Mean	29.33	24.17	27	24.33	22.33
Standard Deviation	24.78	20.28	26.14	23.54	15.21
Lower 95% C.I	3.32	2.88	-0.44	-0.38	6.37
Upper 95% C.I	55.34	45.46	54.44	49.04	38.29

The Line plot along with Standard deviation is given below.

Line plot along with Error Bar with Standard Deviation 31 29 27 25 23 21 19 TH 15 4 Repetition