Take a look at these data and the tasks that accompany them. If you think you'd like some training on spreadsheets and graphing, check out this link to the computing services training schedule

Data set #1

Peanut M&Ms:
Number of each color found in a bag

Yellow

Blue

Brown

Green

Red

Orange

1

7

5

4

5

2

6

4

4

4

3

1

10

2

4

2

2

2

6

6

3

1

3

2

6

4

8

1

2

1

4

2

3

3

4

3

2

4

2

5

3

4

3

4

4

2

7

2

3

4

3

3

5

4

3

5

3

3

6

4

6

9

2

3

2

1

6

4

2

1

6

2

3

3

2

6

5

3

5

3

4

4

6

1

3

4

1

2

7

4

6

6

1

3

6

3

2

5

5

2

7

1

4

2

6

2

5

3

5

4

6

2

5

0

6

2

8

2

2

1

3

6

3

3

5

3

2

4

2

2

8

3

8

3

1

5

3

1

5

7

1

3

6

2

6

3

2

3

7

4

2

4

6

3

4

3

1

2

12

4

4

0

3

5

5

1

3

2

5

3

2

3

4

3

4

4

2

3

3

3

4

3

10

2

2

1

1

6

1

1

5

6

2

8

2

4

2

5

4

6

2

2

3

3

6

8

2

1

2

2

1

9

1

1

6

3

5

4

7

4

3

0

What is the mean number of M&Ms per bag? What is the standard deviation about that mean?

What is the mean number of each color per bag? What are the standard deviations about those means?

What is the mean percent of each color per bag?

Draw a frequency histogram of the different numbers of M&Ms per bag.

Data set # 2

Transparency, total algal biovolume,
and % of phytoplankton biovolume composed of blue-green algae in Squaw Lake
over a period of 91 days, during the summer

Julian day

SD transparency
(m)

total biovolume
(ml/ml)

%bga

133

1.60

16658

22%

137

1.25

37063

30%

140

1.30

19778

8%

147

1.50

22255

5%

152

1.95

4012

10%

154

1.88

14380

0%

158

2.20

2030

0%

161

2.50

7684

0%

166

2.15

5948

13%

173

1.80

20899

57%

179

1.00

67597

76%

186

1.20

36955

82%

200

0.80

36530

84%

216

0.65

39772

78%

224

0.35

89070

84%

Is there a correlation (positive or negative) between transparency and algal biovolume?

Is biovolume correlated with % blue-greens?

Plot graphs to answer each of these questions.

Data set #3

Acridine-orange counts of bacterial abundance (in bacteria/ml) in a set of 6 microcosms.
Three were held at a high pH (around 10), and 3 at a low pH (7)

date

high 1

high 2

high 3

low 1

low 2

low 3

17-Oct

3.57E+05

4.23E+05

2.32E+05

1.09E+06

8.21E+05

7.74E+05

20-Oct

3.75E+05

7.31E+05

5.16E+05

1.01E+06

1.10E+06

1.28E+06

22-Oct

7.66E+05

5.91E+05

7.49E+05

1.15E+06

9.97E+05

9.41E+05

24-Oct

8.37E+05

6.55E+05

5.15E+05

1.12E+06

9.47E+05

8.68E+05

27-Oct

4.97E+05

3.76E+05

5.66E+05

1.47E+06

1.12E+06

1.14E+06

31-Oct

6.77E+05

3.12E+05

3.13E+05

1.30E+06

1.27E+06

5.63E+05

Compare the mean bacterial densities for the high pH microcosms vs. the low pH microcosms for each day. Which is higher? Is the difference statistically significant?

Draw a graph that illustrates what's going on here.