Use of technology

Welcome to the World of Numerical Methods!

In your Further Mathematics journey, you will often encounter equations that are impossible to solve using traditional "exact" methods (like the quadratic formula). This is where Numerical Methods come to the rescue! Because these methods involve repeating the same calculation over and over, we use technology to do the heavy lifting. In this chapter, we will look at how to use spreadsheets and calculators to find answers quickly and accurately.

1. Mastering the Spreadsheet

A spreadsheet (like Excel or Google Sheets) is essentially a giant grid of calculators that can talk to each other. It is the perfect tool for numerical methods because it can handle hundreds of iterations in a split second.

Understanding Cell References

Each box in a spreadsheet is called a cell. We identify them using the Column Letter and the Row Number.

Example: Cell B4 refers to the box in Column B, Row 4. If you see a formula in your exam that mentions B4, it’s just looking at the value stored in that specific box.

The Magic of the "IF" Function

The syllabus specifically requires you to understand the =IF() function. This allows the spreadsheet to make decisions. It follows this simple pattern:

=IF(condition, value_if_true, value_if_false)

Analogy: Imagine your parents say, "If it is raining, take an umbrella; otherwise, wear sunglasses."
In spreadsheet terms, this is: \( =IF(\text{weather} = \text{"rain"}, \text{"umbrella"}, \text{"sunglasses"}) \)

In Numerical Methods, we might use this to check if a sign has changed in the Bisection Method or to see if our error is small enough to stop.

Implementing Iteration

To perform a calculation like \( x_{n+1} = g(x_n) \):

1. Put your starting value (\( x_0 \)) in cell A2.
2. In cell A3, type a formula that refers to A2. For example: \( = (A2 + 2/A2) / 2 \).
3. "Click and drag" the corner of cell A3 downwards. The spreadsheet automatically updates the formula for each row (so A4 looks at A3, A5 looks at A4, etc.).

Quick Review: Spreadsheets are great for seeing many steps at once. You need to be able to explain what a formula in a specific cell is doing!

2. Using Your Calculator Effectively

While spreadsheets are great for coursework or big data, your scientific or graphical calculator is your best friend in the exam hall. Specifically, you need to use its iterative capability.

The "ANS" Button Trick

Don't worry if you find typing long formulas exhausting! You can use the ANS (Answer) key to create a "loop" on your calculator. This is much faster and prevents typing errors.

Step-by-Step Example: Solve \( x_{n+1} = \sqrt{x_n + 2} \) starting with \( x_1 = 2 \).
1. Type 2 and press = (This stores '2' in the calculator's memory).
2. Type the formula using the ANS key: \(\sqrt{ANS + 2}\).
3. Press =. This gives you \( x_2 \).
4. Press = again. This gives you \( x_3 \).
5. Keep pressing = to watch the numbers converge (get closer) to the root!

A Crucial Exam Warning

Important Point: Even though modern calculators have "Solve" or "Integration" buttons, the examiners want to see your method. You must show the steps of the numerical method (like the first few iterations) to get full marks. Technology is there to help you calculate, not to do the thinking for you!

Key Takeaway: The ANS button turns your calculator into an iteration machine. Use it to find \( x_1, x_2, x_3... \) rapidly.

3. Interpreting the Results

Using technology is only half the battle; you also need to understand what the screen is telling you. The syllabus asks you to comment on errors and convergence.

Convergence: Are we getting there?

When you use technology for an iterative sequence, watch the decimal places. If the numbers stop changing (e.g., the first 4 decimal places stay the same for several steps), your sequence has converged.

Error and Accuracy

Technology allows us to see how the "gap" between our approximation and the true answer shrinks.
- Absolute Error: The difference between the approximate value and the exact value \( (X - x) \).
- Relative Error: The absolute error divided by the true value \( (\frac{X-x}{x}) \).

Common Mistakes to Avoid

1. Rounding too early: If you round your numbers in the middle of a spreadsheet or calculator loop, the error will grow. Let the technology keep all the decimals until the very end!
2. Input Errors: In a spreadsheet, forgetting the = sign at the start of a formula means it won't calculate anything.

Did you know? The "Order of Convergence" tells you how fast a method finds the answer. For example, the Newton-Raphson method usually converges much faster than the Bisection Method because it has a "higher order" of convergence.

Summary Checklist

- Can you identify a cell (like C5) and explain what its formula does?
- Do you know how to use the =IF() function in a spreadsheet context?
- Can you use the ANS button on your calculator to perform 10 iterations in 10 seconds?
- Can you explain whether a sequence is converging based on spreadsheet output?

Don't worry if these methods seem a bit abstract at first. Once you sit down with a calculator and try the "ANS" trick, or open a spreadsheet and drag a formula down, it will all click into place!