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

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.

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 36 minutes ago

asked 40 minutes ago

asked 58 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 3 hours ago

asked 3 hours ago

asked 3 hours ago