Math assignment

profilemongoose
mat_144_worksheet_new.xlsx

Data

Before wells were dug After wells were dug
Enter a number between 1 and 100 in the box below Random numbers E. coli per milliliter in drinking water
Windows User: these need to be between 0 and 150 and the unit is millions of bacteria per mlliliter
E. coli per milliliter in drinking water
Windows User: these need to be between 0 and 150 and the unit is millions of bacteria per mlliliter
Original Before Data Original After Data
23 Before After
1 63 52 24 55 37 78 67 min = xxxxxx min = xxxxx
2 4 0 47 48 24 19 4 max = xxxxxx max = xxxxx
3 17 8 70 59 38 32 23 mean= xxxxxx mean= xxxxx
4 110 95 93 64 43 125 110 SD = SD =
5 38 26 16 34 13 53 41 0 count = 0 count =
6 53 27 39 61 45 68 42
7 0 0 62 58 50 4 10
8 91 64 85 63 38 106 79
9 23 0 8 91 64 38 6
10 21 1 31 69 39 36 16
11 0 0 54 53 32 4 14
12 2 0 77 57 40 17 5
13 28 0 100 62 40 43 9
14 8 0 23 65 45 23 3
15 17 0 46 61 43 32 8
16 34 13 69 71 50 49 28
17 21 3 92 58 38 36 18
18 0 6 15 17 0 2 21
19 18 7 38 48 24 33 22
20 43 10 61 57 33 58 25
21 60 44 84 69 42 75 59
22 67 48 7 0 0 82 63
23 65 45 30 55 38 80 60
24 55 37 53 61 34 70 52
25 64 35 76 61 49 79 50
26 58 51 99 70 48 73 66
27 61 39 22 67 48 76 54
28 57 27 45 60 42 72 42
29 57 40 68 49 18 72 55
30 55 38 91 59 37 70 53
31 69 39 14 8 0 84 54
32 66 47 37 59 30 81 62
33 54 44 60 70 52 69 59
34 70 37 83 58 30 85 52
35 85 54 6 53 27 100 69
36 55 42 29 57 40 70 57
37 59 30 52 63 44 74 45
38 48 24 75 53 39 63 39
39 61 45 98 58 43 76 60
40 63 60 21 60 44 78 75
41 72 49 44 56 41 87 64
42 56 26 67 64 40 71 41
43 68 52 90 50 33 83 67
44 56 41 13 28 0 71 56
45 60 42 36 55 42 75 57
46 61 43 59 71 43 76 58
47 48 24 82 63 44 63 39
48 55 23 5 38 26 70 38
49 50 35 19 18 7 65 50
50 68 44 42 56 26 83 59
51 61 33 65 49 10 76 48
52 63 44 88 68 46 78 59
53 61 34 11 0 0 76 49
54 53 32 34 70 37 68 47
55 62 36 57 52 38 77 51
56 60 43 80 71 47 75 58
57 52 38 3 17 8 67 53
58 59 30 26 58 51 74 45
59 71 43 49 50 35 86 58
60 70 52 72 66 40 85 67
61 57 33 95 64 42 72 48
62 58 50 18 0 6 73 65
63 44 28 41 72 49 59 43
64 57 40 64 57 40 72 55
65 49 10 87 73 53 64 25
66 52 33 10 21 1 67 48
67 64 40 33 54 44 79 55
68 49 18 56 60 43 64 33
69 71 50 79 71 62 86 65
70 59 38 2 4 0 74 53
71 68 46 25 64 35 83 61
72 66 40 48 55 23 81 55
73 55 32 71 68 46 70 47
74 56 39 94 72 44 71 54
75 53 39 17 21 3 68 54
76 61 49 40 63 60 76 64
77 57 40 63 44 28 72 55
78 56 40 86 62 42 71 55
79 71 62 9 23 0 86 77
80 71 47 32 66 47 86 62
81 73 52 55 62 36 88 67
82 63 44 78 56 40 78 59
83 58 30 1 63 52 73 45
84 69 42 24 55 37 84 57
85 63 38 47 48 24 78 53
86 62 42 70 59 38 77 57
87 73 53 93 64 43 88 68
88 68 46 16 34 13 83 61
89 55 17 39 61 45 70 32
90 50 33 62 58 50 65 48
91 59 37 85 63 38 74 52
92 58 38 8 91 64 73 53
93 64 43 31 69 39 79 58
94 72 44 54 53 32 87 59
95 64 42 77 57 40 79 57
96 62 40 100 62 40 77 55
97 51 37 14 8 0 66 52
98 58 43 37 59 30 73 58
99 70 48 60 70 52 85 63
100 62 40 83 58 30 77 55