Formulas & Equations:
We will now see how to manipulate data in Excel. This might be as simple as sorting values and calculating simple sums, or using a calibration equation to analyze experimental data. Although generate highly complex equations, we will start with very simple ones. Before we begin, note the table of operators below used in numerical computing. These are not exactly the same as you would see written elsewhere, but they mean the same thing.
Task | Operator | Example | Result |
---|---|---|---|
Multiplication | * | 2*3 | 6 |
Division | / | 4/2 | 2 |
Exponent | ^ | 2^3 | 8 |
Order of Operations | (..) | 2*3+5 or 2*(3+5) | 11 or 16 |
Power of ten | e or E | 3.2E+2 or 3.2e-2 | 320 or 0.032 |