Class: Statistics

gonzalez_u1_app_assign.doc.xlsx

Sheet1

Bag	Red	Blue	Total	1. Overall total is 169; total for each bag can be found in column D
1	3	5	8	2. Average red: 2.87; Average blue: 2.77
2	7	3	10	3. Average total: 5.63
3	1	1	2
4	2	7	9
5	0	5	5
6	0	2	2
7	4	3	7
8	3	2	5
9	1	4	5
10	5	4	9
11	2	2	4
12	2	2	4
13	2	3	5
14	3	1	4
15	2	2	4
16	3	5	8
17	5	1	6
18	4	4	8
19	3	0	3
20	3	3	6
21	5	0	5
22	3	3	6
23	1	2	3
24	4	4	8
25	2	2	4
26	1	2	3
27	3	5	8
28	4	1	5
29	3	4	7
30	5	1	6
TOTAL	86	83	169
Average	2.8666666667	2.7666666667	5.6333333333