The management of your team wants to compare the team with the assigned team (the Bulls in 1996-1998). They claim that the skill level of your team in 2013-2015 is the same as the skill level of the Bulls in 1996 to 1998. In other words, the mean relative skill level of your team in 2013 to 2015 is the same as the mean relative skill level of the Bulls in 1996-1998. Test this claim using a 1% level of significance. Assume that the population standard deviation is uknown. Make the following edits to the code block below: Replace ??DATAFRAME_ASSIGNED_TEAM?? with the name of assigned team's dataframe. See Step 1 for the name of assigned team's dataframe.
Replace ??DATAFRAME_YOUR_TEAM?? with the name of your team's dataframe. See Step 2 for the name of your team's dataframe.
Replace ??RELATIVE_SKILL?? with the name of the variable for relative skill. See the table included in Project Two instructions above to pick the variable name. Enclose this variable in single quotes. For example, if the variable name is var2 then replace ??RELATIVE_SKILL?? with 'var2'.
game_id year_id fran_id pts opp_pts elo_n opp_elo_n game_location game_result
199511030CHI 1996 Bulls 105 91 1598.2924 1531.7449 H W
199511040CHI 1996 Bulls 107 85 1604.3940 1458.6415 H W
199511070CHI 1996 Bulls 117 108 1605.7983 1310.9349 H W
199511090CLE 1996 Bulls 106 88 1618.8701 1452.8268 A W
199511110CHI 1996 Bulls 110 106 1621.1591 1490.2861 H W
Bulls is my assigned team
game_id year_id fran_id pts opp_pts elo_n opp_elo_n game_location game_result
201210300MIA 2013 Celtics 107 120 1586.1121 1666.3193 A L
201211020BOS 2013 Celtics 88 99 1566.8929 1520.3861 H L
201211030WAS 2013 Celtics 89 86 1571.9491 1435.2531 A W
201211070BOS 2013 Celtics 100 94 1574.5995 1432.6027 H W
201211090BOS 2013 Celtics 100 106 1562.3982 1541.7600 H L
I picked Celtics as my team
After you are done with your edits, click the block of code below and hit the Run button above.
import scipy. stats as st
mean_elo_n_project_team = assigned_team_df['elo_n'].mean()
print("Mean Relative Skill of the assigned team in the years 1996 to 1998 =", round(mean_elo_n_project_team,2)) mean_elo_n_your_team = your_team_df['elo_n'].mean()
print("Mean Relative Skill of your team in the years 2013 to 2015 =", round(mean_elo_n_your_team,2))
# Hypothesis Test
# TODO: make your edits here
test_statistic, p_value = st. ttest_ind(??DATAFRAME_ASSIGNED_TEAM ??[??RELATIVE_SKILL??], ??DATAFRAME_YOUR_TEAM??[??RELATIVE_ SKILL??])
print("Hypothesis Test for the Difference Between Two Population Means")
print("Test Statistic =", round(test_statistic,2))
print("P-value =", round(p_value,4))