Add or Subtract Two NumbersIn a new column, select the cell in the first row with data, type:

=

Click on the cell in that row with the first number:

+ (for addition) or - (for subtract).

Click on the cell in that row with the second number.

Click on the check mark. The difference should appear.

Highlight that column and useEdit, Fill Downto apply that equation for the entire column of numbers.

Multiply or Divide Two NumbersIn a new column, select the cell in the first row with data, type:

=

Click on the cell in that row with the first number:

* (for muliply) or / (for divide).

Click on the cell in that row with the second number.

Click on the check mark. The product or quotient should appear.

Highlight that column and useEdit, Fill Downto apply that equation for the entire column of numbers.

Set Up an EquationTo set up equations, you need to know how to:

- Add, subtract, multiply and divide (see above).
- Create an exponent: use the symbol ^ which is shift 6, e.g., 6^2 means 6*6.
- Write scientific notation: just add E and the exponent e.g., 2E3 means 2000.
- Write functions: SQRT( ) for square root, COS( ) for cosine, etc.

Bin Data

Set up bins:Figure out the first and last value of your data range and the size bin you want to use.

See histogram helpMake a new column of the bins: Write the first bin number. Use

Edit, Fill, Seriesto count by 10s (or whatever you bins size is) until you get to the last bin number.

Find frequency:Choose Tools, Data Analysis, Histogram. If you do not see Data Analysis under tools, your version of Excel probably needs an add-on that includes this option. Check with your teacher.

ForInput Range, click, highlight, and drag the values in the column that has the data you want to bin.

The box should read something like this: $K$2:$K$1000 (depending on number of data cells).For Bin Range, do the same except use the bin values.

The box should read something like this: $M$2:$M$52 (depending on how many bins you chose).Click on

New Worksheet, OK.

You should see a new page open up with two columns similar to the table on the right.

Bin

Frequency

20

3

22

13

120

2

Plot Histogram - Frequency vs. Bin Data

Highlight the bin and frequency columns. Click on the icon for

Chart Wizard(looks like bar graph).Choose Column. Next

Series: Only the frequency should be listed.Next

Add titles and gridlines.Next

Give it a name.

ALErzberger@lbl.gov

Web Maintainer: qnet-webmaster@fnal.gov

Last Update: April 13, 2001

http://quarknet.fnal.gov/run2/excel.html