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 coefcient. a) Paste the data to the second row 'om A2 to CV2. (Just the data, not your name.) b) (Type =(wlVl, B2:CV2) in an empty cell. 4. Find the conditional probabilities for a make following 3 misses, 2 misses, I miss, 1 make, 2 makes, 3 makes. You can use the program I provided. Just paste your 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 hgpwwwguantitativeskills.comfsisafstatisticsfordinalhtm a. Enter the data and do the WW runs test. b. Find the expected number of runs and the zstatistic. The zstatistic 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. Hot Hand 1. Fill in the following: p(hit | 3 misses) p(hit | 2 misses) p(hit | 1 miss) p(hit) O p(hit | 1 hit) p(hit | 2 hit) p(hit | 3 hit) p 2. Do your conditional probabilities show evidence of the hot hand? Explain. 3. Does your correlation coefficient p 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