JOB 1. Use of graphic opportunities of MS Excel

1. Construct a function graph у = cos²(px) with хÎ[0, 1]:

1.1.In cells А1, В1 Листа1 enter according values Х, Y with step 0.1

1.2.In cell В2 enter formula =cos(ПИ()*А2)^2 and copy this formula into block of cells В3:В12

1.3.Mark out values Х and У, exert master of charts, choose the chart Diagram, correctly fill dialogue fields

2. Construct in one system of coordinates of graphics of the following functions at хÎ[-2, 2] with step 0.2:

У= Z=

Note: in cell В2 enter formula =ЕСЛИ(А2<=0;6*sin(A2)^2-cos(A2); 4*A2^3*sin(A2)^2)

in cell C2 enter formula =ЕСЛИ(А2<0;(10+2*A2^2)/(1+A2^2);ЕСЛИ(И(А2>=0;A2<=1);sin(A2)^2;cos(A2)^2*exp(0,5*A2)))

JOB 2. Creation of function graphs

1. To construct in one system of coordinates of graphics of the following functions at хÎ[-2; 2]: y=2sin(x)cos(x) z=3cos²(x)sin(x)

1.1. In the cells А1, В1, nd С1 Листа2 enter according Х, Y и Z

1.2. In the range of cells А2:А22 enter values of argument Х from -2 to 2 with step 0.2

In the cell В2 and С2 enter formula =2*sin(А2)*cos(А2) and =3*cos(А2)^2*sin(А2) accordingly

Copy these formulas into block of cells В3:С22

Mark all of the table and create the chart Diagram

2.Create the chart of function with three conditions when хÎ[-1.5; 1.8] with step 0.2:

JOB 3.

Create the chart of function with two conditions whenхÎ[-1.8; 1.8] with step 0.2

in the cells А1, В1 enter accordingly Х, Y

in the range of cells А2:А20 enter values of argument Х from -1.8 to 1.8 with step 0.2

in the cell В2 enter the formula with the help of Master of functions: =ЕСЛИ(A2<=0;(3+sin(A2))/(1+A2^2);2*A2^2*cos(A2)^2) and copy the formula into the range of cells В3:В20 create the table of functions.

JOB 4.

On the Page4 create in different systems of coordinates when хÎ[-1.4;1.9] with step 0.2 charts of following functions:

JOB 5.

Creation of surface. Solution of the equations with the method of selecting parameters

1. On a blank work sheet construct a surface z=3e^0.3xx³-3y⁴ when х, y Î[-1, 1]with changing step 0.2,for it:

· In the range of cells А2:А12 enter following of values of changing Х with step 0.2 (in А2 enter «-1», in А3 enter «-0,8», mark these two cells and «stretch» to А12)

· In the range of cells B1:L1enter following of values of changing Y with step 0.2 (in B1 enter «-1», in С3 enter «-0,8», mark these two cells and «stretch» to L1)

· In the cell В2 enter formula =3*EXP(0,3*$A2)*$A2^3-3*B$1^4 and with the help of filling marker fill the block of cells B2:L12 with correspondind formulas.

Mark the range of formulas А1:L12 and create the chart Surface

2. Create in different systems of coordinates of surfaces when x, yÎ [-1,1] with step 0.2

z₁=x²-3y² z₂

2x² – e^y, if çx + y½ < 0.5,

z₃ = xe^2x – y, if 0.5 £½x + y½< 1

2e^x–ye^y, if 1 £ çx + yç.

x - e^2y, if |x| + |y| < 0.5,

z₄ = 2x² - e^y, if 0.5 £ |x| + |y| < 1

e^2x - y, if 1 £ |x| + |y|

3. Solve an equation х³-0,01х²-0,7044х+0,139104=0 by trial and error, for it:

3.1. Enter into cell А2 value «–1», into cell А3 value «–0,8». Marking these two values, stretch the filling marker (dagger in the right bottom corner of a cell) till value «1».

In the cell В2 enter formula: =А2^3-0.01*A2^2-0.7044*A2+0.139104 (left part of equation), with the filling marker fill the other values 3.3. Note that the function change the sign on intervals [-1;-0.8], [0.2;0.4], [0.6;0.8], thus it is reasonable to take average points of intervals for initial approximations of a root. Enter them in the cells С2; С3; С4

3.4. In the cell D2 enter the formula: =С2^3-0.01*С2^2-0.7044*С2+0.139104, with the filling marker stretch the other values.

3.5. Mark the cell D2 .

3.6. Choose the command Service/Selection of parameter. On the screen the Parameter Selection window will be displayed, in the field to Establish in a cell the cell will be displayed D2, in the field Value enter 0. Here value of the right part of equation is specified. In the field Changing value of a cell enter С2, using the reference to this cell, e.i. with the mouse. In this field the reference to the cell which has been taken away under a variable is given.

3.7. Enter ОК.

3.8. Similarly in cells of C3 and C4 there are two remained roots.

3.9. In the graphic way show equation roots, i.e. construct a function graph y.

4. Create the surface х, у Î[-1;1] on variations (column «Task№ 1»)

5. Find the roots of equation on variations (column «Task№ 2»)

Date: 2015-12-24; view: 1932