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