Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

create a new variable 'cane output per acre' in a new column. (Cane output per acre = cane output / cultivated area). a. Calculate the

create a new variable 'cane output per acre' in a new column. (Cane output per acre = cane output / cultivated area).

a. Calculate the descriptive statistics using MS-Excel for 'Cane output per acre' for farmers who attend and for farmers who do not attend the extension program. (Hint: ignore non-numeric cells in computing). Interpret the following statistic (Mean, Median, Mode, Standard Deviation) obtained for farmers who attend the program.

b. What conclusion can be reach from the comparison of descriptive statistics between 'Cane output per acre' for farmers who attend and for farmers who do not attend the extension program? Justify why or why note there is significant difference in output?

c. Draw a boxplot for the variable 'Education (years)' and use it to analyze the data.

Cane output Cultivated Farming Annual profit from Land Class No. of Children Attend
Farmer No. (tons) area (acres) status farming ($) owned of land Age Education (years) children help program
1 290 11 Full-time 1500 No 1 57 4 0 No No
2 120 10 Full-time 1800 No 2 42 10 2 Yes No
3 60 3 Full-time 600 No 1 58 6 0 No No
4 442 14 Full-time 2000 No 1 69 7 8 No No
5 150 10 Full-time 2000 No 1 44 10 4 Yes No
6 415 28 Full-time 10000 No 2 69 11 0 No No
7 248 15 Full-time 2000 No 1 61 8 4 No No Class of land: 1 = 1st class land (best)
8 130 5 Full-time 2000 No 1 39 10 3 No No 4 = 4th class land (worst)
9 200 10 Full-time 0 No 2 68 7 2 Yes NA Attend program: Did the farmer attend an extension program in the past 2 years?
10 400 30 Full-time 3000 No 2 52 7 2 No Yes
11 150 8 Full-time 400 Yes 1.5 60 8 0 No No
12 169 13 Full-time 2000 No 3 47 8 2 Yes No
13 130 6 Full-time 2000 No 1 39 10 3 No No
14 135 6 Full-time 2000 No 1 76 0 10 Yes No
15 70 5 Full-time 500 No 3 32 9 3 No No
16 202 9 Full-time 3000 No 2 58 8 2 No No
17 230 15 Part-time 3000 No 3 38 12 0 No No
18 133 8 Full-time 2000 No 3 49 11 2 No No
19 334 18 Full-time 5000 No 3 37 8 0 No No
20 30 3 Part-time 500 No 3 42 2 2 No No
21 176 8 Full-time 3500 No 2 52 7 2 Yes No
22 388 14 Full-time 5000 No 2 72 3 0 No No
23 91 6 Full-time 1500 No 2 74 5 1 Yes No
24 400 18 Part-time 8000 No 2 55 16 1 Yes No
25 164 7 NA 3200 No 2 61 6 0 No No
26 180 7 Part-time 4000 No 2 45 10 2 No No
27 256 13 Full-time 5000 No 1 55 13 8 Yes No
28 160 7 Part-time 2000 No 2 45 8 3 Yes No
29 424 13 Part-time 5000 No 2 63 8 1 Yes No
30 179 8 Full-time 2500 No 2 65 8 2 Yes No
31 174 8 Full-time 2500 No 2 78 3 1 Yes No
32 234 8 Part-time 3000 No 2 46 8 1 No No
33 70 5 Full-time 1000 No 2 64 6 1 Yes No
34 141 10 Full-time 2000 No 2 55 6 1 Yes No
35 155 8 Full-time 2000 No 2 82 1 0 No No
36 277 10 Full-time 4000 No 2 43 11 3 No No
37 342 15 Full-time 5000 No 3 43 6 3 Yes No
38 195 15 Full-time 4000 No 2 44 7 3 Yes No
39 235 13 Full-time 4500 No 3 42 10 4 No No
40 30 2 Full-time 500 No 3 39 10 0 No No
41 151 10 Full-time 3000 No 2 72 5 2 Yes No
42 51 4 Part-time 600 No 2 35 11 2 Yes No
43 126 8 Part-time 2500 No 3 60 14 4 Yes No
44 107 7 Part-time 2000 No 3 29 14 0 No No
45 184 8 Full-time 3600 No 3 38 13 1 No No
46 220 10 Full-time 4000 No 3 43 13 1 Yes No
47 80 10 Part-time 1500 No 3 43 4 4 No No
48 125 7 Full-time 2000 No 3 27 11 0 No No
49 123 7 Full-time 1500 No 2 65 5 0 No No
50 27 1 Full-time 400 No 3 55 8 3 Yes No
51 119 8 Full-time 1500 No 3 48 11 2 No No
52 218 12 Full-time 3000 No 3 59 8 0 No No
53 97 5 Full-time 1000 No 3 48 8 1 No No
54 214 8 Full-time 3000 No 3 46 8 0 No No
55 56 3 Part-time 800 No 3 49 8 3 No No
56 100 7 Full-time 1500 No 3 60 8 0 No No
57 109 7 Full-time 1500 No 3 55 8 2 Yes No
58 143 8 Full-time 2000 No 3 56 8 1 Yes No
59 84 5 Full-time 1000 No 3 64 8 4 Yes No
60 120 8 Full-time 1500 No 3 38 11 0 No No
61 15 2 Full-time 200 No 3 48 11 4 Yes No
62 97 6 Part-time 1000 No 3 54 11 2 No No
63 152 7 Full-time 2000 No 3 40 11 2 No No
64 44 2 Full-time 600 No 3 80 8 1 Yes No
65 111 7 Full-time 1500 No 3 35 11 3 No No
66 125 8 Part-time 1500 No 3 48 8 3 No No
67 90 5 Full-time 1000 No 3 53 11 4 No No
68 155 12 Part-time 2000 No 3 55 11 2 No No
69 220 12 Part-time 3000 No 3 50 11 3 Yes No
70 127 6 Part-time 1500 No 3 40 11 3 No No
71 234 18 Part-time 3000 No 3 58 8 1 Yes No
72 151 10 Full-time 2000 No 3 60 8 1 Yes No
73 45 3 Part-time 600 Yes 3 46 8 2 No No
74 20 2 Part-time 300 Yes 3 50 14 2 No No
75 32 4 Full-time 400 Yes 3 40 8 2 No No
76 62 3 Part-time 800 Yes 2 50 15 1 No No
77 65 3 Part-time 800 Yes 3 34 11 1 No No
78 36 4 Full-time 500 No 3 68 8 2 Yes No
79 50 3 Part-time 700 Yes 3 55 2 1 No No
80 71 4 Full-time 1000 Yes 3 55 2 1 No No
81 43 2 Full-time 500 Yes 3 55 2 1 No No
82 27 2 Part-time 400 Yes 3 50 14 2 No No
83 146 8 Part-time 2000 Yes 3 47 14 2 No No
84 84 6 Part-time 1000 Yes 3 44 10 5 No No
85 34 2 Part-time 500 No 3 55 5 3 No No
86 100 9 Full-time 1500 No 3 70 5 0 No No
87 63 5 Full-time 800 No 3 68 5 0 No No
88 80 9 Full-time 1200 No 3 70 5 1 Yes No
89 60 5 Full-time 500 Yes 2 40 11 0 No No
90 320 12 Full-time 5000 No 2 65 0 0 No No
91 38 6 Full-time 0 No 1 45 10 1 Yes No
92 300 13 Full-time 5000 No 3 41 10 2 Yes No
93 50 4 Full-time 100 No 3 46 9 2 Yes No
94 160 5 Full-time 1000 No 4 48 8 8 No No
95 200 7 Full-time 3000 No 3 73 5 1 Yes No
96 167 15 Full-time 2000 No 3 56 8 2 Yes No
97 100 10 Part-time 1500 No 3 53 10 4 No No
98 86 8 Part-time 1000 No 3 36 12 2 Yes No
99 56 9 Full-time 800 No 3 41 11 3 No No
100 295 15 Full-time 4000 No 3 36 11 3 No No
101 74 5 Full-time 1000 No 3 60 8 0 NA No
102 109 12 Part-time 1500 No 3 65 8 1 Yes No
103 119 10 Full-time 1500 No 3 56 8 0 No No
104 85 9 Part-time 1000 No 3 58 8 1 Yes No
105 150 6 Full-time 500 No 1 49 7 0 No No
106 100 16 Full-time 700 No 2 65 3 6 No NA
107 262 13 Full-time 3500 No 4 50 3 0 No No
108 234 13 Full-time 2000 No 2 53 8 0 No No
109 100 8 Full-time 800 No 3 47 10 3 Yes No
110 100 3 Full-time 4000 No 3 70 6 2 No No
111 30 1 Full-time 900 No 3 48 10 0 Yes No
112 170 8 Full-time 2500 Yes 3 65 7 0 No No
113 170 8 Full-time 2500 Yes 3 65 7 0 No No
114 20 2 Part-time 300 Yes 3 50 12 2 No No
115 20 2 Part-time 300 Yes 3 50 12 2 No No
116 180 9 Part-time 2500 Yes 2 65 6 1 Yes No
117 180 9 Part-time 2500 Yes 2 65 6 1 Yes No
118 185 10 Full-time 3500 Yes 2 78 3 6 No No
119 30 3 Full-time 400 Yes 3 80 2 1 Yes No
120 30 3 Full-time 400 Yes 3 80 2 1 Yes No
121 179 9 Full-time 3500 No 3 51 3 2 Yes No
122 263 25 Full-time 5000 No 3 65 5 2 Yes No
123 99 7 Part-time 1500 No 3 76 4 2 Yes No
124 122 10 Full-time 1500 Yes 3 34 11 1 No No
125 122 16 Full-time NA No 4 44 6 0 No No
126 149 7 Full-time 2000 No 2 70 5 1 Yes No
127 100 5 Full-time 250 No 2 63 8 1 Yes No
128 69 4 Full-time 1000 No 3 55 8 2 Yes No
129 215 15 Full-time 3000 No 3 70 8 3 Yes No
130 101 11 Full-time 1500 No 3 60 8 1 Yes No
131 150 10 Full-time 1500 No 3.5 37 8 1 Yes No
132 180 8 Full-time 1500 No 3 43 10 1 Yes No
133 250 15 Full-time 4000 No 3 50 8 4 No No
134 60 3 Full-time 900 No 3 90 4 1 Yes No
135 30 3 Part-time 450 No 3 35 12 1 Yes No
136 325 13 Full-time 2000 No 1 52 10 0 No No
137 400 13.5 Full-time 150 No 1 49 7 0 No No
138 350 12 Full-time 3000 No 1 40 12 4 Yes No
139 9 1 Full-time 0 No 2 66 3 4 Yes No
140 270 13 Full-time 700 No 2 45 8 5 Yes No
141 150 16 Full-time 1500 No 3 35 6 2 Yes No
142 395 26 Full-time 0 No 3 49 11 2 Yes No
143 28 2 Part-time NA Yes 3 35 15 0 No No
144 107 7 Full-time 1500 No 3 56 8 2 Yes No
145 137 12 Part-time 2000 No 3 35 11 3 Yes No
146 211 12 Full-time 3000 No 3 45 11 3 No No
147 64 5 Part-time 800 No 3 46 11 3 Yes No
148 62 7 Part-time 800 No 3 35 13 3 No No
149 11 1 Full-time 150 No 3 62 5 0 No No
150 380 12 Full-time 7000 No 2 50 7 1 Yes No
151 107 8 Full-time 2000 No 3 45 10 1 Yes No
152 128 8 Part-time 2000 No 3 52 11 0 No No
153 218 14 Full-time 1000 No 1 60 12 0 No No
154 226 9 Full-time 4000 No 3 50 7 1 No No
155 93 8 Full-time 1500 No 3 70 8 3 No No
156 30 5 Full-time NA No 3 30 10 2 Yes No
157 60 6 Part-time 900 No 2 50 7 2 No No
158 153 9 Full-time 2000 No 3 47 8 3 No No
159 250 12 Full-time 3000 No 3 80 2 1 Yes No
160 31 3 Full-time NA No 3 34 12 0 NA No
161 106 7 Full-time 1500 Yes 3 67 8 1 Yes No
162 142 8 Full-time 2000 No 3 74 7 0 NA No
163 41 3 Full-time 600 Yes 3 28 8 0 NA No
164 150 15 Full-time 1000 No 3 61 8 1 Yes No
165 10 5 Full-time 150 No 3 42 14 3 No No
166 238 11 Full-time 0 No 3 43 8 1 No No
167 280 10 Full-time 4000 No 3 48 8 2 No No
168 74 4 Full-time 700 No 2 52 10 2 Yes No
169 270 10 Full-time 3000 No 2 53 10 2 No No
170 599 25 Full-time 188 No 1 50 9 3 No No
171 315 13 Full-time 1500 No 1 49 8 0 NA No
172 106 7 Full-time 2500 Yes 1 40 8 2 No No
173 49 4 Full-time 100 Yes 1 46 8 1 Yes No
174 100 7 Full-time 150 No 2 57 8 0 NA No
175 132 8 Full-time 1500 No 3 43 11 4 No No
176 161 9 Full-time 1500 No 3 56 7 0 NA No
177 180 16 Full-time 3500 No 4 46 6 1 Yes No
178 184 9 Full-time 2000 No 3 56 7 0 NA No
179 240 8 Full-time 4000 No 2 69 9 0 NA No
180 53 4 Full-time 419 No 2 51 11 0 NA No
181 120 8 Part-time 0 No 1 40 7 1 Yes No
182 55 6 Part-time 0 No 2 32 10 3 No No
183 210 11 Full-time 0 No 2 59 6 0 NA No
184 290 16 Full-time 2900 No 2 37 12 2 No No
185 312 13 Full-time 3000 No 2 68 4 2 No No
186 43 3 Full-time 400 No 2 49 8 3 Yes No
187 180 10 Full-time 1800 Yes 3 62 6 0 NA No
188 45 4 Full-time 600 No 4 30 10 1 No No
189 380 16 Full-time 3800 No 2 42 8 4 No No
190 79 6 Full-time 1000 No 3 63 2 2 No No
191 183 8 Full-time NA No 3 52 12 3 Yes No
192 215 10 Full-time 4000 No 2 67 4 0 NA No
193 172 6 Full-time 4800 No 2 57 8 1 Yes No
194 104 7 Part-time 2500 No 2 60 5 4 Yes No
195 230 8 Full-time 4600 No 2 71 7 0 NA No
196 30 1 Part-time 600 No 2 45 16 0 No No
197 356 16 Full-time 7000 No 3 50 8 0 NA No
198 180 7 Full-time 1000 No 1 65 7 3 No No
199 200 8.5 Full-time 1500 No 1 82 4 0 NA Yes
200 80 9 Full-time 300 No 1 36 12 1 No No
201 337 12 Full-time 2000 No 1 48 7 4 Yes No
202 65 3 Full-time 0 No 1 48 5 5 Yes No
203 265 9 Full-time 0 No 1 55 1 0 NA No
204 200 5 Full-time 2000 No 1 49 8 4 Yes No
205 300 9.5 Part-time 2000 No 1 41 12 5 No No
206 230 10 Full-time 2000 No 1 41 12 0 NA No
207 290 14 Full-time 6800 No 2 58 8 5 No No
208 20 3 Part-time 0 Yes 1 35 11 0 NA No
209 30 2 Full-time 500 Yes 2 70 6 0 NA No
210 104 5 Full-time 1000 Yes 1 66 4 5 No No
211 100 6 NA 2700 Yes 2 70 8 0 NA No
212 103 6 Full-time 1957 Yes 2 70 6 0 NA No
213 150 7 Full-time 3000 No 2 65 8 5 No No
214 90 5 Full-time 0 No 1 62 8 1 No No
215 50 3 Full-time 1000 Yes 2 61 8 2 No No
216 200 10 Full-time 5000 Yes 2 64 9 0 NA No
217 180 10 Full-time 5000 No 2 48 6 0 NA No
218 8 3 Full-time 0 No 1 58 7 1 Yes No
219 8 1 Full-time 0 No 2 70 8 0 NA No
220 330 13 Full-time 7000 Yes 2 65 8 1 Yes No
221 300 10 Full-time 4000 No 1 68 6 1 Yes No
222 300 18 Part-time 0 Yes 3 47 8 5 No No
223 200 10 Full-time 4000 Yes 1 54 8 1 Yes No
224 153 9 Full-time 3000 No 3 71 5 2 Yes No
225 244 11 Full-time 3500 No 3 52 12 2 Yes No
226 219 9 Full-time 3000 No 3 38 11 2 No No
227 340 15 Full-time 6000 No 3 61 6 3 Yes No
228 35 5 NA 700 No 3 39 8 3 Yes No
229 142 7 Full-time 2000 No 2 53 8 2 Yes No
230 140 10 Full-time 2100 No 3 71 7 2 Yes No
231 170 11 Full-time 3000 No 2 57 4 2 Yes No
232 154 9 Full-time 3000 No 3 71 5 2 Yes No
233 156 9 Full-time 0 No 2 42 10 1 No No
234 61 3 Full-time 900 No 3 49 12 1 No No
235 87 10 Full-time 0 No 1 58 7 0 NA Yes
236 250 8 Full-time 100 No 1 46 11 1 No No
237 90 6 Part-time 0 No 1 49 6 1 Yes No
238 160 10 Full-time 0 Yes 1 34 8 2 Yes No
239 180 8 Full-time 100 No 1 42 6 7 Yes No
240 180 7 Part-time 1800 No 1 34 12 1 No No
241 248 10 Full-time 2300 No 2 64 6 4 Yes No
242 96 13 Full-time 0 No 3 37 10 1 Yes No
243 409 14 Full-time 6000 No 2 44 12 2 No No
244 53 6 Full-time 700 No 3 65 8 3 Yes No
245 200 8 Part-time 1300 No 2 41 16 1 No No
246 200 12 Full-time 3000 No 2 60 8 2 Yes No
247 150 15 Full-time 2000 No 2 80 1 1 Yes No
248 215 12 Full-time 3000 No 2 70 2 1 Yes No
249 303 12 Full-time 4000 No 2 73 2 1 Yes No
250 30 2 Full-time 450 Yes 3 55 8 0 NA No
251 210 8 Full-time 1500 No 2 42 12 2 No No
252 300 18 Full-time 6000 No 2 46 11 3 Yes No
253 130 10 Full-time 2000 No 2 50 8 NA Yes No
254 90 6 Full-time 500 No 2 30 8 0 NA No
255 156 8 Full-time 0 No 2 66 4 0 NA No
256 87 10 Full-time 2000 No 2 34 10 0 NA No
257 230 15 Full-time NA No 2 49 11 2 No No
258 134 10 Full-time 700 No 2 66 0 1 No No
259 72 8 Full-time 100 Yes 3 30 5 0 No No
260 100 6 Full-time 1500 Yes 3 43 12 3 No No
261 60 2 Full-time 500 No 1 63 12 9 Yes No
262 414 15 Full-time 1500 No 1 68 3 1 Yes No
263 119 7 Full-time NA No 3 44 11 2 Yes No
264 180 15 Part-time 1700 No 4 55 14 0 No No
265 230 12 Full-time 2500 Yes 1 40 11 2 Yes No
266 450 13 Full-time 5000 No 1 63 12 9 Yes No
267 20 2 Full-time 400 Yes 1 53 7 0 NA No
268 200 10 Full-time 2000 Yes 1 53 7 0 NA No
269 350 14 Full-time 2000 Yes 1 41 15 0 NA No
270 208 11 Full-time 6000 Yes 11 33 12 0 NA No
271 168 12 Full-time 0 Yes 2 48 10 1 Yes No
272 180 6 Full-time 6000 Yes 2 28 8 6 Yes Yes
273 116 6 Full-time 5000 Yes 2 60 0 4 Yes No
274 21 3 Full-time 300 No 4 45 12 0 NA No
275 7 1 Full-time 100 No 4 55 7 5 No No
276 32 5 Full-time 400 No 3 35 7 3 Yes No
277 172 12 Full-time 2500 Yes 3 54 12 2 No No
278 85 4 Full-time 1000 No 3 51 10 2 Yes No
279 91 4 Full-time 1000 No 3 42 11 2 Yes No
280 151 11 Full-time 2000 No 3 45 12 3 Yes No
281 173 9 Full-time 2500 No 3 44 11 3 Yes No
282 162 9 Full-time 2000 No 3 45 12 3 Yes No
283 153 10 Full-time 0 No 4 53 12 2 No No
284 70 12 Full-time 700 No 4 39 8 2 No No
285 80 70 Full-time NA No 4 50 15 2 No No
286 69 15 Full-time 1000 No 3 27 11 3 Yes No
287 47 3 Full-time 2000 No 1 39 6 2 Yes No
288 150 3 Full-time 3000 No 1 37 5 1 No No
289 47 5 Full-time 700 No 3 39 7 0 NA No
290 285 9 Full-time 6500 No 2 51 18 1 No No
291 73 3 Full-time NA No 3 63 4 0 NA No
292 378 15 Full-time 600 No 1 44 13 3 No No
293 264 12 Full-time 3500 No 3 42 12 2 No No
294 148 5 Full-time 200 No 3 46 12 3 No No
295 83 5 Full-time 1000 No 3 44 8 3 No No
296 340 12 Full-time 4000 No 2 48 4 1 Yes No
297 50 1.5 Full-time 800 No 1 36 8 1 No No
298 360 10 Full-time 0 No 1 54 15 0 NA No
299 180 7 Full-time 0 No 1 65 0 0 NA No
300 118 9 Full-time 6000 No 3 21 10 0 NA Yes
301 13 1 NA NA No 4 43 8 1 No NA
302 91 7 Full-time 1000 No 4 65 8 2 Yes No
303 150 15 Full-time 0 Yes 3 45 10 2 No No
304 170 8 Full-time 2500 No 3 48 7 2 Yes No
305 123 11 Full-time 1800 No 3 33 6 0 NA No
306 128 8 Part-time 1500 No 3 52 11 3 Yes No
307 200 12 Full-time NA No 2.5 45 11 3 Yes No
308 194 13 Full-time 2000 No 2 24 12 0 NA No

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

An Introduction to Measure Theoretic Probability

Authors: George G. Roussas

2nd edition

128000422, 978-0128000427

More Books

Students also viewed these Mathematics questions

Question

What is the role of learning in building brand awareness?

Answered: 1 week ago

Question

What have been misses?

Answered: 1 week ago

Question

What do you notice have been hits in terms of meeting your mission?

Answered: 1 week ago