Question: Use Microsoft Excel for the data below Investigate the following using the collected data: A. The confidence interval for Body Mass Index (BMI) of males

Use Microsoft Excel for the data below

Investigate the following using the collected data: A. The confidence interval for Body Mass Index (BMI) of males and females for the Malaysian population with confidence level of 95%. B. It has been claimed that the mean for BMI of females for the Malaysian population is less than normal. Test whether this claim can be accepted. C. It has been claimed that the mean for BMI of males for the Malaysian population is 24. Test whether this claim can be accepted. D. The linear regression model between age and height of Malaysians. E. Test whether there is a strong relationship between age and weight of Malaysians. No Age Weight (in kg) Height (in cm) Gender 1 24 F F 2 3 F 4 5 6 7 47 83 60 80 80 100 75 60 47 24 25 24 24 20 25 25 21 21 23 57 22 F F F 8 F F F 9 10 45 11 55 F F F 169 171 173 170 170 160 180 163 151 157 178 158 157 180 158 159 170 166 170 178 173 175 167 12 13 14 15 90 46 60 F 22 F F 48 | 16 F 20 19 21 22 25 22 30 17 18 19 20 21 22 23 F F F F F 47 60 52 69 61 75 95 67 85 59 73 61 70 F F F F 186 F F F F 70 23 23 24 30 24 21 19 19 21 26 29 22 22 22 18 24 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 F 170 180 170 165 165 155 177 163 155 150 173 55 75 65 41 40 55 56 43 43 68 47 F F F F F F 171 155 21 22 22 155 175 162 F F F F F 41 42 43 44 F 22 23 22 22 59 65 58 53 164 157 164 F F 45 F 46 47 48 F F F F 49 50 51 F 17 42 22 21 16 24 20 58 69 22 44 22 F 52 160 164 153 149 173 163 153 162 165 167 165 145 160 190 155 163 155 F F 22 22 53 54 55 56 57 58 59 60 61 62 63 64 65 21 22 22 22 22 22 42 75 45 63 40 50 50 58 63 70 78 55 84 42 57 42 40 80 64 52 54 56 51 95 62 55 80 88 56 90 90 67 F F F F F F F F F F F F 156 184 165 150 66 F 67 68 69 70 71 22 22 21 51 22 49 20 22 159 160 160 175 167 150 F F F F F 72 F 73 21 22 22 74 75 76 77 78 175 182 176 171 171 165 175 160 165 156 F F F F 72 F 24 21 21 23 26 50 F F 79 80 47 70 F 62 F 22 21 23 F F 170 157 165 151 153 172 F 81 82 83 84 85 86 87 88 89 90 F F 173 172 185 F F F 22 22 18 22 22 22 21 22 23 23 23 25 21 F 91 F F 92 93 F F F 94 95 96 97 41 58 42 45 59 68 184 120 73 57 38 55 66 86 68 42 63 64 82 68 47 70 90 67 66 78 55 60 69 F F 14 F 98 99 F F F 1 F 100 101 102 103 104 105 5 F 169 163 148 166 171 170 161 162 183 160 179 165 150 160 173 175 156 152 172 175 159 162 162 167 159 184 181 157 F F F 25 22 22 19 25 24 22 21 46 49 26 47 58 34 34 24 28 21 22 53 42 59 F F F F 3 68 106 107 108 109 110 111 112 113 114 115 116 117 F F 5 5 F F F F 7 68 89 40 63 82 56 65 57 56 3 2 F F 118 119 120 167 158 157 F 63 F 121 60 182 F F F F 122 123 124 125 126 127 21 32 22 19 17 27 14 22 20 21 70 50 53 63 77 54 54 57 F F F F 64 F F F F 128 129 130 131 132 133 134 135 136 137 138 F F 21 20 22 22 55 58 22 27 F 54 58 41 58 58 70 55 75 45 60 65 67 50 160 161 146 172 172 168 162 170 172 154 159 160 177 167 170 165 183 156 165 160 173 153 167 200 165 167 174 175 162 172 153 22 F F F F F F F F F 70 89 F 60 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 22 20 22 21 22 22 22 22 21 22 22 22 27 23 18 24 21 70 67 63 F F F F | | ||| 78 F 74 64 57 55 75 53 66 60 73 76 147 162 157 155 F F F F F F F F 22 171 167 158 158 23 39 19 159 160 F F 161 162 F 22 22 23 24 163 F F F 23 24 71 71 100 97 51 72 93 130 57 83 60 F F 22 28 F 164 165 166 167 168 169 170 171 172 173 174 175 176 F F 23 55 54 58 F F 155 155 181 174 163 148 168 170 161 180 150 170 170 166 176 178 175 175 165 160 175 169 169 174 F 70 71 54 62 55 44 46 F F 19 21 45 F F 45 F F F 15 26 26 22 M M 24 24 19 130 50 85 71 75 65 72 70 63 63 63 55 51 98 66 68 M M M 19 M 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 19 167 167 167 176 162 177 M M M M M M 27 20 22 21 21 22 20 22 21 24 21 57 75 46 84 80 77 178 171 162 170 157 182 184 174 169 173 M M M M M M M 22 23 58 75 M M 21 24 21 23 71 115 80 177 179 176 M M M 23 M 67 67 67 70 67 167 167 167 176 M 23 23 23 20 19 M M 71 70 M M 67 67 58 M M M 75 62 45 75 167 172 165 165 165 168 177 172 155 177 165 159 162 M M M M M M M 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 154 168 173 155 M M M M 21 21 22 26 21 33 26 26 22 22 22 20 20 21 21 25 22 22 25 24 24 20 24 23 19 21 22 22 M M 52 49 50 43 50 63 67 67 73 64 58 75 75 80 53 43 65 56 73 M M M M M M 155 175 169 170 178 186 176 163 161 157 165 169 169 177 156 170 M M 5 M M M 61 53 M M 22 52 39 62 M 241 M 27 55 M 242 243 244 160 168 170 173 M M 171 M 245 246 247 248 249 60 65 60 78 58 51 62 58 65 70 55 31 21 22 22 21 58 32 50 22 22 22 22 22 M M M M 250 M M 55 70 50 151 168 165 168 155 160 160 165 160 155 175 160 160 154 150 175 168 M M M M 42 75 M M M 21 22 21 22 22 22 22 23 21 23 20 24 22 M M M M 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 2741 275 276 45 51 57 52 69 74 92 92 83 49 94 54 M 167 168 175 M M 160 180 160 M M M M 22 22 M 162 156 160 163 M 56 72 58 72 65 67 52 17 24 51 M M M M 160 174 158 168 24 21 23 21 70 M M 160 171 21 M M 277 278 279 280 50 68 85 50 22 24 175 163 M M 24 M 24 26 M 50 70 70 70 163 160 156 M 160 M 178 M 24 22 22 26 12 84 43 76 10 46 M M M M M 22 22 22 22 81 65 M 45 M M 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 75 84 M M 155 177 120 161 170 157 153 175 170 169 162 185 164 166 169 160 151 178 164 M 22 22 22 22 20 32 59 21 19 23 21 18 20 22 20 48 25 22 21 46 M M 49 58 65 67 65 73 53 49 133 M M M M M 46 M M 162 160 M 56 64 76 70 M M 168 155 150 177 M M 47 85 68 68 M 171 165 M 307 308 309 310 311 312 313 314 315 316 317 318 319 320 57 52 42 45 73 72 74 45 M M M 181 168 156 155 157 154 M 49 M 65 65 44 M 51 M 21 21 43 132 150 M M M 321 322 323 324 325 50 21 46 55 M M M M M M 70 55 73 58 61 45 55 60 70 91 57 58 77 43 326 327 328 329 330 331 332 333 334 M 21 22 22 20 57 55 22 22 27 22 M M 180 177 174 155 163 156 171 158 160 154 157 159 172 152 151 150 156 173 169 157 169 175 174 180 159 M M M 5 335 22 22 M M 336 M 22 24 19 22 27 21 21 22 53 49 41 88 65 70 56 55 61 75 52 54 52 55 337 338 339 340 341 342 343 344 345 346 347 348 349 350 M M M M M M M M 180 159 165 M M M 22 22 22 15 22 22 21 22 22 M 180 174 M M 110 57 42 57 85 50 69 156 160 171 153 169 173 M M M M 351 352 353 354 355 356 357 358 359 360 5 M 22 22 30 27 22 24 27 M 66 53 62 43 80 170 160 M M 158 171 M 43 47 90 | 78 70 99 361 362 363 364 365 366 367 368 369 370 371 372 373 45 89 80 100 88 55 90 M M M M M M 24 22 22 22 40 40 23 34 24 23 26 20 23 23 23 23 31 50 23 23 25 20 24 20 45 46 76 50 96 155 158 175 174 167 166 158 165 163 181 182 153 170 160 155 165 153 150 155 163 152 182 178 180 175 175 185 173 M M M M M 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 65 65 50 96 46 90 M M M M M M M M M M M M 66 65 150 70 65 32 24 65 Investigate the following using the collected data: A. The confidence interval for Body Mass Index (BMI) of males and females for the Malaysian population with confidence level of 95%. B. It has been claimed that the mean for BMI of females for the Malaysian population is less than normal. Test whether this claim can be accepted. C. It has been claimed that the mean for BMI of males for the Malaysian population is 24. Test whether this claim can be accepted. D. The linear regression model between age and height of Malaysians. E. Test whether there is a strong relationship between age and weight of Malaysians. No Age Weight (in kg) Height (in cm) Gender 1 24 F F 2 3 F 4 5 6 7 47 83 60 80 80 100 75 60 47 24 25 24 24 20 25 25 21 21 23 57 22 F F F 8 F F F 9 10 45 11 55 F F F 169 171 173 170 170 160 180 163 151 157 178 158 157 180 158 159 170 166 170 178 173 175 167 12 13 14 15 90 46 60 F 22 F F 48 | 16 F 20 19 21 22 25 22 30 17 18 19 20 21 22 23 F F F F F 47 60 52 69 61 75 95 67 85 59 73 61 70 F F F F 186 F F F F 70 23 23 24 30 24 21 19 19 21 26 29 22 22 22 18 24 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 F 170 180 170 165 165 155 177 163 155 150 173 55 75 65 41 40 55 56 43 43 68 47 F F F F F F 171 155 21 22 22 155 175 162 F F F F F 41 42 43 44 F 22 23 22 22 59 65 58 53 164 157 164 F F 45 F 46 47 48 F F F F 49 50 51 F 17 42 22 21 16 24 20 58 69 22 44 22 F 52 160 164 153 149 173 163 153 162 165 167 165 145 160 190 155 163 155 F F 22 22 53 54 55 56 57 58 59 60 61 62 63 64 65 21 22 22 22 22 22 42 75 45 63 40 50 50 58 63 70 78 55 84 42 57 42 40 80 64 52 54 56 51 95 62 55 80 88 56 90 90 67 F F F F F F F F F F F F 156 184 165 150 66 F 67 68 69 70 71 22 22 21 51 22 49 20 22 159 160 160 175 167 150 F F F F F 72 F 73 21 22 22 74 75 76 77 78 175 182 176 171 171 165 175 160 165 156 F F F F 72 F 24 21 21 23 26 50 F F 79 80 47 70 F 62 F 22 21 23 F F 170 157 165 151 153 172 F 81 82 83 84 85 86 87 88 89 90 F F 173 172 185 F F F 22 22 18 22 22 22 21 22 23 23 23 25 21 F 91 F F 92 93 F F F 94 95 96 97 41 58 42 45 59 68 184 120 73 57 38 55 66 86 68 42 63 64 82 68 47 70 90 67 66 78 55 60 69 F F 14 F 98 99 F F F 1 F 100 101 102 103 104 105 5 F 169 163 148 166 171 170 161 162 183 160 179 165 150 160 173 175 156 152 172 175 159 162 162 167 159 184 181 157 F F F 25 22 22 19 25 24 22 21 46 49 26 47 58 34 34 24 28 21 22 53 42 59 F F F F 3 68 106 107 108 109 110 111 112 113 114 115 116 117 F F 5 5 F F F F 7 68 89 40 63 82 56 65 57 56 3 2 F F 118 119 120 167 158 157 F 63 F 121 60 182 F F F F 122 123 124 125 126 127 21 32 22 19 17 27 14 22 20 21 70 50 53 63 77 54 54 57 F F F F 64 F F F F 128 129 130 131 132 133 134 135 136 137 138 F F 21 20 22 22 55 58 22 27 F 54 58 41 58 58 70 55 75 45 60 65 67 50 160 161 146 172 172 168 162 170 172 154 159 160 177 167 170 165 183 156 165 160 173 153 167 200 165 167 174 175 162 172 153 22 F F F F F F F F F 70 89 F 60 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 22 20 22 21 22 22 22 22 21 22 22 22 27 23 18 24 21 70 67 63 F F F F | | ||| 78 F 74 64 57 55 75 53 66 60 73 76 147 162 157 155 F F F F F F F F 22 171 167 158 158 23 39 19 159 160 F F 161 162 F 22 22 23 24 163 F F F 23 24 71 71 100 97 51 72 93 130 57 83 60 F F 22 28 F 164 165 166 167 168 169 170 171 172 173 174 175 176 F F 23 55 54 58 F F 155 155 181 174 163 148 168 170 161 180 150 170 170 166 176 178 175 175 165 160 175 169 169 174 F 70 71 54 62 55 44 46 F F 19 21 45 F F 45 F F F 15 26 26 22 M M 24 24 19 130 50 85 71 75 65 72 70 63 63 63 55 51 98 66 68 M M M 19 M 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 19 167 167 167 176 162 177 M M M M M M 27 20 22 21 21 22 20 22 21 24 21 57 75 46 84 80 77 178 171 162 170 157 182 184 174 169 173 M M M M M M M 22 23 58 75 M M 21 24 21 23 71 115 80 177 179 176 M M M 23 M 67 67 67 70 67 167 167 167 176 M 23 23 23 20 19 M M 71 70 M M 67 67 58 M M M 75 62 45 75 167 172 165 165 165 168 177 172 155 177 165 159 162 M M M M M M M 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 154 168 173 155 M M M M 21 21 22 26 21 33 26 26 22 22 22 20 20 21 21 25 22 22 25 24 24 20 24 23 19 21 22 22 M M 52 49 50 43 50 63 67 67 73 64 58 75 75 80 53 43 65 56 73 M M M M M M 155 175 169 170 178 186 176 163 161 157 165 169 169 177 156 170 M M 5 M M M 61 53 M M 22 52 39 62 M 241 M 27 55 M 242 243 244 160 168 170 173 M M 171 M 245 246 247 248 249 60 65 60 78 58 51 62 58 65 70 55 31 21 22 22 21 58 32 50 22 22 22 22 22 M M M M 250 M M 55 70 50 151 168 165 168 155 160 160 165 160 155 175 160 160 154 150 175 168 M M M M 42 75 M M M 21 22 21 22 22 22 22 23 21 23 20 24 22 M M M M 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 2741 275 276 45 51 57 52 69 74 92 92 83 49 94 54 M 167 168 175 M M 160 180 160 M M M M 22 22 M 162 156 160 163 M 56 72 58 72 65 67 52 17 24 51 M M M M 160 174 158 168 24 21 23 21 70 M M 160 171 21 M M 277 278 279 280 50 68 85 50 22 24 175 163 M M 24 M 24 26 M 50 70 70 70 163 160 156 M 160 M 178 M 24 22 22 26 12 84 43 76 10 46 M M M M M 22 22 22 22 81 65 M 45 M M 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 75 84 M M 155 177 120 161 170 157 153 175 170 169 162 185 164 166 169 160 151 178 164 M 22 22 22 22 20 32 59 21 19 23 21 18 20 22 20 48 25 22 21 46 M M 49 58 65 67 65 73 53 49 133 M M M M M 46 M M 162 160 M 56 64 76 70 M M 168 155 150 177 M M 47 85 68 68 M 171 165 M 307 308 309 310 311 312 313 314 315 316 317 318 319 320 57 52 42 45 73 72 74 45 M M M 181 168 156 155 157 154 M 49 M 65 65 44 M 51 M 21 21 43 132 150 M M M 321 322 323 324 325 50 21 46 55 M M M M M M 70 55 73 58 61 45 55 60 70 91 57 58 77 43 326 327 328 329 330 331 332 333 334 M 21 22 22 20 57 55 22 22 27 22 M M 180 177 174 155 163 156 171 158 160 154 157 159 172 152 151 150 156 173 169 157 169 175 174 180 159 M M M 5 335 22 22 M M 336 M 22 24 19 22 27 21 21 22 53 49 41 88 65 70 56 55 61 75 52 54 52 55 337 338 339 340 341 342 343 344 345 346 347 348 349 350 M M M M M M M M 180 159 165 M M M 22 22 22 15 22 22 21 22 22 M 180 174 M M 110 57 42 57 85 50 69 156 160 171 153 169 173 M M M M 351 352 353 354 355 356 357 358 359 360 5 M 22 22 30 27 22 24 27 M 66 53 62 43 80 170 160 M M 158 171 M 43 47 90 | 78 70 99 361 362 363 364 365 366 367 368 369 370 371 372 373 45 89 80 100 88 55 90 M M M M M M 24 22 22 22 40 40 23 34 24 23 26 20 23 23 23 23 31 50 23 23 25 20 24 20 45 46 76 50 96 155 158 175 174 167 166 158 165 163 181 182 153 170 160 155 165 153 150 155 163 152 182 178 180 175 175 185 173 M M M M M 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 65 65 50 96 46 90 M M M M M M M M M M M M 66 65 150 70 65 32 24 65

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

AMERICAN JOURNAL OF HUMAN BIOLOGY 14:762-768 (2002) Is Obesity Associated With Poor Sleep Quality in Adolescents? NEERAJ K. GUPTA,1 WILLIAM H. MUELLER,1* WENYAW CHAN,1 AND JANET C. MEININGER2 I...

##################>### ############################################# ################ ### ####### ### ############################################################### R#o#o#t#...

1 A casecontrol study was performed to determine whether head injury was associated with an increased risk of brain tumors in children. 200 cases with brain cancer were identified from the state...

A medical researcher studied obesity in adolescent girls. The researcher collected body mass index (BMI), body fat percentage, and other personal variables from 92 adolescent girls. The data...

I need help on the following questions. There are 34 and I need them by Tuesday as accurate as possible. Testbank-Final Exam Essentials of Biostatistics for Public Health, 2nd Edition Lisa M....

Use the data regarding BMI that were collected in data project 6 of Chapter 7 to complete this problem. Test the claim that the mean BMI for males is the same as that for females. Test the claim that...

1. A study is conducted to estimate the difference between the body mass index (BMI) of males and females. The following random samples were obtained with the following results: Male BMI n = 40 mean...

Commentary Beyond Black Box Epidemiology Douglas L. Weed, MD, PhD "Black box epidemiology" is the most recent addition to a long list of disciplinary subgroups although few practitioners would likely...

We know that the mean weight of men is greater than the mean weight of women, and the mean height of men is greater than the mean height of women. A persons body mass index (BMI) is computed by...

I need help with these practice questions please, I need to know how to solve these According to the World Health Organization (WHO), Body Mass Index (BMI) is a statistic that indicates the ratio of...

Suppose Jenna's hourly wage is currently $12 and she does 10 hours of work per day. Her wage is raise to $14 and as a result her income effect is 2 hours and substitution effect is 3 hours. Show on a...

On January 1, 2012, Snow Company was authorized to issue 100,000 shares of common stock , par value $10 per share, and 10,000 shares of 8% preferred stock, par value $20 per share. Record the...

Question 1 3 Gen. Chiang Kai - shek broke with Dr . Sun Yat - Sen's legacy when he decided to abandon, and then fight, communist allies. True False

The problem within my workplace's Information Technology (IT) department revolves around the emergence of a toxic clique nicknamed "The Running Club." Initially conceived as a fitness initiative...