# --Calculators—

Document Sample

```					-------------------------------------------------------

--Excel—

Under "Tools" in Excel you should see a menu item called "Data Analysis". If you do not see this, complete the preliminary
step below:

****Preliminary step: Start by going to the “Tools” menu and “add-in” the Analysis Toolpak. (It usually is one of the add-
ins)*****

--Generating a list of 20 numbers, randomly generated from the uniform distribution between 0 and 12, in column A--

1. In Excel, go to Tools > Data Analysis > Random Number Generation, and click "ok"
2. For "number of variables" put 1 (you only want one list)
3. For "number of random numbers" put 20
4. For "distribution" select uniform.
5. For the parameters put between 0 and 12
6. Select "output range" and put in A1

--Creating a summary statistic chart of data --

*The following assumes the data you are using is the data set created above, that is, a list of 20 numbers located in
column A between rows 1 and 20*

1. In Excel, go to Tools > Data Analysis > Descriptive Statistics, and click "ok"
2. In Input Range put A1:A20
3. Make sure it is grouped by columns
4. Labels in the first row is *not* checked in this particular case because the first row is a data point, and not a label.
5. For output rangle, select F1 (or some other far away cell)
6. Check "summary statistics" so that you get a chart.

--Creating a histogram for a data set --

*The following assumes the data you are using is the data set created above, that is, a list of 20 numbers located in
column A between rows 1 and 20*

Before you get started, it is best to define the "cell dividers" or "bins" that tell Excel how many rectangles to use.
For the Excel project #1, where the numbers are created between 0 and 12, the best way to do this is to type in the
numbers 0 through 12 in column B. Specifically: type 0 in B1, 1 in B2, all the way up to 12 in B13. This will make cell
widths 0-1, 1-2, 2-3, ..... up to 11-12.

1. In Excel, go to Tools > Data Analysis > Histogram, and click "ok"
2. In "Input Range" type A1:A20
3. In "Bin Range" type B1:B13
4. In this particular case, "labels" is NOT checked since the first entries are values, not labels
5. Select "Output Range" and type in F20 or some other far away cell
6. Check "Chart Output" so that Excel will draw the histogram.

```
DOCUMENT INFO
Shared By:
Categories:
Stats:
 views: 4 posted: 7/2/2011 language: English pages: 1
How are you planning on using Docstoc?