2023 Project 5 Hot Hand 1 Enter the data on a spreadsheet Put your name in cell A1 and | Assignments Online

Project 5

Hot Hand

 

1.  Enter the data on a spreadsheet.  Put your name in cell A1 and enter the 1’s and 0’s across the row from B1 to CW1.  (You should have done this already in project 1.)

2.  Find your shooting percentage.  (Just sum the data and divide by 100). 

3.  Find the correlation coefficient.

a.  Paste the data to the second row from A2 to CV2.  (Just the data, not your name.)

b.  (Type =CORREL(B1:CV1, B2:CV2) in an empty cell.

4.  Find the conditional probabilities for a make following 3 misses, 2 misses, 1 miss, 1 make, 2 makes, 3 makes.  You can use the program I provided.  Just paste you data over mine in the top row.

5.  Enter the statistics in the space provided.  Note that this is the same data that is in the table on the Philadelphia 76ers in the hot hand article.

6.  Interpret your results in the space provided.

7.  Next, count the number of runs in your series.  For example the series 11001110 has 4 runs.  .

8.  Go to http://www.quantitativeskills.com/sisa/statistics/ordinal.htm

                a.  Enter the data and do the WW runs test.

                b.  Find the expected number of runs and the z-statistic.  The z-statistic is the number of standard deviations that your outcome lies from the mean of the distribution of runs.

9.  Show where your runs number falls on the normal distribution provided.

10.  Enter the statistics in the space provided.

11.  Interpret your results in the space provided.

 

Name _____________

Assignment Sheet

Assignment #5

Hot Hand

 

1.  Fill in the following

 

prob(hit/3 misses)   prob(hit/2 misses)   p(hit/1 miss)   p(hit)   p(hit/1hit)   p(hit/2 hits)   p(hit/3 hits)      ρ

 

 

2.  Do your conditional probabilities show evidence of the hot hand?  Explain.

 

 

 

3.  Does your correlation coefficient ρ show evidence of the hot hand?  Explain.

 

 

4.  Fill in the following.

hits                   misses              runs                  expected runs               z-statistic

 

 

 

5.  Show where your runs number falls on the distribution.

 

 

 

6.  Is this evidence of the hot hand?  Explain.