Excel Help

Add or Subtract Two Numbers In 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 use Edit, Fill Down to apply that equation for the entire column of numbers.


Multiply or Divide Two Numbers In 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 use Edit, Fill Down to apply that equation for the entire column of numbers.


Set Up an Equation To 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 help

Make a new column of the bins: Write the first bin number. Use Edit, Fill, Series to 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.
For Input 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.