Step 6: Hypothesis Test for the Difference Between Two Population Means 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 unknown. 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_idyear_idfran_idptsopp_ptselo_ nopp_elo_ngame_locationgame_result< br /> 199511030CHI1996Bulls105911598.2924 1531.7449HW
199511040CHI1996Bulls107851604.3940 1458.6415HW
199511070CHI1996Bulls1171081605.798 31310.9349HW
199511090CLE1996Bulls106881618.8701 1452.8268AW
199511110CHI1996Bulls1101061621.159 11490.2861HW
Bulls is my assigned team
game_idyear_idfran_idptsopp_ptselo_ nopp_elo_ngame_locationgame_result< br /> 201210300MIA2013Celtics1071201586.1 1211666.3193AL
201211020BOS2013Celtics88991566.892 91520.3861HL
201211030WAS2013Celtics89861571.949 11435.2531AW
201211070BOS2013Celtics100941574.59 951432.6027HW
201211090BOS2013Celtics1001061562.3 9821541.7600HL
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))
Any help would be appreciated and Thank You