 Details
 Parent Category: Physics Assignments' Solutions
We Helped With This Physics Assignment: Have A Similar One?
Category  Physics 

Subject  Other 
Difficulty  Undergraduate 
Status  Solved 
More Info  Help With Physics Assignment 
Short Assignment Requirements
Assignment Description
Linear Kinetics
in Excel
Linear Kinetics
For the data set “GRF of 2 Jumpers” assume:
Body mass is 85 kg
Body starts with an initial velocity of zero
Body starts in a squat and leaves the ground when the COM rises 0.31m from the starting position
Determine:
Takeoff velocity (when leaving the ground)
Peak force for GRF and effective force (∑Fy)
Average force for GRF and effective force (∑Fy)
Jump height
Graph (put both jumpers on one graph, be sure to label!):
GRF vs. time
Position vs. time
Velocity vs. time
Acceleration vs. time
Set Up the Data
Download the file ‘GRF of 2 Jumpers’ from Moodle
Open with Excel
Insert a Column between Columns A and B
Repeat to insert a second column
Label Column B ‘Mass’
Label Column C ‘Weight’
Column D should be ‘GRF Jumper A’
Column E should be ‘GRF Jumper B’
Set Up the Data
You were given body mass for both jumpers=85 kg
Type this into column C and drag down
Set Up the Data
Add two columns between columns D and E
Determine acceleration from GRF data
Σ F_{y}= ma_{y }Σ F_{y}=GRF_{y}+F_{g}
ay=GRFmy+Fg
Determine acceleration from GRF data
Σ F_{y}= ma_{y }Σ F_{y}=GRF_{y}+F_{g}
ay=GRFmy+Fg
Determine Velocity from
Acceleration
𝑣_{𝑓 }=𝑎𝑡_{𝑓 }−𝑡_{𝑖} +𝑣_{𝑖}
Add another blank column after your acceleration data
Determine Velocity from
Acceleration
𝑣_{𝑓 }=𝑎𝑡_{𝑓 }−𝑡_{𝑖} +𝑣_{𝑖}
Add another blank column after your acceleration data
Determine Position from Velocity
𝑝_{𝑓 }= 𝑣𝑡_{𝑓 }−𝑡_{𝑖} +𝑝_{𝑖}
Add another blank column after your velocity data
Determine Position from Velocity
𝑝_{𝑓 }= 𝑣𝑡_{𝑓 }−𝑡_{𝑖} +𝑝_{𝑖}
Add another blank column after your velocity data
Determine
Takeoff velocity (when leaving the ground)
Body starts in a squat and leaves the ground when the COM rises 0.31m from the starting position
Peak force for GRF and effective force (∑Fy)
Average force for GRF and effective force (∑Fy)
Jump Height
v_{i}=0
v_{f}^{2}=v_{i}^{2}+2a∆p
v2
∆p=
19.62
Determine
Takeoff velocity (when leaving the ground)
Body starts in a squat and leaves the ground when the COM rises 0.31m from the starting position
2.75 m/s
Peak force for GRF and effective force (∑Fy)
Peak GRF= 3214.57
Average force for GRF and effective force (∑Fy)
Average GRF= 2002.60
Jump Height
v_{i}=0
v_{f}^{2}=v_{i}^{2}+2a∆p
v2
∆p=
19.62
Linear Kinetics
Determine:
Takeoff velocity (when leaving the ground)
Peak force for GRF and effective force (∑Fy)
Average force for GRF and effective force (∑Fy)
Jump height
Graph (put both jumpers on one graph, be sure to label!):
GRF vs. time
Position vs. time
Velocity vs. time
Acceleration vs. time
Assignment Description
KIN445 Linear Kinetics in Excel Name:______________________________
Complete the table with the data from the two jumpers:
 Jumper A  Jumper B 
Takeoff Velocity 


Peak GRF 


Average GRF 


Peak Effective Force 


Average Effective Force 


Jump Height 


Paste your graphs:
Make sure that each graph has a title, axis labels with units, and a legend!
GRF vs. Time
Position vs. Time
Velocity vs. Time
Acceleration vs. Time
Comment on your findings: