software

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 quot;populationquot; for the Feynman Experiment is 100 games of 30 tosses
each. Each game is a quot;Samplequot;. The objective is to prepare a table of

the number of quot;Headsquot; 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
quot;Teamquot; 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: www.excelforum.com/member.php...oamp;userid=31019
View this thread: www.excelforum.com/showthread...hreadid=506893People around here will generally not do your homework for you, but will try
to help you figure out how to do it for yourself. For the first part of your
assigment, you might find the RANDBETWEEN function useful. It requires that
you have installed the Analysis ToolPak (ATP). Help for RANDBETWEEN includes
directions for installing the ATP if you have not already done so.

Also in the ATP is a histogram tool, that you might find helpful for the
second part of your assigment. If you get stuck, post back with a
description of what you have tried, and why the results were not satisfactory.

Jerry

quot;debo2142quot; wrote:

gt;
gt; I am having trouble in a stat class we have to prepare a excel
gt; spreadsheet and a graph for this experiment . I have no clue on how
gt; would I begin to start if someone could assists me that would be
gt; helpful .
gt;
gt;
gt;
gt; The quot;populationquot; for the Feynman Experiment is 100 games of 30 tosses
gt; each. Each game is a quot;Samplequot;. The objective is to prepare a table of
gt;
gt; the number of quot;Headsquot; in successive trials of each game with 30 coins.
gt;
gt; The result should look something like Table 1 below. I expect that
gt; your
gt; table will be far different! The assignment is to create your own
gt; quot;Teamquot; table for the assignment. The next step is to prepare a
gt; graphical summary of the results as a distribution. Note: The number
gt; of
gt; heads may vary from 8 or 9 out of 30 to as high as 22 or 23 because it
gt;
gt; is a distribution of probabilistic results.
gt; See below also for some other Hints.
gt;
gt;
gt; --
gt; debo2142
gt; ------------------------------------------------------------------------
gt; debo2142's Profile: www.excelforum.com/member.php...oamp;userid=31019
gt; View this thread: www.excelforum.com/showthread...hreadid=506893
gt;
gt;