Question: Using SPSS or Minitab or Excel, please draw and plot actual graphs, box plots, histograms, bar charts diagrams, and figures for the variables of this
Using SPSS or Minitab or Excel, please draw and plot actual graphs, box plots, histograms, bar charts diagrams, and figures for the variables of this data table below of 18 participants in a study with actual descriptive statistics with ANOVA
| ID | Age | Height | Weight | BMI | Sex | Group | Training Status | T1_TrailA | T1_TrailB | T1_RP1 | T1_RP2 | T1_RP3 | T1_PP1 | T1_PP2 | T1_PP3 | T1_AvgP1 | T1_AvgP2 | T1_AvgP3 | T1_MinP1 | T1_MinP2 | T1_MinP3 | T1_Fatigue1 | T1_Fatigue2 | T1_Fatigue3 | T1_MaxHR1 | T1_MaxHR2 | T1_MaxHR3 | T1_PostTrailA | T1_PostTrailB | T2_TrailA | T2_TrailB | T2_RP1 | T2_RP2 | T2_RP3 | T2_PP1 | T2_PP2 | T2_PP3 | T2_AvgP1 | T2_AvgP2 | T2_AvgP3 | T2_MinP1 | T2_MinP2 | T2_MinP3 | T2_Fatigue1 | T2_Fatigue2 | T2_Fatigue3 | T2_MaxHR1 | T2_MaxHR2 | T2_MaxHR3 | T2_PostTrailA | T2_PostTrailB | Remark | ||
| 1001 | 22 | 168 | 73 | 25.9 | 1 | 0 | Very Active | 12.31 | 23.55 | 10.99 | 8.29 | 8.76 | 884 | 661 | 713 | 554 | 374 | 360 | 316 | 190 | 155 | 60 | 68 | 75 | 181 | 181 | 184 | 13.8 | 17.14 | 11.02 | 16.78 | 11.88 | 9.32 | 7.7 | 931 | 828 | 641 | 602 | 465 | 407 | 300 | 249 | 245 | 65 | 63 | 56 | 181 | 181 | 179 | 9.53 | 12.5 | |||
| 1002 | 28 | 182 | 83 | 25.1 | 1 | 0 | Very Active | 13.88 | 21.12 | 11.7 | 9.04 | 10.16 | 971 | 750 | 843 | 772 | 636 | 638 | 585 | 500 | 478 | 40 | 33 | 43 | 174 | 169 | 177 | 10.66 | 17.32 | 10.7 | 26.25 | 11.83 | 10.34 | 9.47 | 1050 | 894 | 854 | 767 | 695 | 625 | 563 | 518 | 498 | 43 | 40 | 37 | 172 | 174 | 170 | 11.02 | 13.7 | |||
| 1003 | 23 | 169 | 65 | 22.8 | 0 | 0 | active | 16.67 | 37.57 | 8.02 | 6.65 | 6.37 | 521 | 432 | 414 | 329 | 273 | 253 | 185 | 172 | 166 | 65 | 60 | 60 | 192 | 191 | 191 | 14.65 | 30.09 | 15.43 | 28.22 | 9.08 | 7.43 | 6.83 | 590 | 483 | 444 | 380 | 287 | 268 | 261 | 185 | 198 | 56 | 62 | 55 | 189 | 189 | 188 | 15.21 | 22.86 | |||
| 1004 | 24 | 165 | 68 | 25.0 | 0 | 0 | active | 15.62 | 28.19 | 10.71 | 8.68 | 8.71 | 739 | 599 | 601 | 496 | 450 | 428 | 308 | 292 | 277 | 58 | 51 | 54 | 190 | 186 | 185 | 15.23 | 24.16 | 13.65 | 25.7 | 10.62 | 9.15 | 8.31 | 722 | 622 | 565 | 504 | 430 | 385 | 325 | 274 | 239 | 55 | 56 | 58 | 187 | 185 | 183 | 12.27 | 19.83 | |||
| 1005 | 28 | 180 | 75 | 23.1 | 1 | 0 | active | 14.77 | 26.59 | 9.85 | 8.56 | 8.11 | 739 | 642 | 608 | 596 | 500 | 495 | 393 | 382 | 397 | 47 | 41 | 35 | 188 | 185 | 194 | 14.84 | 16.57 | 11.94 | 18.75 | 10.03 | 8.96 | 7.89 | 752 | 672 | 592 | 622 | 569 | 499 | 476 | 458 | 428 | 37 | 32 | 28 | 190 | 189 | 191 | 10.28 | 12.35 | |||
| 1006 | 26 | 173 | 80 | 26.7 | 1 | 0 | active | 15.72 | 29.36 | 11.22 | 10.68 | 10.13 | 943 | 876 | 833 | 679 | 629 | 593 | 423 | 376 | 327 | 43 | 56 | 49 | 154 | 169 | 167 | 14.25 | 28.54 | 11.29 | 35.88 | 10.63 | 10.31 | 8.04 | 850 | 825 | 643 | 683 | 606 | 508 | 473 | 387 | 314 | 44 | 53 | 51 | 163 | 162 | 160 | 9.86 | 32.11 | |||
| 1007 | 28 | 178 | 80 | 25.2 | 1 | 1 | Active | 12.69 | 22.03 | 14.86 | 14.14 | 9.93 | 1040 | 990 | 695 | 831 | 734 | 384 | 575 | 438 | 151 | 45 | 56 | 78 | 176 | 174 | 160 | 14.03 | 24.19 | 14.69 | 27.96 | 14.51 | 12.24 | 10.31 | 1016 | 857 | 722 | 816 | 695 | 590 | 583 | 478 | 424 | 43 | 44 | 41 | 166 | 162 | 168 | 11.65 | 18.18 | BL T3:20s test data=error(started=10s) | ||
| 1008 | 24 | 172 | 59 | 19.9 | 0 | 1 | Not Active | 14.5 | 29.6 | 8.46 | 7.25 | 4.68 | 579 | 493 | 308 | 385 | 292 | 201 | 233 | 174 | 131 | 53 | 59 | 53 | 189 | 189 | 186 | 14.34 | 23.53 | 13.13 | 23.64 | 8.54 | 6.59 | 6.17 | 635 | 488 | 442 | 372 | 277 | 244 | 234 | 179 | 140 | 54 | 54 | 61 | 188 | 187 | 189 | 9.57 | 19.19 | |||
| 1009 | 23 | 159 | 52 | 20.6 | 0 | 1 | active | 19.75 | 31.28 | 6.65 | 6.33 | 6.08 | 346 | 329 | 316 | 265 | 226 | 198 | 188 | 152 | 134 | 46 | 54 | 58 | 180 | 185 | 190 | 14 | 30.5 | 14.12 | 22.38 | 8.65 | 7.67 | 6.31 | 450 | 399 | 328 | 286 | 254 | 179 | 171 | 154 | 66 | 62 | 61 | 80 | 196 | 199 | 189 | 12.67 | 20.07 | |||
| 1010 | 38 | 180 | 82 | 25.3 | 1 | 1 | active | 31.75 | 44.52 | 6.96 | 6.32 | 5.91 | 571 | 518 | 504 | 467 | 430 | 246 | 313 | 317 | 55 | 45 | 39 | 89 | 169 | 161 | 147 | 23.19 | 44.97 | 19.09 | 33.87 | 6.63 | 6.74 | 6.5 | 544 | 553 | 533 | 445 | 423 | 431 | 333 | 258 | 313 | 39 | 53 | 41 | 168 | 168 | 165 | 15 | 54 | |||
| 1011 | 23 | 172 | 60 | 20.3 | 1 | 1 | active | 16 | 22 | 9.43 | 7.25 | 7.18 | 711 | 511 | 465 | 507 | 398 | 344 | 345 | 143 | 280 | 56 | 64 | 65 | 184 | 179 | 168 | 11 | 30 | 12.72 | 33.57 | 8.45 | 6.63 | 5.73 | 765 | 597 | 602 | 566 | 435 | 431 | 396 | 304 | 304 | 43 | 43 | 45 | 184 | 183 | 182 | 10 | 19.91 | |||
| 1012 | 26 | 170 | 69 | 23.9 | 1 | 1 | active | 13.04 | 37.83 | 7.96 | 6.84 | 5.64 | 727 | 642 | 527 | 557 | 479 | 395 | 315 | 332 | 291 | 57 | 48 | 45 | 179 | 178 | 174 | 10.68 | 27.65 | 11.9 | 25.35 | 8.67 | 8.34 | 6 | 792 | 780 | 558 | 607 | 584 | 420 | 450 | 397 | 323 | 51 | 49 | 42 | 168 | 178 | 178 | 10.26 | 17.87 | |||
| 1013 | 23 | 178 | 74 | 23.4 | 1 | 2 | Active | 13.38 | 21.08 | 12.88 | 9.27 | 8.77 | 953 | 686 | 649 | 501 | 567 | 520 | 501 | 443 | 396 | 47 | 35 | 39 | 174 | 166 | 169 | 14.53 | 21.4 | 13.37 | 17.72 | 12.66 | 9.45 | 9.61 | 937 | 699 | 711 | 743 | 602 | 548 | 521 | 491 | 398 | 44 | 30 | 44 | 171 | 168 | 172 | 13.04 | 22.53 | |||
| 1014 | 37 | 157 | 51 | 20.7 | 0 | 2 | Active | 13.97 | 30.58 | 9.98 | 9.6 | 8.71 | 519 | 499 | 453 | 412 | 374 | 341 | 296 | 257 | 224 | 43 | 49 | 51 | 167 | 172 | 170 | 13.33 | 21.34 | 11.46 | 16.68 | 10.35 | 10.61 | 9.38 | 538 | 552 | 488 | 425 | 397 | 370 | 284 | 271 | 249 | 47 | 51 | 49 | 181 | 179 | 176 | 9.59 | 16.45 | |||
| 1015 | 28 | 158 | 57 | 22.8 | 1 | 2 | Active | 15.66 | 36.5 | 11.53 | 10.4 | 10.01 | 657 | 594 | 571 | 518 | 442 | 373 | 366 | 322 | 274 | 44 | 43 | 43 | 189 | 172 | 172 | 10.38 | 26.97 | 10.09 | 25.93 | 11.71 | 11.01 | 10.54 | 668 | 627 | 601 | 516 | 464 | 374 | 360 | 300 | 237 | 43 | 50 | 51 | 185 | 173 | 173 | 10.67 | 22.32 | |||
| 1016 | 24 | 175 | 70 | 22.9 | 1 | 2 | very active | 10.76 | 25 | 10.6 | 8.93 | 7.47 | 1106 | 939 | 888 | 748 | 577 | 514 | 445 | 310 | 280 | 56 | 64 | 65 | 176 | 172 | 173 | 13.17 | 52 | 10.09 | 19.91 | 10.69 | 8.24 | 7.34 | 1103 | 1036 | 992 | 742 | 625 | 523 | 451 | 372 | 261 | 57 | 61 | 69 | 176 | 173 | 172 | 12.72 | 13.97 | |||
| 1017 | 24 | 172 | 80 | 27.0 | 1 | 2 | very active | 15.88 | 48.58 | 12.33 | 11.35 | 10.73 | 986 | 908 | 858 | 522 | 478 | 422 | 325 | 219 | 148 | 54 | 58 | 59 | 173 | 188 | 192 | 12.47 | 38.32 | 17.08 | 29.88 | 12.88 | 11.76 | 11.36 | 1030 | 941 | 909 | 730 | 561 | 538 | 521 | 361 | 364 | 47 | 54 | 56 | 180 | 186 | 188 | 12.56 | 25.68 | |||
| 1018 | 26 | 161 | 62 | 23.9 | 0 | 2 | active | 11.75 | 29.16 | 9 | 7.58 | 7.93 | 549 | 470 | 484 | 436 | 379 | 367 | 306 | 280 | 209 | 44 | 40 | 57 | 152 | 157 | 160 | 9.47 | 30 | 9.72 | 27.25 | 8.88 | 9.92 | 9.4 | 533 | 595 | 564 | 414 | 438 | 393 | 310 | 255 | 224 | 42 | 57 | 60 | 155 | 159 | 157 | 9.75 | 27.78 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
