Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Normal Winners

Recently, 1,158 participants selected the winner, against the spread, of 19 NCAA College Football bowl games. I, being one of those participants, selected 8 correct winners - not my best effort. Let’s see how everyone else did. And the data Wins Players Normal 0 0 0 1 0 0 2 0 0 3 1 2 4 6 7 5 31 22 6 77 55 7 145 108 8 196 170 9 217 213 10 209 213 11 160 170 12 68 108 13 38 55 14 6 22 15 4 7 16 0 2 17 0 0 18 0 0 19 0 0 1158 1154 The formula in column C is =ROUND(NORMDIST(A2,AVERAGE($A$2:$A$21 Read More...

Read the complete post at http://www.dailydoseofexcel.com/archives/2011/01/03/normal-winners/


Posted Jan 03 2011, 09:17 AM by Daily Dose of Excel
Filed under:
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.