I have provided the answer for number 1 which is the graph created from the data provided on the excel sheet. What are the answers for question 2-4 and may you please show a step by step to how the answers were solved? This is all the reference I have provided from instructor to work with; prompt, graph, and excel data.

Forceplate Da SPME 430 Jumping Lab Frame# Time M/L A/P Vertical BodyWeight 272 1.36 -0.9421 -3.4345 600.08 600.4 273 1.365 -1.3884 -2.5145 600.6 600.4 This spreadsheet contains the ground reaction force data of a single subject 274 1.37 1.0054 -1.9436 501.2 600.4 performing a countermovement jump. The data begin with the person standing 275 1.375 0.50096 -1.4161 601.56 600.4 upright. The person then performs a countermovement jump, leaving the 276 1.38 -0.9256 -0.93983 601.49 600.4 forceplate when the forces equal zero. The data end at the moment the person 277 1.385 1.0529 0.44924 501.68 600.4 touches the ground after jumping in the air. 278 1.39 0.44369 -0.17027 602 600.4 279 1.395 0.64687 0.1202 601.9 600.4 280 1.4 -1.0702 0.48753 01.9 600.4 281 1.405 -0.73024 0.5696 602.31 600.4 282 1.41 -1.0128 .84926 602.29 600.4 283 1.415 -1.6422 1.1641 602.3 600.4 284 1.4 1.177 1.2164 502.1 600.4 285 1.425 0.98262 1.061 601.43 600.4 286 1.43 -1.4502 .94605 500.2 600.4 287 1.435 -1.718 1.0474 599.9 600.4 288 1.44 -1.1098 0.69096 599.31 600.4 289 1.445 1.2613 0.64053 598.98 600.4 290 1.45 -1.7724 0.39663 598.21 600.4 291 1.455 1.3648 0.024248 597.27 600.4 292 1.46 -1.2182 0.35224 596.32 600.4 293 1.465 1.7766 0.76623 595.7 600.4 294 1.4 1.6679 1.2186 595.0 600.4 295 1.475 1.2791 1.9262 594.4 600.4 296 1.48 -1.9058 2.3493 594.77 600.4 297 1.485 2.0883 2.6521 595.4 600.4 298 1.49 -1.341 2.9787 695.94 600.4 299 1.495 .1918 2.9584 597.0 600.4 300 1.5 -1.2695 2.7647 598.18 600.4 301 1.505 -0.60858 -2.6507 598.84 600.4 302 1.51 0.18438 -2.2628 599.06 600.4 303 1.515 0.33303 1.9439 597.71 600.4 304 1.52 0.19452 -1.955 594.8 600.4 305 1.525 0.68455 2.0233 592.17 600.4 306 1.53 0.20238 1.9763 589.11 600.4 307 1.535 0.019333 2.1767 584.97 600.4 308 1.54 0.26853 -2.7613 580.0 600.4 309 1.545 -0.2777 3.4171 574.9 600.4 310 1.5 -1.1621 3.9768 570.01 600.4 311 1.555 -1.577 4.5665 564 600.4 312 1.56 2.3568 4.6641 556.4 600.4 313 1.565 -4.0421 -3.7401 546.68 600.4 314 1.57 5.346 2.4675 534.7 600.4 315 1.575 6.5215 -1.4492 521.86 600.4 316 1.58 -7.9545 -0.68786 508.97 600.4 317 1.585 8.6098 0.49062 195.37 600.4 31 1.59 8.5906 1.2029 481.96 600.4 31 1.595 -9.0179 1.9638 169.9 600.4 320 1.6 9.4013 3.2271 457.74 600.4 321 1.605 8.8458 -5.1065 446.05 600.4 322 1.61 8.5415 7.0891 435.53 600.4 323 1.615 8.7815 8.5909 125.52 600.4 324 1.62 .1814 -9.5044 415.5 600.4 325 1.625 -7.3596 9.7089 404.42 600.4 326 1.63 -7.0037 8.7462 391.97 600.4 327 .635 6.0989 6.2583 379.47 600.4 328 1.64 4.3099 2.5646 367.7 600.4 329 ..645 2.766 2.2614 357.6 600.4 330 1.65 -1.5349 8.486 349.33 600.4 331 1.655 0.070497 15.10 342.13 600.4 332 1.66 1.2216 20.739 336.92 600.4 333 1.665 0.58531 24.484 332.0 600.4 334 1.6 0.30202 25.793 328.3 600.4 335 .675 0.5272 24.86 325.8 600.4 336 1.68 0.27596 22.554 324.6 600.4 337 .685 0.51921 19.036 323.98 600.4 338 1.6 1.9103 15.129 323.75 600.4 339 ..695 2.7184 1.38 325.6 600.4 340 1.7 2.8392 7.9407 330.53 600.4 341 1.705 2.9752 5.0536 338.4 600.4 342 1.71 2.6804 2.9047 347.8 600.4 343 ..715 1.3785 1.6911 359 600.4 344 1.72 .3226 1.2629 73.5 00. 345 .725 2.1917 1.9088 392.73 600.4 346 1.73 2.7015 2.9347 411.99 600.4 347 1.73 3.1063 2.6794 430.45 600.4 348 1.74 3.7957 0.67806 449.73 600.4 349 1.745 3.6669 1.6286 469.1 600. 350 1.75 2.9316 -4.462 486.17 600.4 351 1.755 2.7739 3.0235 500.24 600.4352 1.76 2.9644 -11.494 511.64 600.4 353 1.765 3.2366 -13.688 521.5 600.4 354 1.77 4.5282 -14.879 528.82 600. 355 1.775 5.865 -15.717 531.86 500.4 356 1.78 6.0121 -16.017 530.74 600.4 357 1.785 6.4482 -15.969 528.25 600.4 358 1.79 7.8199 16.006 526.99 600.4 359 1.795 8.4559 15.915 527.4 500.4 360 1.8 8.952 -15.512 531.19 500. 361 1.805 .0.63 -14.81 540.14 500. 362 1.81 12.207 14.20 552.57 ;00. 363 1.815 12.76 -14.302 565.75 500. 364 1.82 13.412 -14.92 579.33 500. 365 1.825 14.008 15.368 592.66 ;00. 366 1.83 13.38 -15.434 604.95 600.4 367 1.835 2.73 -15.485 516.35 00. 368 1.84 12.741 15.195 629.32 600. 369 1.845 11.895 -14.578 644.24 500. 370 1.85 0.75 -15.132 659.45 500. 371 1.855 10.21 -17.362 674.04 500. 372 1.86 9.011 20.99 586.57 500. 373 1.865 7.0667 -25.6 696.56 500. 374 1.87 6.021 30.467 05.3 500. 375 1.875 5.3962 34.015 714.5 600. 376 1.88 4.0389 35.733 24.49 600.4 377 1.885 2.7511 -36.047 735.42 500. 378 1.89 2.323 -35.447 746.96 500. 379 1.895 1.184 -34.373 759.43 500. 380 19 0.22336 -33.899 772.17 ;00. 381 1.905 0.90951 34.061 786.24 500. 382 1.91 -2.0198 -34.608 802.11 500. 383 1.915 -4.1118 35.84 819.65 500. 384 1.92 -37.08 839.02 600.4 385 1.925 -6.022 -38.341 858.58 00. 386 1.93 -7.5336 39.566 877.08 600. 387 1.935 8.842 41.03 894.48 388 1.94 -9.270 42.061 910.83 500. 389 1.945 10.259 42.298 926.3 500. 390 1.95 -11.156 -42.13 941.39 500. 391 1.955 -10.955 41.402 955.86 500. 392 1.96 10.808 40.077 969.04 ;00. 393 1.965 -11.19 38.73 980.9 394 1.97 10.757 -37.146 91.71 500. 395 1.975 -9.9106 .34.982 1001.8 500. 396 1.98 -9.8505 32.193 1011.6 ;00. 397 1.985 -9.2169 -28.923 1021.4 500. 398 1.99 -7.848 25.216 1030.5 ;00. 399 1.995 -7.3778 21.245 1038.3 500. 400 -7.298 -16.801 1045.7 500. 401 2.005 -6.3141 -11.503 1052.2 500. 402 2.01 -5.6195 -5.0963 1057.6 600.4 403 2.015 -4.8635 1.7113 1061.5 00. 404 2.02 -3.2704 8.6559 1065.3 500. 405 2.025 1.760 16.168 1069. ;00. 406 2.03 -0.7635 23.547 1073.2 500. 407 2.035 0.966 29.94 077. ;00. 408 2.04 3.2436 $5.043 1082 ;00. 409 2.045 5.0187 38.598 1089.3 600.4 410 2.05 7.2307 39.729 1097.5 411 2.055 9.9704 39.082 1106.5 600.4 412 2.06 11.231 37.458 1115.9 600.4 413 2.065 10.884 35.699 1125 500. 414 2.0 10.047 34.325 133.7 ;00. 415 2.075 .432 32.814 1142.3 500. 416 2.08 5.956 31.908 1150.8 ;00. 417 2.085 4.3769 31.605 1160.1 500. 418 2.09 4.0017 30.705 1170.2 500. 419 2.095 3.0604 29.01 1181.3 ;00. 420 2.1 1.7075 26.582 1194.4 500.4 421 2.105 0.51662 22.976 1208 500. 422 2.11 0.78344 18.722 1220.7 500. 423 2.115 -2.1304 15.302 1233.4 424 2.12 -1.7357 13.753 1245.9 500. 425 2.125 0.60219 14.357 1257. 500. 426 2.13 -0.51657 17.216 1267.8 700 427 2.135 -0.77672 21.329 1277.3 600.4 428 2.14 -0.27494 26.827 1286.5 500. 429 2.145 -0.22837 33.289 1295.2 600. 430 2.15 -0.61404 39.798 1302.8 500. 431 2.155 -0.16153 45.841 1308.6 500. 432 2.16 0.13491 52.85 1312.3 600. 433 2.165 -0.18819 61.281 1312.3 500. 434 2.17 0.56642 70.76 1307.6 600.435 2.175 1.5009 81.805 1297.9 600.4 436 2.18 1.2078 93.568 1282.6 600.4 437 2.185 0.24781 102.85 1261.2 600.4 438 2.19 -2.3424 107.77 1232.1 600.4 439 2.195 4.6888 109.47 1194.4 600.4 440 2.2 -5.8961 108.55 1148.5 600.4 441 2.205 -3.6546 104.59 1098.9 500. 442 2.21 0.7196 94.791 1043.2 600.4 443 .215 4.3487 79.432 977.22 500. 444 2.22 3.1295 1.35 901.42 600.4 445 2.225 11.816 43.475 817.97 500. 446 2.23 12.422 27.86 725.02 500. 447 2.235 11.194 12.676 619.02 600.4 448 2.24 9.2372 -2.2171 502.98 500. 449 2.245 5.8414 -15.133 382.86 450 2.25 2.9143 -27.308 272.07 00. 451 2.255 -1.1231 -36.102 178.11 500. 452 2.26 ;.1556 -33.815 108.09 600.4 453 2.265 6.9784 -23.008 61.813 00. 454 2.27 4.4436 -11.369 30.66 500. 455 2.275 -1.314 -3.2961 10.378 500. 456 2.28 0.03877 -0.013501 0.47174 600. 457 2.285 600.4 o 458 2.29 0 600. 459 2.295 0 600. 460 23 0 600. 461 2.305 600. 462 2.31 0 600. 463 2.315 0 600. 464 2.32 600. 465 2.325 0 500. 466 2.33 600. 467 ..335 600. 468 2.34 0 600. 469 2.345 500. 470 2.35 600.4 471 2.355 600.4 472 2.36 600.4 473 2.365 600.4 474 2.37 600.4 475 2.375 600.4 476 2.38 600.4 477 ..385 600.4 478 2.39 600.4 479 2.395 600.4 480 2.4 600.4 481 2.405 600.4 482 2.41 600.4 483 2.415 0 600.4 484 2.42 600.4 485 2.425 600.4 486 2.43 0 600.4 b o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o O O O O O O O O OOO OOOOOO0 0 487 .435 600.4 488 2.44 o o o o o o o o o o O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O OOO 600.4 489 2.445 600.4 490 2.45 600.4 491 2.455 0 600.4 492 2.46 600.4 493 2.465 600.4 494 2.47 600.4 495 2.475 600.4 496 2.48 600.4 497 .485 0 600.4 498 249 600.4 499 2.495 600.4 500 2.5 600.4 501 2.505 0 600.4 502 2.51 0 600.4 503 2.515 600.4 504 2.52 600.4 505 2.525 600.4 506 2.53 0 600.4 507 2.535 0 600.4 508 2.54 600.4 509 2.545 600.4 510 2.55 0 600.4 511 2.555 ood 600.4 512 2.56 600.4 513 2.565 600.4 514 2.57 600.4 515 2.575 600.4 516 2.58 600.4 517 2.585 600.4600.4 484 2.42 600.4 485 2.425 600.4 486 2.43 ooooo 600.4 487 2.435 600.4 488 2.44 600.4 489 2.445 600.4 490 2.45 600.4 491 2.455 600.4 492 2.46 600.4 493 2.465 600.4 494 2.47 600.4 495 2.475 500.4 496 2.48 600.4 497 2.485 600.4 498 2.49 600.4 499 2.495 oo oo oo oo oo oo ooo ooo 600.4 500 2.5 600.4 501 2.505 600.4 502 2.51 600.4 503 2.515 o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o ooo oooooo 600.4 o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o ooo oooooo 504 2.52 600.4 505 2.525 600.4 506 2.53 600.4 507 2.535 600.4 508 2.54 600.4 509 2.545 600.4 510 2.55 600.4 511 2.555 600.4 512 2.56 600.4 513 2.565 600.4 514 2.57 600.4 515 2.575 600.4 516 2.58 boo ooo ooo ooo ooo 600.4 517 2.585 600.4 518 2.59 600.4 519 2.595 600.4 520 2.6 600.4 521 2.605 600.4 522 2.61 600.4 523 2.615 600.4 524 2.62Vertical 1400 1200 1060 400 200 D SO 150 200 250 3:00KIN 300 - Biomechanics of Human Movement Lab 5: Linear Kinetics Name Date Orientation: Most of our movements ultimately rely upon our interaction with the ground. We are constantly pushing against the ground both vertically and horizontally as we initiate and modify movements of the total body and body segments (i.e., performing a push up, or vertical jumping). Because of the importance of our interactions with the ground in the generation and modulation of our movements, the ground reaction force (GRF) could arguably be considered the most important external force acting on the body. What is important to keep in mind is that the GRF is largely under our control via coordinated muscle actions. By producing a certain combination of muscle actions, we ultimately push against the ground which pushes back against the body with an equal and opposite force. This is explained by Newton's 3rd law of motion which states that for every action there is an equal and opposite reaction. This experiment examines the difference in maximal countermovement jump height between using the force plate and using flight time. When using the Force Plate: According the impulse-momentum relationship, if the jumper initiates the upward phase of the jump from a resting state (v; = 0; either from a squat or bottom of a countermovement), the impulse generated by the athlete can be used to calculate the velocity of the center of mass (CM) at the instant of takeoff: Impulse = Momentumfinal - Momentum Initial ImpulseTotal - ImpulseBW = Impulse jump ImpulseTotal - ImpulseBw = m(vf - vi) (Average GRF * t) - (Bodyweight * t) = m(vf - vi) (Average GRF * t) - (Bodyweight * t) of = m where m is the body mass, v; is the vertical velocity at the beginning of the upward movement, and vy is the vertical velocity at the instant of takeoff.This vertical takeoff velocity can then be used with the equations of uniformly accelerated motion (projectile motion) to calculate the height to which the COM was elevated during the jump. Height = 2g where g is the acceleration due to gravity, v; is the vertical velocity vertical velocity at the instant of takeoff, vy is the vertical velocity at the apex of the flight, and Ay is the vertical displacement. When using Flight Time: The time at which a person is in the air (when ground reaction force is zero) can be used to determine jump height. Note that flight time consists of two halves: rising and falling. Therefore, your calculation must reflect 1/2 of the full time in the air: Height = vit + 29tz Assignment #1 (5 points): Complete the following questions. The answers to questions need to be written in complete sentences. Copy and paste figures and math responses into the same word document as your written responses. Upload your lab document onto the Canvas site. All data needed for this assignment are provided on Canvas in excel format. 1. Create a figure of the vertical GRF versus time of the countermovement jump. Create a dotted horizontal line for bodyweight. Using a software such as Paint, label with the following: a line where body weight is, bottom of squat, and toe off. 2. On your word document, solve for jump height using the impulse-momentum relationship. Write out your calculations step by step. 3. On your word document, solve for jump height using flight time. Write out your calculations step by step. Flight time can be obtained from the excel spreadsheet. 4. Using the two heights you calculated in Questions 2 & 3 answer the following questions: a. Which method produced the largest jump height and how significant is the difference? b . What are some limitations for each method