Lab 5 -- Maple and Excel Lab: Graphing Surfaces NAME ___________________
The purpose of this lab is to graph the surface z = x2 -2xy2 with both Maple and Excel
Maple
typical command:
plot3d(x^2-2*y^2*x,x=-2..2,y=-2..2);
variations on printout
Standard wireframe (hidden-surface), with a box to get the orientation
Contour plot
Level curves
Excel
You must start by generating an array of function values for ordered pairs (x,y)
Enter the y-values in column A, beginning in cell A2.
Enter the x-coordinates in row 1, beginning in cell B1.
Use the same function z = x2 -2xy2
In cell B2, type the formula =B$1^2 - 2*B$1*$A2^2
Drag this formula down to fill in all the cells in column B of your table.
With the same cells highlighted (all the z-values in column B),
drag the entire column to the right to fill in the entire table.
Then, highlight the entire table, including the x- and y-coordinates.
The first part of my table looked like this:
|
|
-2 |
-1.8 |
-1.6 |
-1.4 |
-1.2 |
-1 |
|
2 |
20 |
17.64 |
15.36 |
13.16 |
11.04 |
9 |
|
1.8 |
16.96 |
14.904 |
12.928 |
11.032 |
9.216 |
7.48 |
|
1.6 |
14.24 |
12.456 |
10.752 |
9.128 |
7.584 |
6.12 |
|
1.4 |
11.84 |
10.296 |
8.832 |
7.448 |
6.144 |
4.92 |
|
1.2 |
9.76 |
8.424 |
7.168 |
5.992 |
4.896 |
3.88 |
|
1 |
8 |
6.84 |
5.76 |
4.76 |
3.84 |
3 |
|
|
|
|
|
|
|
|
You should extend the table so that both x and y extend from −2 to 2
Use the graph wizard to generate a surface plot. Mine looked like this:
Can you rotate the view as you do in Maple?
Try clicking on a corner of the graph, then click-and-hold-and-drag (on a corner).
Note the use of color to show the contours. If you can print in color, do so.
Return to: Merced College; Don Power Updated 07/10/06 by Don Power