Question

So I am doing a statistic project on 2 basketball players. I am observing their 3PT percentages for every game played in a season. Player two has a higher average 3pt%, lower standard error. Payer 1 played 78 games, player 2 played 69.

I ran a TTEST ( =TTEST(B2:B70,A2:A79,1,3) )

B2:B70 was the array with the 3pt %s for player 2 for the games played in the season and A2:A79 was the array for player ones 3pt %s for the games they played in the season.

I put 1 tail and 3

ttest gave me 0.068419

What does this ttest result mean? What would be the hypothesis and null hypothesis?

Answer 1

Null hypothesis: Player 2 has not scored a significantly higher average 3pt% than Player 1.
Alternative hypothesis: Player 2 has scored a significantly higher average 3pt% than Player 1.

The one tailed (denoted by 1) two sample unequal variance t-test (denoted by 3) has been carried out using the TTEST function of MS Excel. The value that you are getting is the p-value of this test. Since this p-value is greater than the 5% significance level (0.05), we fail to reject the null hypothesis.
We conclude that there is not enough evidence to suggest that Player 2 has scored a significantly higher average 3pt% than Player 1.