View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
debo2142
 
Posts: n/a
Default Feynman Experiment


I am having trouble in a stat class we have to prepare a excel
spreadsheet and a graph for this experiment . I have no clue on how
would I begin to start if someone could assists me that would be
helpful .



The "population" for the Feynman Experiment is 100 games of 30 tosses
each. Each game is a "Sample". The objective is to prepare a table of

the number of "Heads" in successive trials of each game with 30 coins.

The result should look something like Table 1 below. I expect that
your
table will be far different! The assignment is to create your own
"Team" table for the assignment. The next step is to prepare a
graphical summary of the results as a distribution. Note: The number
of
heads may vary from 8 or 9 out of 30 to as high as 22 or 23 because it

is a distribution of probabilistic results.
See below also for some other Hints.


--
debo2142
------------------------------------------------------------------------
debo2142's Profile: http://www.excelforum.com/member.php...o&userid=31019
View this thread: http://www.excelforum.com/showthread...hreadid=506893