Attaching the excel file which has results in it. Basically performed a test on 6 participants, They had to do different timings warm up session and then after each warm up session they had perform a sprint performance.

So in the file there are three test given and each test has a table for heart rate, glucose level (after warm up and after sprint), lactate level (after warm up and after sprint) and then a table for sprint timings.

Perform a sample t-test and get the p values on spss which comes under (repeated anova measures) and make a graph and a SD table also.

He needs to take the average of those values for example there are 6 participants and there heart beat has been measure at 8 stages in one test so for that 1 test for those all those stages and participants he needs to take the average of that. And same goes for everything else (glucose level, lactate level and sprint time).

Also he needs to show the average:

 -heart rate of all three test in one graph,

-glucose level after warm up for all three test in one graph

-glucose level after sprint for all three test in one graph

-lactate level after warm up for all three test in one graph

-lactate level after sprint for all three test in one graph

-sprint performance for all three in one graph.

Attachment:- Assignment Files.zip