Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I need to create a 7 bubble answer sheet for an experiment. | Excel Discussion (Misc queries) |