Professor Kate Poirier | OL67 | Fall 2020

Project 2.1

Where did this formula for “Actual” come from?

looks like:

where B5 will be a value of x, 1 for this row.

$=\frac{1}{e^{B5*B5}}*((\frac{1}{B5^2})+1)$

I’m having difficulty conceptualizing this so far but maybe the “actual” will help me get it.

This is where I am currently:

2 Comments

  1. Kate Poirier

    Hi Oscar. In the example spreadsheet the differential equation is one that we can actually solve analytically using the methods of chapter 2. So the “actual” column is the value of the actual solution evaluated at the appropriate x coordinate. The error is just the difference between the actual value and the approximate value obtained by the relevant numerical method.

    You won’t actually be solving the differential equations for this project, so you can ignore the “actual” and “error” columns.

  2. Oscar

    Ok, thank you

Leave a Reply

Your email address will not be published. Required fields are marked *