EXCEL Instruction I, 9/22/01
1
Getting Descriptive Statistics with EXCEL.
If one wishes to obtain descriptive statistics for the weight variable,
1) First open or create the data sheet and then click on the Tools on the menu bar and select
Data Analysis. The following dialog box will appear on the screen.
2) Select Descriptive Statistics and click OK. The following dialog box will appear. Click on
the right end of the Input Range Box that has a red arrow mark and select a range of data to
be used for calculating descriptive statistics.
When one clicks on the right end of the Input Range Box that has a red arrow mark, the
following dialog will be shown.
3) Go to the data sheet and select a range of data (by clicking and holding left button of the
mouse and dragging it through the data you wish to select) to be processed and click on the
right end lower corner of the dialog box that has a red arrow sign pointing down for entering
the data. You should see things similar to the following pictures.
EXCEL Instruction I, 9/22/01
2
4) Check Columns if the data is from a column and check the Summary statistics or other
statistics that you wish to obtain and click OK. The summary statistics will be shown on a
different worksheet. Click on that worksheet to see the statistics.
EXCEL Instruction I, 9/22/01
3
Use EXCEL to make a histogram.
1) From the descriptive statistics of the data we can define and enter the Bin values that are the
upper boundaries of classes for the histogram. The data sheet should look like the following
image. Bin values is in the right most column.
2) In EXCEL click Tools in the menu bar and select Data Analysis. You’ll see the following
dialog box. Select the Histogram and click OK.
You should then see the following dialog box.
EXCEL Instruction I, 9/22/01
4
3) Click the square box (has blue, red and white colors in it) on the right of the Input Range
box. You should see the following box. Select the range of data to be processed and click on
the square gray box on the lower right corner of