Math 499 Numerical Analysis
Assignment 1
Use excel to make up a class roster like the one shown in Figure 1.
Have excel calulate averages. Exams count 30% each. Problems and lab count
20% each. For exams one and two the maximum grade is 100. For problems
Introduction to Excel
Excel is a spreadsheet. It allows you to display information in an organized manner. Not only does Excel
display information, but it can also make calculations and display mathematical information in graphical
form. These properties
Excel for Numerical Integration
J. C. Daly
Here we use Excel to evaluate the integral of x2 from zero to an arbitrary upper limit, a.
As shown in Figure 1, three columns were used.
The first is the upper limit. This is also the value of x.
The second colu
Numerical Integration
J. C. Daly
Figure 1 The integral is the area under the
curve.
Figure 2 The rectangular area approximates
the integral.
Figure 3 The area of the trapazoid
approximates the integral.
Figure 4 More accuracy is achieved by
representing t
Math 499 Numerical Analysis
Assignment 7
Read the tutorial VBA Control Button.
First Order Differential Equation
In this assignment we will solve the first order differential equation,
where y = 0 at x = 0.
Use a visual basic subroutine.
Read parameters f
Math 499 Numerical Analysis
Assignment 3
Numerical Integration
Read the tutorial on numerical integration.
Research the web for information on numerical integration. Read about numerical
integration at Wikipedia.
1. Plot the following function
2. Evaluate
Math 499 Numerical Analysis
Assignment 5
Regression
The temperature dependence of resistance is modeled by the equation,
where R is in Ohms, T is in degrees centigrade, and T0 is 27 o C,
Determine R0 and the constants,
and
.
Measured values of resistance
Math 499 Numerical Analysis
Assignment 2
Design a parachute for Mary Bird. Her mass is 50 kg and she wishes to reach the
ground at a vertical speed of 10 mph (4.47 m/s). Assume the parachute drag force is
given by,
FD = r Cd A v 2
Where
FD is the drag for
Math 499 Numerical Analysis
Assignment 6
Numerical Differentiation
Research the web for information on numerical differentiation. Read about numerical
differentiation at Wikipedia.
Forward approximation
Backward approximation
3 point approximation
where
F
Math 499 Numerical Analysis
Assignment 8
Read the tutorial Excel 2007 Tutorial on solving Laplace's equation.
Obtain a numerical solution to Laplaces equation for V in the region,
-10 < x < 10
0 < y < 10
where V is zero when x = -10, y = 0, and y = 10, an
Math 499 Numerical Analysis
Assignment 4
Visual Basic
The tutorial containing the visual basic example code, has a function called
"Trapezoidal". This function integrates an arbritary function using the trapezoidal rule.
Write similar code to integrate th
Math 499 Numerical Analysis
Assignment 9
Read the tutorial http:/www.thsengineering.com/2010/04/thermal-heat-transferfinite-element-analysis-excel/ on heat transfer finite element analysis.
Construct an example that illustrates the ideas discussed in the
Math 499 Numerical Analysis
Assignment 11
This assignment is a project of your choosing.
Use excel to solve a problem or describe a system.
Projects similar to homework assignments are a possibility.
Write a report for this assignment. Use charts where ap
Math 499 Numerical Analysis
Assignment 10
Read the paper
http:/www.geology.und.nodak.edu/gerla/gge220/finite_difference.htm on
groundwater flow.
Complete the assignment in the paper.
The figure below shows a function that counts the number of iterations r
Linear Motion
In this lab we do a computer simulation of linear motion.
Part 1
An object starts at rest and moves with constant acceleration in one direction.
Use Excel to calculate velocity and position,
plot the position and velocity as a function of ti