Start up Excel' Notice that each row has a number, and each column has a letter' Click in A1 column

1
Start up Excel. Notice that each row has a
number, and each column has a letter. Click in
A1 (column A, row 1), and type in a title for
your data
2
Now below that header, enter your data, one value
in each line.
3
Near your data, enter the names mean, std dev,
min, Q1, median, Q3, max
4
Now click in the cell to the right of the name
mean (D2 in my example). Type in
average(A2A20) And press ENTER This will
calculate the average (mean) of the data starting
in A2 and going to A20
5
In the cell next to std dev, Type in
stdev(A2A20) In the cell next to min, Type
in min(A2A20) In the cell next to Q1, Type
in quartile(A2A20,1) In the cell next to
median, Type in median(A2A20) In the cell
next to Q3, Type in quartile(A2A20,3) In
the cell next to max, Type in max(A2A20)
6
Now lets create a frequency distribution. Click
on cell C10, and type in a description for each
of your classes.
7
Starting at D10, type a list of your upper class
limits.
8
Now, use the mouse to highlight (click and drag)
cells E10 through E14 Type in
frequency(A2A20,D10D14) Then hold down Ctrl
and Shift while you press Enter. Note that
A2A20 are the cells holding your data, and
D10D14 are the cells containing upper class
limits
9
Highlight cells C10 through C14, then hold down
Ctrl while clicking and dragging to also
highlight cells E10E14.
10
Click on the chart tool in the toolbar
11
Click Next twice. Enter a title and axes labels
for your chart. If you want, you can use the
tabs across the top to turn off the legend.
12
Click Next twice. Enter a title and axes labels
for your chart. If you want, you can use the
tabs across the top to turn off the legend.
13
Click Finish to complete the graph
14
To make it look more like a histogram,
right-click on the bars, and select Format Data
Series. Choose the Options tab, and set the gap
width to 0.
This graph can now to cut-and-pasted into Word or
PowerPoint.