Excel assignment due in 48 hours
EXSS 6310 Project Spring 2021
1
Purpose: To determine the effect of different practice methods on acquisition and retention
Scenario: An AAU basketball coach comes to you and wants you to evaluate some data
he has collected:
1. He had read an article saying that shooting 2 free throws at a time during practice instead of 10 in a row allows for better free throw percentage. He had a practice
where his U17 (under 17) teams were split into groups. These groups performed
a free throw test at the beginning at practice. Then the players were broken into
a) athletes who shot 40 free throws in practice by shooting 2 at a time before
switching off who was shooting and b) athletes who shot 40 free throws 10 at a
time before switching off who was shooting. He then had all athletes perform
another free throw test at the end of practice. Finally, he had the athletes perform
a third free throw practice at the beginning of the next day practice. He wants to
know if the distributed (2 at a time) is actually better in the mass (10 at a time). In
particular, he wants to know: (Mass vs Distributed Sheet)
a) Which group made more free throws during the 40 attempts? Was it significantly different between the two groups?
b) Was there improvement between initial, post, and the next day percentages and did one group do better than another? Were there any significant
differences? If there were significant differences, which portions were
significantly different?
2. The AAU coach has several U12 teams he oversees. He wants to know how many free throws he should have these young athletes perform per week for
optimal performance. He has students write down how many free throws they
shot in a week and also has them perform a free throw test. He has provided that
data for you (# of Attempts sheet)
Task:
Situation 1
1) Perform a t-test comparing number of free throws made during the 40 free throw practice for the 2 groups (may be performed in excel or SPSS)
2) Perform a 2 X 3 (group X time) ANOVA with repeated measures in SPSS. a. If there are significant differences, if you remember how to perform post hocs,
do so. Otherwise perform t-tests as your post hoc tests (only if significant).
3) Graph means and standard deviations of number of free throws made per group (of the 40) use the graph to report significance (both groups 1 graph). Example of how
the graph should look is provided below (sans sd bars)
4) Graph means and standard deviations of group’s initial, post, and next day (all data one graph). Use the graph to report significance.
EXSS 6310 Project Spring 2021
2
Figure #. Title that is descriptive enough for the table to stand alone
Make sure to put in SD bars
Rationale: We first want to assess scientifically first. This gives us the answer of
“on average does this work” which is the place to start. We know the easy/hard
answer is “it’s all individual”, but we have to have some idea if it will help more
athletes than exceptions to make it a starting point.
5) Create a new sheet and copy over group, initial, post, and next day data. 6) Create two new columns: a) change pre/post b) change pre/next day. In these
columns subtract the initial from the column of interest (post or next day).
7) Once these two data sets are created, copy and paste special (values) so that the column is no longer an equation, but actual values.
8) Rank the data of each group for the two new columns. 9) Graph (bar graph) each groups individual data (so you will have initial/post group 1,
initial/post group 2, initial/next day group 1, initial/ next day group 2). An example
graph is provided.
EXSS 6310 Project Spring 2021
3
Figure 1. Individual change in free throw percentage from initial test to post test
for mass distributed athletes.
(notice that the title is not in the graph, but is written below it and describes in detail
what the graph portrays. Only the vertical axis needs to be labeled in a graph like
this.)
Rationale: While not necessary for a scientific paper, most UCA graduate students
are more clinical in nature and this type of graph allows for better assessment of
improvement or determinant of performance. By ranking the data it is easier to see
if there is a trend (however, that trend should be shown in the group means that
were previously reported). In a real case scenario, we then would look at if there
were traits similar between those who did well with this training to see why that
might be.
Situation 2
1) Plot a scatter plot of the attempts vs free throw percent. 2) If appropriate perform a Pearson’s correlation and also a regression. 3) Justify why or why not it was appropriate to perform step 2 4) From the data, how many free throws should the athletes be performing per week? 5) If you performed a regression, provide the calculated value of free throws per week.
EXSS 6310 Project Spring 2021
4
Lab Presentation Write Up
You will create a power point of the results and perform a voice over. A video will be provided
to show how to do this if you are not familiar.
Introduction:
• Provide a synopsis of what you have been asked to do. – Assume that the person evaluating you has not read your scenario/assignment – However, do be concise
Results and Discussion
o Address each task you were assigned o Typically all results would be provided and then all discussion would occur. However, for
this lab:
▪ Address each situation individually ▪ For situation 1, tasks 1 and 3, tasks 2 and 4, and tasks 5-9 should be addressed
together
▪ After discussing the 3 parts of situation 1 Answer
• What is the difference between acquisition and retention? When did the coach measure acquisition and when did he measure retention?
• What would be the “take home” message from the coaches data?
• Do the results reflect what has been discussed in class. You do not have to answer why or why not-(data was randomly generated)
• Did the coach collect the “right” data-why or why not ▪ Provide the results of situation 2 and address all other tasks assigned in situation 2 in
your discussion.
What to turn in
1. Youtube link of your presentation video
2. Excel sheet of your work and graph production
3. SPSS output of the multivariate ANOVA